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)

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 are the first who have seen this exception. Write a tip to help other users and build your expert profile.