org.apache.kylin.rest.exception.InternalErrorException: 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.kylin.rest.controller.QueryController.doQueryWithCache(QueryController.java:224) at > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:94)

kylin-user | ShaoFeng Shi | 7 months ago
  1. 0

    Re: Usage of TOP_N measure

    kylin-user | 7 months ago | ShaoFeng Shi
    org.apache.kylin.rest.exception.InternalErrorException: 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.kylin.rest.controller.QueryController.doQueryWithCache(QueryController.java:224) at > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:94)
  2. 0

    Re: Usage of TOP_N measure

    incubator-kylin-user | 7 months ago | ShaoFeng Shi
    org.apache.kylin.rest.exception.InternalErrorException: 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.kylin.rest.controller.QueryController.doQueryWithCache(QueryController.java:224) at > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:94)
  3. 0

    Re: Usage of TOP_N measure

    kylin-user | 7 months ago | ShaoFeng Shi
    org.apache.kylin.rest.exception.InternalErrorException: 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.kylin.rest.controller.QueryController.doQueryWithCache(QueryController.java:224) at >>> org.apache.kylin.rest.controller.QueryController.query(QueryController.java:94)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: Usage of TOP_N measure

    kylin-user | 7 months ago | ShaoFeng Shi
    org.apache.kylin.rest.exception.InternalErrorException: 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.kylin.rest.controller.QueryController.doQueryWithCache(QueryController.java:224) at >>>> org.apache.kylin.rest.controller.QueryController.query(QueryController.java:94)
  6. 0

    Re: Usage of TOP_N measure

    incubator-kylin-user | 7 months ago | ShaoFeng Shi
    org.apache.kylin.rest.exception.InternalErrorException: 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.kylin.rest.controller.QueryController.doQueryWithCache(QueryController.java:224) at >>> org.apache.kylin.rest.controller.QueryController.query(QueryController.java:94)

    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. org.apache.kylin.rest.exception.InternalErrorException

      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.kylin.rest.controller.QueryController.doQueryWithCache(QueryController.java:224) at > org.apache.kylin.rest.controller.QueryController.query(QueryController.java:94)

      at sun.reflect.NativeMethodAccessorImpl.invoke0()
    2. Java RT
      NativeMethodAccessorImpl.invoke0
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      1 frame