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)

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

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

Solutions on the web26

  • via kylin-user by ShaoFeng Shi, 9 months 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
  • via incubator-kylin-user by ShaoFeng Shi, 9 months 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
  • via kylin-user by ShaoFeng Shi, 9 months 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
  • Stack trace

    • 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(Native Method)

    Write tip

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

    Users with the same issue

    You’re the first here who have seen this exception.