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

kylin-user | lancelot chen | 12 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Re: Usage of TOP_N measure

    kylin-user | 12 months ago | lancelot chen
    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
  2. 0

    Re: Usage of TOP_N measure

    incubator-kylin-user | 12 months ago | lancelot chen
    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
  3. 0

    Re: Usage of TOP_N measure

    kylin-user | 12 months ago | lancelot chen
    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]].
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: Usage of TOP_N measure

    incubator-kylin-user | 12 months ago | lancelot chen
    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]].

    Root Cause Analysis

    1. 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()
    2. org.apache.calcite
      AvaticaStatement.executeQuery
      1. org.apache.calcite.avatica.Helper.createException(Helper.java:56)
      2. org.apache.calcite.avatica.Helper.createException(Helper.java:41)
      3. org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:143)
      4. org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:186)
      4 frames
    3. org.apache.kylin
      QueryService.query
      1. org.apache.kylin.rest.service.QueryService.execute(QueryService.java:355)
      2. org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:271)
      3. org.apache.kylin.rest.service.QueryService.query(QueryService.java:119)
      3 frames