Hi,
From the provided information, it is not easy to find the right cause.
Could you please check the segments of your cube (test1_2) are not empty ?
Or you can check the Spark UI of SparderContext, to see the corresponding Spark
Job and check if they have scan any rows of data ?
--
Best wishes to you !
From ：Xiaoxiang Yu
在 2021-02-12 13:26:58，"KrisWu" <[email protected]> 写道：
>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/
