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.


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; 
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

Reply via email to