You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by KrisWu <46...@qq.com> on 2021/02/12 05:26:58 UTC
Query fact table and return nothing
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/
Re:Query fact table and return nothing
Posted by Xiaoxiang Yu <xx...@apache.org>.
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" <46...@qq.com> 写道：
>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/