问答交流

技术因子(cn_stock_factors_ta)表不存在

由bqlf38ns创建,最终由small_q 被浏览 40 用户

使用数据平台的用例调用表cn_stock_factors_ta,结果显示表不存在,你们能有空处理下吗?

import dai

dai.query("""
SELECT date, instrument, bbands_u
    FROM cn_stock_factor_ta
    WHERE instrument = '000002.SZ' 
    AND date >= '2022-01-01' and date <= '2022-12-31';"""
).df()
  • \
    ---------------------------------------------------------------------------
    InvalidInputException                     Traceback (most recent call last)
    Cell In[7], line 3
          1 import dai
    ----> 3 dai.query("""
          4 SELECT date, instrument, bbands_u
          5     FROM cn_stock_factor_ta
          6     WHERE instrument = '000002.SZ' 
          7     AND date >= '2022-01-01' and date <= '2022-12-31';"""
          8 ).df()
    File /var/app/enabled/dai/_functions.py:57, in df(self)
    InvalidInputException: Invalid Input Error: Attempting to execute an unsuccessful or closed pending query result
    Error: Catalog Error: Table with name cn_stock_factor_ta does not exist!
    Did you mean "temp.information_schema.schemata"?
    

\

评论
  • 你仔细看下,提示的是
  • 哦,了解了,不过我把它放到读取数据的模块里面,又不能读取了,不知道是为什么
{link}