【详述】问题详细描述
查询sql 为
select distinct user_id from mds_log_weblog_expo WHERE dt >= $st_dt$ AND dt <$end_dt$
AND item_code =$item_code$ order by user_id
这个是正常的
因数据量大,一页放不下的时候就分页了,点击分页的时候报错
StatementCallback; bad SQL grammar [SELECT
user_id FROM (select distinct user_id from mds_log_weblog_expo WHERE dt >= date_sub(CURDATE(),1) AND dt <CURDATE() AND item_code =‘727383477’ order by user_id) T LIMIT 20, 20]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: OFFSET requires an ORDER BY clause: LIMIT {}, {}
如果是单独把order by 加下子查询外面是可以运行的,但是用davinci查,就报错了
也配置了 set enable_spilling =true; 还是报错