回复: 回复: error while using left join

[liangmeng <13...@139.com>]

wow,i think i know what the problem is, i should dragged the lowest dimensions first, not the highest

 
发件人： liangmeng
发送时间： 2015-07-13 14:22
收件人： dev
主题： 回复: Re: error while using left join
still not working, i change tableau to be left join ,and it returns:

[Kylin][ODBC 1.0(w) Driver]The REST query request failed, the error message is: exception while executing query: null



梁猛 
中国移动广东公司 网管维护中心 网管支撑室 
电话：13802880779
邮箱: liangmeng@gd.chinamobile.com  ，13802880779@139.com
地址：广东省广州市珠江新城珠江西路11号 广东全球通大厦北3楼 
邮编：510623 
 
发件人： Shi, Shaofeng
发送时间： 2015-07-13 13:34
收件人： dev@kylin.incubator.apache.org
主题： Re: error while using left join
The SQL that generated by Tableau is still "inner joined” ones, which
doesn’t match with the cubes, then Kylin reports “Can't find any
realization” error; You may need update your tableau report;
 
On 7/13/15, 1:22 PM, "liangmeng" <13...@139.com> wrote:
 
> tableau is used to view cube query result, at first ,i defined inner
>join at data modeling, and every thing is ok,  tableau showed the
>results; but when i changed to inner join to left join, the cube builded
>without errors, but tableau can not show the query result , and the
>exception as follow:
>
>[Kylin][ODBC 1.0(w) Driver]The REST query request failed, the error
>message is: error while executing SQL "SELECT
>"D_NW_NE_ECELLC"."ECELL_PROVINCE_NAME_ZH" AS
>"none_ECELL_PROVINCE_NAME_ZH_nk",   SUM("LTE_HTTP_S"."DLDATA") AS
>"sum_DLDATA_ok" FROM "DEFAULT"."LTE_HTTP_S" "LTE_HTTP_S"   INNER JOIN
>"DEFAULT"."D_MINUTE_5" "D_MINUTE_F" ON ("LTE_HTTP_S"."SLICETIME" =
>"D_MINUTE_F"."MINUTE_5_ID")   INNER JOIN "DEFAULT"."D_NW_NE_ECELL2"
>"D_NW_NE_ECELLC" ON ("LTE_HTTP_S"."ECELLOID" =
>"D_NW_NE_ECELLC"."ECELL_OID")   INNER JOIN
>"DEFAULT"."D_NW_NE_ENODE_IPADDR2" "D_NW_NE_ENODE_IPADDRC" ON
>("LTE_HTTP_S"."ENODEBIPOID" =
>"D_NW_NE_ENODE_IPADDRC"."ENODEB_IPADDR_OID")   INNER JOIN
>"DEFAULT"."D_NW_NE_SGW_IPADDR2" "D_NW_NE_SGW_IPADDRC" ON
>("LTE_HTTP_S"."SGWIPADDROID" = "D_NW_NE_SGW_IPADDRC"."SGW_IPADDR_OID")
>INNER JOIN "DEFAULT"."D_SERVICE_RY_CATEGORY" "D_SERVICE_RY_CATEGORY" ON
>("LTE_HTTP_S"."SERVICERYCATEGORYOID" =
>"D_SERVICE_RY_CATEGORY"."SERVICE_RY_CATEGORY_OID") GROUP BY
>"D_NW_NE_ECELLC"."ECELL_PROVINCE_NAME_ZH"": Can't find any realization.
>Please confirm with providers. SQL digest: fact table
>DEFAULT.LTE_HTTP_S,group by
>[DEFAULT.D_NW_NE_ECELL2.ECELL_PROVINCE_NAME_ZH],filter on [],with
>aggregates[FunctionDesc [expression=SUM, parameter=ParameterDesc
>[type=column, value=DLDATA], returnType=null], FunctionDesc
>[expression=COUNT, parameter=ParameterDesc [type=column, value=DLDATA],
>returnType=null]].
>
>
>
>梁猛 
>中国移动广东公司 网管维护中心 网管支撑室
>电话：13802880779
>邮箱: liangmeng@gd.chinamobile.com  ，13802880779@139.com
>地址：广东省广州市珠江新城珠江西路11号 广东全球通大厦北3楼
>邮编：510623