You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by liangmeng <13...@139.com> on 2015/07/13 07:22:41 UTC
error while using left join
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
回复: 回复: error while using left join
Posted by 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
回复: Re: error while using left join
Posted by liangmeng <13...@139.com>.
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
Re: error while using left join
Posted by "Shi, Shaofeng" <sh...@ebay.com>.
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
Re: error while using left join
Posted by xatax <ro...@gmail.com>.
We are facing the same issue in tableau when we give a filter on the left
join. It is converting to inner join.
Can you please let us know if there is any solution for this?
Thanks!
--
Sent from: http://apache-kylin.74782.x6.nabble.com/
Re: error while using left join
Posted by Harry Li <hl...@126.com>.
I also have this problem ,have you solve it?
--
Sent from: http://apache-kylin.74782.x6.nabble.com/