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]].

incubator-kylin-user | lancelot chen | 7 months ago
  1. 0

    Re: Usage of TOP_N measure

    kylin-user | 7 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]].
  2. 0

    Re: Usage of TOP_N measure

    incubator-kylin-user | 7 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]].
  3. 0

    Re: Usage of TOP_N measure

    kylin-user | 7 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: Usage of TOP_N measure

    incubator-kylin-user | 7 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
  6. 0

    Re: Usage of TOP_N measure

    kylin-user | 7 months ago | ShaoFeng Shi
    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]].

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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 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()
    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