jiahua.hu created KYLIN-3660:
--------------------------------
Summary: subquery, join wiht two cube return No Result
Key: KYLIN-3660
URL: https://issues.apache.org/jira/browse/KYLIN-3660
Project: Kylin
Issue Type: Bug
Components: Query Engine
Affects Versions: v2.5.0
Reporter: jiahua.hu
I have two cubes corresponding to two tables t1 and t2. When I pass the user_Id
in t2 to limit the query range of the t1 table, I return an empty result. Then
there is data in my t2 table.
我有两个cube分别对应两张表t1和t2。当我通过t2中的user_Id去限制t1表的查询范围时，返回空结果。然后我的t2表里是有数据的。
select * from t1 inner join (select user_id from t2 where EXID='50') t2 on
t1.user_id = t2.user_id;
select * from t1 where user_id in (select user_id from t2 where EXID='50');
select * from t1 where user_id in (select '1002001');
The above three statements execution results are returned No Result.
But the following statement execution can return results
select * from t1 where user_id in ('1002001');
=======================================================
Query Id: 4a12730c-5222-b4a9-43fc-282e6bea7b51
SQL: select * from t1 inner join (select user_id from t2 where EXID='50') t2 on
t1.user_id = t2.user_id;
User: ADMIN
Success: true
Duration: 0.001
Project: test_project
Realization Names: [CUBE[name=t1_CUBE], CUBE[name=t2_CUBE]]
Cuboid Ids: [3, 63]
Total scan count: 50123
Total scan bytes: 5412669
Result row count: 0
Accept Partial: true
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: true
Is Query Push-Down: false
Is Prepare: false
Trace URL: null
Message: null
============================================================
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
