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

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Re: Usage of TOP_N measure
    via by ShaoFeng Shi,
  • Re: Usage of TOP_N measure
    via by ShaoFeng Shi,
  • Re: Usage of TOP_N measure
    via by ShaoFeng Shi,
  • Re: Usage of TOP_N measure
    via by ShaoFeng Shi,
  • Re: Usage of TOP_N measure
    via by ShaoFeng Shi,
  • Re: Usage of TOP_N measure
    via by ShaoFeng Shi,
  • Integrating Kafka with Apache Calcite
    via Stack Overflow by user2283216
    ,
  • Re: Usage of TOP_N measure
    via by lancelot chen,
  • Re: Usage of TOP_N measure
    via by lancelot chen,
  • Re: Usage of TOP_N measure
    via by 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]]. at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
    No Bugmate found.