> " 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
Yes, I have logged a JIRA. Thank you.
-- --
??: "Billy Liu";;
: 2017??8??11??(??) 6:29
??: "dev";
: Re: The REST query request failed
It seems SUM(CASE WHEN...) does not supported yet. Could you log a
It seems SUM(CASE WHEN...) does not supported yet. Could you log a JIRA?
2017-08-11 16:33 GMT+08:00 578300...@qq.com :
> Thank you billy,I know how to solve the problem, but there is another
> error.
>
>
> error
>
>
> [Kylin][ODBC 1.0(w) Driver]The REST query request fai
Thank you billy,I know how to solve the problem, but there is another error.
error
[Kylin][ODBC 1.0(w) Driver]The REST query request failed, the error message is:
Error while executing SQL "SELECT SUM((CASE WHEN (( EXTRACT(YEAR FROM
"BASEINFO_REPAY_HIS_FACT_PARTATION"."CA
0_80
> hadoop-2.5.0-cdh5.3.9
> hbase-0.98.6-cdh5.3.9
> apache-kylin-1.6.0
> tableau 9
>
>
> -- 原始邮件 --
> 发件人: "Billy Liu";;
> 发送时间: 2017年8月10日(星期四) 下午5:05
> 收件人: "dev";
>
> 主题: Re: The REST query request failed
tableau 9
-- --
??: "Billy Liu";;
: 2017??8??10??(??) 5:05
??: "dev";
????: Re: The REST query request failed
The error is clear, some sql grammar did not work in your case, such as "{d
'2017-06-30
TATION"
> "BASEINFO_REPAY_HIS_FACT_PARTATION"
> GROUP BY (CASE WHEN (( EXTRACT(YEAR FROM
> "BASEINFO_REPAY_HIS_FACT_PARTATION"."CAL_DATE")
> = EXTRACT(YEAR FROM TIMESTAMPADD(SQL_TSI_YEAR,-1,{d '2017-06-30'))})
> AND ( EXTRACT(MONTH FR
"."CAL_DATE") =
EXTRACT(YEAR FROM TIMESTAMPADD(SQL_TSI_YEAR,-1,{d '2017-06-30'))}) AND (
EXTRACT(MONTH FROM "BASEINFO_REPAY_HIS_FACT_PARTATION"."CAL_DATE") = 12)) THEN
0 ELSE NULL END)
The sql generated Automatically.
Thank you!
--
uot;578300...@qq.com";;
> *发送时间:* 2017年8月9日(星期三) 晚上6:08
> *收件人:* "dev";
> *主题:* The REST query request failed
>
> Hello!
> when I use tableau to connect to kylin,some error arised.
>
> I created a calculated field in tableau
>
>
> and in kyli
The picture may not show up, I put them in the attachment.Thank you!
-- --
??: "578300...@qq.com";;
: 2017??8??9??(??) 6:08
??: "dev";
????: The REST query request failed
Hello!
when I use tableau to c
Hello!
when I use tableau to connect to kylin,some error arised.
I created a calculated field in tableau
and in kylin.log,the sql is:
How is this caused and how can I solve it. Thank you very much!
:
[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_IN
12 matches
Mail list logo