hi shaofeng,
yes, above cases are using same cube(session_view_shop_0_c1_clone).
2016-08-11 10:25:04,300 INFO [http-bio-7070-exec-165]
routing.QueryRouter:48 : The project manager's reference is
org.apache.kylin.
metadata.project.ProjectManager@2975ab7c
2016-08-11 10:25:04,301 INFO [http-bio-7070-exec-165]
routing.QueryRouter:60 : Find candidates by table
KYLIN_REPORT_DB.SESSION_VIE
W_SHOP_0 and project=KYLIN_REPORT_OPT :
org.apache.kylin.query.routing.Candidate@a324c7c
2016-08-11 10:25:04,301 INFO [http-bio-7070-exec-165]
routing.QueryRouter:49 : Applying rule: class
org.apache.kylin.query.routing.
rules.RemoveUncapableRealizationsRule, realizations before:
[session_view_shop_0_c1_clone(CUBE)], realizations after: [session_view_
shop_0_c1_clone(CUBE)]
2016-08-11 10:25:04,301 INFO [http-bio-7070-exec-165]
routing.QueryRouter:49 : Applying rule: class
org.apache.kylin.query.routing.
rules.RealizationSortRule, realizations before:
[session_view_shop_0_c1_clone(CUBE)], realizations after:
[session_view_shop_0_c1_cl
one(CUBE)]
2016-08-11 10:25:04,301 INFO [http-bio-7070-exec-165]
routing.QueryRouter:72 : The realizations remaining:
[session_view_shop_0_c1_
clone(CUBE)] And the final chosen one is the first one
2016-08-11 10:25:04,337 DEBUG [http-bio-7070-exec-165]
enumerator.OLAPEnumerator:107 : query storage...
2016-08-11 10:25:04,338 INFO [http-bio-7070-exec-165]
v2.CubeStorageQuery:234 : exactAggregation is false because some column not
o
n group by: [KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.DT_YEAR,
KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.DT_DAY, KYLIN_REPORT_DB.SESSION_VIEW_S
HOP_0.DISPLAY_NAME, KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.DT_MONTH,
KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.DATASOURCE] (single value colu
mn: [KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.DT_YEAR,
KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.DISPLAY_NAME,
KYLIN_REPORT_DB.SESSION_VIEW_SHO
P_0.DT_MONTH])
2016-08-11 10:25:04,338 INFO [http-bio-7070-exec-165]
v2.CubeStorageQuery:345 : Memory budget is set to: 16378
2016-08-11 10:25:04,348 INFO [http-bio-7070-exec-165]
dict.BuildInFunctionTransformer:66 : Translated
{LIKE(KYLIN_REPORT_DB.SESSION
_VIEW_SHOP_0.MERCHANT_NAME,%深海新创%)} to IN clause:
{KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.MERCHANT_NAME IN [深海新创专营店80002972]
}
2016-08-11 10:25:14,056 INFO [http-bio-7070-exec-165]
routing.QueryRouter:48 : The project manager's reference is
org.apache.kylin.
metadata.project.ProjectManager@2975ab7c
2016-08-11 10:25:14,057 INFO [http-bio-7070-exec-165]
routing.QueryRouter:60 : Find candidates by table
KYLIN_REPORT_DB.SESSION_VIE
W_SHOP_0 and project=KYLIN_REPORT_OPT :
org.apache.kylin.query.routing.Candidate@5c5e5638
2016-08-11 10:25:14,057 INFO [http-bio-7070-exec-165]
routing.QueryRouter:49 : Applying rule: class
org.apache.kylin.query.routing.
rules.RemoveUncapableRealizationsRule, realizations before:
[session_view_shop_0_c1_clone(CUBE)], realizations after: [session_view_
shop_0_c1_clone(CUBE)]
2016-08-11 10:25:14,057 INFO [http-bio-7070-exec-165]
routing.QueryRouter:49 : Applying rule: class
org.apache.kylin.query.routing.
rules.RealizationSortRule, realizations before:
[session_view_shop_0_c1_clone(CUBE)], realizations after:
[session_view_shop_0_c1_cl
one(CUBE)]
2016-08-11 10:25:14,058 INFO [http-bio-7070-exec-165]
routing.QueryRouter:72 : The realizations remaining:
[session_view_shop_0_c1_
clone(CUBE)] And the final chosen one is the first one
2016-08-11 10:25:14,098 DEBUG [http-bio-7070-exec-165]
enumerator.OLAPEnumerator:107 : query storage...
2016-08-11 10:25:14,098 INFO [http-bio-7070-exec-165]
v2.CubeStorageQuery:234 : exactAggregation is false because some column not
o
n group by: [KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.DT_YEAR,
KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.DT_DAY, KYLIN_REPORT_DB.SESSION_VIEW_S
HOP_0.DISPLAY_NAME, KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.DT_MONTH,
KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.DATASOURCE] (single value colu
mn: [KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.DT_YEAR,
KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.DISPLAY_NAME,
KYLIN_REPORT_DB.SESSION_VIEW_SHO
P_0.DT_MONTH])
2016-08-11 10:25:14,099 INFO [http-bio-7070-exec-165]
v2.CubeStorageQuery:345 : Memory budget is set to: 16378
2016-08-11 10:25:14,110 INFO [http-bio-7070-exec-165]
dict.BuildInFunctionTransformer:66 : Translated
{LIKE(KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.MERCHANT_NAME,%深海新创手机%)} to IN
clause: {KYLIN_REPORT_DB.SESSION_VIEW_SHOP_0.MERCHANT_NAME IN []}
--
View this message in context:
http://apache-kylin.74782.x6.nabble.com/Question-abount-BuildInFunctionTransformer-tp5499p5549.html
Sent from the Apache Kylin mailing list archive at Nabble.com.
