【代码报错】InvalidInputException: Invalid Input Error & Error: Permission Error

由bqb0ggza创建，最终由small_q更新于2024-10-11 02:06 被浏览 23 用户

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)

\