java.sql.SQLException

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],filter on [],with aggregates[FunctionDesc [expression=SUM, parameter=ParameterDesc [type=column, value=PV_1D_001, nextParam=null], returnType=null]].

Samebug tips0

There are no available Samebug tips.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web11

  • via by lancelot chen,
  • via by lancelot chen,
  • via by lancelot chen,
  • Stack trace

    • java.sql.SQLException: 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],filter on [],with aggregates[FunctionDesc [expression=SUM, parameter=ParameterDesc [type=column, value=PV_1D_001, nextParam=null], returnType=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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    No Bugmate found.