THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
Apache Kylin

Space shortcuts

Apache Kylin : Analytical Data Warehouse for Big Data

Page tree

Versions Compared

Old Version 3

changes.mady.by.user Wang Rupeng

Saved on

compared with

New Version 4

changes.mady.by.user Wang Rupeng

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For example, there's a column which have high cardinality called seller_id and our application scenario will filter according to this column. There're some sample SQLs:

Code Block
select count(*) from kylin_sales left join kylin_order where seller_id = '10000233'
select count(*) from kylin_sales left join kylin_order where SELLER_ID in (10000233,10000234,10000235)
select count(*) from kylin_sales left join kylin_order where SELLER_ID is NULL
select count(*) from kylin_sales left join kylin_order where SELLER_ID in (10000233,10000234,10000235) and SELLER_ID = 10000233 
select count(*) from kylin_sales left join kylin_order where SELLER_ID = 10000233 or SELLER_ID = 1

...