【代码报错】这个表有问题而且不完整，在sql提取不了

由bq30zy4n创建，最终由small_q更新于2025-02-16 02:42 被浏览 21 用户

https://bigquant.com/codeshare/16153eb4-8ecb-4e4d-8d66-8b6ad8af12ae

• \

  ---------------------------------------------------------------------------
  ParserException                           Traceback (most recent call last)
  Cell In[1], line 66
       29 m1 = M.input_features_dai.v6(
       30     sql="""-- 使用DAI SQL获取数据，构建因子等，如下是一个例子作为参考
       31 -- DAI SQL 语法: https://bigquant.com/wiki/doc/dai-PLSbc1SbZX#h-sql%E5%85%A5%E9%97%A8%E6%95%99%E7%A8%8B
     (...)
       62 """
       63 )
       65 # @module(position="-981,-294", comment='6. 预测数据，设置预测时间，开启模拟交易时绑定交易日期', comment_collapsed=True)
  ---> 66 m7 = M.extract_data_dai.v7(
       67     sql=m1.data,
       68     start_date='2024-01-01',
       69     start_date_bound_to_trading_date=True,
       70     end_date='2024-01-23',
       71     end_date_bound_to_trading_date=True,
       72     before_start_days=90,
       73     debug=False
       74 )
       75 # </aistudiograph>
  File module2/common/modulemanagerv2.py:88, in biglearning.module2.common.modulemanagerv2.BigQuantModuleVersion.__call__()
  File module2/common/moduleinvoker.py:370, in biglearning.module2.common.moduleinvoker.module_invoke()
  File module2/common/moduleinvoker.py:292, in biglearning.module2.common.moduleinvoker._invoke_with_cache()
  File module2/common/moduleinvoker.py:253, in biglearning.module2.common.moduleinvoker._invoke_with_cache()
  File module2/common/moduleinvoker.py:210, in biglearning.module2.common.moduleinvoker._module_run()
  File /var/app/data/custom_module/publicmodules/extract_data_dai/v7/__init__.py:99, in run(sql, start_date, start_date_bound_to_trading_date, end_date, end_date_bound_to_trading_date, before_start_days, debug)
       96     query_start_date = start_date
       98 logger.info(f"{start_date=}, {end_date=}, {query_start_date=} ..")
  ---> 99 data = dai.query(sql, filters={"date": [query_start_date, end_date]}).df()
      101 if "date" in data.columns:
      102     data = data[(data["date"] >= start_date) & (data["date"] <= end_date)]
  File /var/app/enabled/dai/_functions.py:121, in query(sql, udf_list, full_db_scan, filters)
  ParserException: Parser Error: syntax error at or near "select"
  LINE 8:     -- 在时间截面的total_market_cap排名
  

\