java.sql.SQLException: Error while executing SQL "select sum(pv_1d_001) pv from lbs_ad_pv_1d group by INDS order by sum(pv_1d_001) desc limit 100": null

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via incubator-kylin-user by lancelot chen, 1 year ago
Error while executing SQL "select sum(pv_1d_001) pv from lbs_ad_pv_1d group by INDS order by sum(pv_1d_001) desc limit 100": null
via kylin-user by lancelot chen, 1 year ago
Error while executing SQL "select sum(pv_1d_001) pv from lbs_ad_pv_1d group by INDS order by sum(pv_1d_001) desc limit 100": null
via incubator-kylin-user by lancelot chen, 1 year ago
Error while executing SQL "select sum(pv_1d_001) pv from lbs_ad_pv_1d group by INDS order by pv desc LIMIT 50000": Can't find any realization. Please confirm with providers. SQL digest: fact table LBS.LBS_AD_PV_1D,group by [LBS.LBS_AD_PV_1D.INDS
via kylin-user by lancelot chen, 1 year ago
Error while executing SQL "select sum(pv_1d_001) pv from lbs_ad_pv_1d group by INDS order by pv desc LIMIT 50000": Can't find any realization. Please confirm with providers. SQL digest: fact table LBS.LBS_AD_PV_1D,group by [LBS.LBS_AD_PV_1D.INDS
via Stack Overflow by Piotr Bojko
, 1 month ago
Error while executing SQL "select * from jira.PROJECT_KEY": null
via Stack Overflow by danpayne17
, 1 year ago
Error while executing SQL "select * from db1.table1": From line 1, column 15 to line 1, column 24: Table 'DB1.TABLE1' not found
java.sql.SQLException: Error while executing SQL "select sum(pv_1d_001) pv from lbs_ad_pv_1d group by INDS order by sum(pv_1d_001) desc limit 100": null
at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:143)
at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:186)
at org.apache.kylin.rest.service.QueryService.execute(QueryService.java:355)
at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:271)
at org.apache.kylin.rest.service.QueryService.query(QueryService.java:119)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.