Hi,
Here is the kylin ui cube information:
And I check the parquet content:
Tables content,they join on tb_sales3.emp_id and tb_emp.id
Cube dimensions and measures:
------------------ ???????? ------------------
??????:
"dev"
<[email protected]>;
????????: 2021??2??15??(??????) ????2:37
??????: "dev"<[email protected]>;"wujunxi"<[email protected]>;
????: Re:Query fact table and return nothing
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/
