【代码报错】InvalidInputException: Invalid Input Error & Error: Permission Error
由bqb0ggza创建,最终由small_q 被浏览 15 用户
alpha_a191_f0017 因子无法使用,报错
import dai
sql = """
SELECT
date,
instrument,
factor
FROM alpha_a191_f0017
ORDER BY date, instrument;
"""
df_all = dai.query(sql).df()
df_all
我按照这个命令执行 为什么这个因子无法调用会报错?报错信息如下:
日志 1 条 ▼
---------------------------------------------------------------------------
InvalidInputException Traceback (most recent call last)
Cell In[3], line 10
1 import dai
2 sql = """
3 SELECT
4 date,
(...)
8 ORDER BY date, instrument;
9 """
---> 10 df_all = dai.query(sql).df()
11 df_all
File /var/app/enabled/dai/_telemetry.py:150, in wrapper(*args, **kwargs)
File /var/app/enabled/dai/_functions.py:90, in df(self)
InvalidInputException: Invalid Input Error: Attempting to execute an unsuccessful or closed pending query result
Error: Permission Error: 请在查询表 alpha_a191_f0017 时使用 filters 参数指定分区范围(一般为 date 或 instrument ):dai.query(sql, filters={"date": ["2020-01-01", "2020-02-01"]})。若确需全表扫描,请设置 full_db_scan 参数:dai.query(sql, full_db_scan=True)
\