Hi,I am using kylin4.0. I have built a cube ,when i query fact table,it
return nothing,but look up tables have results.what's the problem?

query log:
Fact table:
==========================[QUERY]===============================
Query Id: 57bf1c59-5c5d-1013-20f5-374eb701f9e8
SQL: select count(*) from tb_sales
User: ADMIN
Success: true
Duration: 1.297
Project: wjx
Realization Names: [CUBE[name=test1_2]]
Cuboid Ids: [1]
Total scan count: 0
Total scan files: 0
Total metadata time: 2ms
Total spark scan time: -1ms
Total scan bytes: -1
Result row count: 1
Storage cache used: false
Is Query Push-Down: false
Is Prepare: false
Used Spark pool: lightweight_tasks
Trace URL: null
Message: null


Look up table:
==========================[QUERY]===============================
Query Id: 8be51b8d-c76e-58ba-2e0e-fa67162d5888
SQL: select count(*) from tb_emp
User: ADMIN
Success: true
Duration: 0.002
Project: wjx
Realization Names: [CUBE[name=test1_2]]
Cuboid Ids: []
Total scan count: 2
Total scan files: 1
Total metadata time: 7ms
Total spark scan time: 1104ms
Total scan bytes: -1
Result row count: 1
Storage cache used: true
Is Query Push-Down: false
Is Prepare: false
Used Spark pool: lightweight_tasks
Trace URL: null
Message: null


--
Sent from: http://apache-kylin.74782.x6.nabble.com/

Reply via email to