The REST query request failed

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

The REST query request failed

shendandan
Hello!
     I use tableau as kylin's visualization tool. And I want to know can I create calculated field in tableau to select?
    " if [还款逾期天数] >90 then [本息余额_1] ELSE 0 END " this is my calculated field but there is a error when I used the calculated field.
    the error is :
   [Kylin][ODBC 1.0(w) Driver]The REST query request failed, the error message is: Error while executing SQL "SELECT SUM((CASE WHEN ("BASEINFO_REPAY_HIS_FACT_PARTATION"."CUR_LATEDAYS" > 90) THEN "BASEINFO_REPAY_HIS_FACT_PARTATION"."REMAIN_CAPITAL_INTEREST" ELSE 0 END)) AS "sum_Calculation_FCFAIAHBFAGFBCEH_ok" FROM "TN_QUERY"."BASEINFO_REPAY_HIS_FACT_PARTATION" "BASEINFO_REPAY_HIS_FACT_PARTATION" LEFT JOIN "TN_QUERY"."DIM_BP_PRODUCT" "DIM_BP_PRODUCT" ON ("BASEINFO_REPAY_HIS_FACT_PARTATION"."PRODUCT_CODE" = "DIM_BP_PRODUCT"."PRODUCT_CODE") LEFT JOIN "TN_QUERY"."DIM_BP_SALES_CHANNEL" "DIM_BP_SALES_CHANNEL" ON ("BASEINFO_REPAY_HIS_FACT_PARTATION"."BUSINESS_TYPE" = "DIM_BP_SALES_CHANNEL"."CHANNEL_CODE") LEFT JOIN "TN_QUERY"."DIM_FUND_CHANNEL" "DIM_FUND_CHANNEL" ON ("BASEINFO_REPAY_HIS_FACT_PARTATION"."ROOT_CODE" = "DIM_FUND_CHANNEL"."FUND_CHANNEL_CODE") LEFT JOIN "TN_QUERY"."DIM_ORG" "DIM_ORG" ON ("BASEINFO_REPAY_HIS_FACT_PARTATION"."BRANCH_CODE" = "DIM_ORG"."BRANCH_CODE") ": Can't find any realization. Please confirm with providers. SQL digest: fact table TN_QUERY.BASEINFO_REPAY_HIS_FACT_PARTATION,group by [],filter on [],with aggregates[FunctionDesc [expression=SUM, parameter=null, returnType=null]].
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: The REST query request failed

Yang
This is known issue https://issues.apache.org/jira/browse/KYLIN-2787

Thanks for reporting.

Yang

On Tue, Aug 8, 2017 at 3:53 PM, shendandan <[hidden email]>
wrote:

> Hello!
>      I use tableau as kylin's visualization tool. And I want to know can I
> create calculated field in tableau to select?
>     " if [还款逾期天数] >90 then [本息余额_1] ELSE 0 END " this is my calculated
> field but there is a error when I used the calculated field.
>     the error is :
>    [Kylin][ODBC 1.0(w) Driver]The REST query request failed, the error
> message is: Error while executing SQL "SELECT SUM((CASE WHEN
> ("BASEINFO_REPAY_HIS_FACT_PARTATION"."CUR_LATEDAYS" > 90) THEN
> "BASEINFO_REPAY_HIS_FACT_PARTATION"."REMAIN_CAPITAL_INTEREST" ELSE 0
> END)) AS "sum_Calculation_FCFAIAHBFAGFBCEH_ok" FROM
> "TN_QUERY"."BASEINFO_REPAY_HIS_FACT_PARTATION" "BASEINFO_REPAY_HIS_FACT_PARTATION"
> LEFT JOIN "TN_QUERY"."DIM_BP_PRODUCT" "DIM_BP_PRODUCT" ON
> ("BASEINFO_REPAY_HIS_FACT_PARTATION"."PRODUCT_CODE" =
> "DIM_BP_PRODUCT"."PRODUCT_CODE") LEFT JOIN "TN_QUERY"."DIM_BP_SALES_CHANNEL"
> "DIM_BP_SALES_CHANNEL" ON ("BASEINFO_REPAY_HIS_FACT_PARTATION"."BUSINESS_TYPE"
> = "DIM_BP_SALES_CHANNEL"."CHANNEL_CODE") LEFT JOIN
> "TN_QUERY"."DIM_FUND_CHANNEL" "DIM_FUND_CHANNEL" ON
> ("BASEINFO_REPAY_HIS_FACT_PARTATION"."ROOT_CODE" =
> "DIM_FUND_CHANNEL"."FUND_CHANNEL_CODE") LEFT JOIN "TN_QUERY"."DIM_ORG"
> "DIM_ORG" ON ("BASEINFO_REPAY_HIS_FACT_PARTATION"."BRANCH_CODE" =
> "DIM_ORG"."BRANCH_CODE") ": Can't find any realization. Please confirm with
> providers. SQL digest: fact table TN_QUERY.BASEINFO_REPAY_HIS_FACT_PARTATION,group
> by [],filter on [],with aggregates[FunctionDesc [expression=SUM,
> parameter=null, returnType=null]].
Loading...