Re: kylin和tableau集成问题

[ShaoFeng Shi <sh...@apache.org>]

hi, what's test1 and what's test2? The mailing list doesn't accept
attachements, so please avoid using that.

From the log you provided in the first email, Kylin's query is succesfully
returned:

Success: true
Duration: 0.123

Could you check the result set and whether there is any more info in
Tableau side?

2017-06-08 14:49 GMT+08:00 wqz728787109@163.com <wq...@163.com>:

> 问题描述：tableau走kylin的ODBC链接时，对于维度做字符串拼接，如test1图片是以tableau实时方式链接kylin，
> 拼接字符串时报错，Test2是tableau正常方式链接其他数据库做同样的操作 没有任何问题；
> kylin版本：2.0
> tableau版本：10.2
> 调整：我们在用度量做字符串拼接时没有报错，包括其它拼接字符串函数在kylin里面都存在类似问题
>
> ==========================[QUERY]===============================
> Query Id: 7f1e1256-d505-40dc-84a2-49f9b258297c
> SQL: SELECT {fn REPLACE(TRIM(BOTH ' ' FROM "W_ORDER_
> RECEIVE_F"."PROD_CODE"),' ','+/')} AS "Calculation_
> 373517306627883016",   ' ' AS "Calculation_373517306627883017",   "W_
> ORDER_RECEIVE_F"."PROD_CODE" AS "PROD_CODE_____",   (CASE
> WHEN (MIN("W_ORDER_RECEIVE_F"."PROD_CODE") IS NULL) THEN 0
> WHEN NOT (MIN("W_ORDER_RECEIVE_F"."PROD_CODE") IS
> NULL) THEN 1 ELSE NULL END) AS "ctd_PROD_CODE_ok" FROM "
> BIGDATA_DW"."W_ORDER_RECEIVE_F" "W_ORDER_RECEIVE_F" GROUP
> BY {fn REPLACE(TRIM(BOTH ' ' FROM "W_ORDER_RECEIVE_F"."
> PROD_CODE"),' ','+/')},   "W_ORDER_RECEIVE_F"."PROD_CODE"
> User: ADMIN
> Success: true
> Duration: 0.123
> Project: YILI_ERP_ORDER
> Realization Names: [CUBE[name=YILI_ORDER_F]]
> Cuboid Ids: [4]
> Total scan count: 2304
> Total scan bytes: 213409
> Result row count: 1038
> Accept Partial: false
> Is Partial Result: false
> Hit Exception Cache: false
> Storage cache used: false
> Message: null
> ------------------------------
> wqz728787109@163.com
>



-- 
Best regards,

Shaofeng Shi 史少锋