alculated 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
> messag
Yes, I have logged a JIRA. Thank you.
-- --
??: "Billy Liu";<billy...@apache.org>;
: 2017??8??11??(??) 6:29
??: "dev"<dev@kylin.apache.org>;
????: Re: The REST query request failed
It seems SUM(
;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]].
>
>
>
>
&
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".&qu
ent is:
> jdk1.7.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";<billy...@apache.org>;
> 发送时间: 2017年8月10日(星期四) 下午5:05
> 收件人: "dev"<
-- --
??: "Billy Liu";<billy...@apache.org>;
: 2017??8??10??(??) 5:05
??: "dev"<dev@kylin.apache.org>;
????: Re: The REST query request failed
The error is clear, some sql grammar did not work in yo
uot;
> "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 FROM "BASEINFO_RE
(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!
-- --
??: "
---
> *发件人:* "578300...@qq.com";<believe...@foxmail.com>;
> *发送时间:* 2017年8月9日(星期三) 晚上6:08
> *收件人:* "dev"<dev@kylin.apache.org>;
> *主题:* The REST query request failed
>
> Hello!
> when I use tableau to connect to ky
The picture may not show up, I put them in the attachment.Thank you!
-- --
??: "578300...@qq.com";<believe...@foxmail.com>;
: 2017??8??9??(??) 6:08
??: "dev"<dev@kylin.apache.org>;
????: The RE
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_INTERES
12 matches
Mail list logo
