Presto常见报错

报错：Error: Query failed (#20210610_124834_03281_zqazj): Query exceeded maximum time limit of 1800.00s

报错原因： 计算的表数据量较大超过320亿行，可适当修改sql，或改用别的引擎

报错：

Error: Query failed (#20210526_084418_01979_zqazj): Hive views are not supported: 'dm_test.transform_par_secview'

解决办法：presto查询不支持视图表，切换为对应的原表即可

报错：

Error: Query failed (#20210526_085736_02043_zqazj): SQL array indices start at 1

解决方法： presto数组下标从1开始，而不是0 

报错：

报错sql为：

select
  ds as "日期",
  sum(login_cnt) as "登录人数"
from
  dm_gamelog_account_ds
where
  gameid = 94
  and cast(group_type as integer)= 99
  and cast(player_type as integer) = 99
  and ds between '20170326'
  and '20170427'
group by ds
order by ds

Error: SQLException:java.sql.SQLException: Query f