2019-01-04 10:16:32,063 INFO  [Query 7a3d0cd5-8317-4d65-b7be-e75f84a6f63f-306] service.QueryService:950 : Processed rows for each storageContext: 3091
2019-01-04 10:16:32,064 INFO  [Query 7a3d0cd5-8317-4d65-b7be-e75f84a6f63f-306] service.QueryService:424 : Stats of SQL response: isException: false, duration: 2382, total scan count 1395177
2019-01-04 10:16:32,078 INFO  [Query 7a3d0cd5-8317-4d65-b7be-e75f84a6f63f-306] service.QueryService:318 :
==========================[QUERY]===============================
Query Id: 7a3d0cd5-8317-4d65-b7be-e75f84a6f63f
SQL: SELECT (CASE WHEN ("DISTRICT"."MCKINSEY_CITYLEVEL_NAME" IS NULL) THEN '其他' ELSE "DISTRICT"."MCKINSEY_CITYLEVEL_NAME" END) AS "Calculation_607985976507576320",   COUNT(DISTINCT "JOBMD_RESUME_OVERVIEW"."USERID") AS "usr_Calculation_90072014311858176_ok",   COUNT(DISTINCT "JOBMD_RESUME_OVERVIEW"."ID") AS "usr_Calculation_90072014314373121_ok" FROM "ADL"."JOBMD_RESUME_OVERVIEW" "JOBMD_RESUME_OVERVIEW"   LEFT JOIN "DIM"."DISTRICT" "DISTRICT" ON ("JOBMD_RESUME_OVERVIEW"."CONTACT_LOCATIONS" = "DISTRICT"."ID") WHERE (((("JOBMD_RESUME_OVERVIEW"."CREATE_DT" >= {d '2005-01-01'}) AND ("JOBMD_RESUME_OVERVIEW"."CREATE_DT" <= {d '2018-07-17'})) OR ("JOBMD_RESUME_OVERVIEW"."CREATE_DT" IS NULL)) AND ((("JOBMD_RESUME_OVERVIEW"."MODIFY_DT" >= {d '2005-01-01'}) AND ("JOBMD_RESUME_OVERVIEW"."MODIFY_DT" <= {d '2018-07-17'})) OR ("JOBMD_RESUME_OVERVIEW"."MODIFY_DT" IS NULL))) GROUP BY (CASE WHEN ("DISTRICT"."MCKINSEY_CITYLEVEL_NAME" IS NULL) THEN '其他' ELSE "DISTRICT"."MCKINSEY_CITYLEVEL_NAME" END)
User: ADMIN
Success: true
Duration: 2.383
Project: jobmd
Realization Names: [CUBE[name=1101_resume_overview_df]]
Cuboid Ids: [1600]
Total scan count: 1395177
Total scan bytes: 174375273
Result row count: 5
Accept Partial: false
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Is Query Push-Down: false
Is Prepare: false
Trace URL: null
Message: null
==========================[QUERY]===============================

2019-01-04 10:16:32,501 DEBUG [http-bio-7070-exec-7] security.KylinAuthenticationProvider:57 : User cache [45, -40, 120, -36, -13, 32, -125, 5, -74, -81, -88, -58, 82, -46, -13, -98] is removed due to EXPLICIT
2019-01-04 10:16:32,506 DEBUG [http-bio-7070-exec-5] cachesync.Broadcaster:247 : Broadcasting UPDATE, user, admin
2019-01-04 10:16:32,507 DEBUG [http-bio-7070-exec-5] cachesync.Broadcaster:281 : Done broadcasting UPDATE, user, admin
2019-01-04 10:16:32,627 DEBUG [http-bio-7070-exec-7] security.KylinAuthenticationProvider:113 : User admin authorities : [ROLE_ADMIN, ROLE_ANALYST, ROLE_MODELER]
2019-01-04 10:16:32,628 DEBUG [http-bio-7070-exec-7] cachesync.CachedCrudAssist:190 : Saving ManagedUser at /user/admin
2019-01-04 10:16:32,630 DEBUG [pool-6-thread-1] cachesync.Broadcaster:113 : Servers in the cluster: [t1:7070, t2:7070, t3:7070, t4:7070]
2019-01-04 10:16:32,631 DEBUG [pool-6-thread-1] cachesync.Broadcaster:123 : Announcing new broadcast to all: BroadcastEvent{entity=user, event=update, cacheKey=admin}
2019-01-04 10:16:32,631 DEBUG [http-bio-7070-exec-7] security.KylinAuthenticationProvider:126 : Authenticated user org.springframework.security.authentication.UsernamePasswordAuthenticationToken@c8fb265c: Principal: org.springframework.security.core.userdetails.User@3b40b2f: Username: ADMIN; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_ADMIN,ROLE_ANALYST,ROLE_MODELER; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@1de6: RemoteIpAddress: 192.168.202.210; SessionId: null; Granted Authorities: ROLE_ADMIN, ROLE_ANALYST, ROLE_MODELER
2019-01-04 10:16:32,648 INFO  [http-bio-7070-exec-7] service.QueryService:324 : Check query permission in 0 ms.
2019-01-04 10:16:32,648 INFO  [Query b3000106-f881-4aa2-b51e-7c8edd45edb6-305] service.QueryService:355 : Using project: jobmd
2019-01-04 10:16:32,648 INFO  [Query b3000106-f881-4aa2-b51e-7c8edd45edb6-305] service.QueryService:356 : The original query:  SELECT 1
2019-01-04 10:16:32,655 DEBUG [http-bio-7070-exec-13] cachesync.Broadcaster:247 : Broadcasting UPDATE, user, admin
2019-01-04 10:16:32,655 INFO  [Query b3000106-f881-4aa2-b51e-7c8edd45edb6-305] util.TableauInterceptor:97 : Hit fake response 0
2019-01-04 10:16:32,655 DEBUG [Query b3000106-f881-4aa2-b51e-7c8edd45edb6-305] service.QueryService:522 : Return fake response, is exception? false
2019-01-04 10:16:32,656 INFO  [Query b3000106-f881-4aa2-b51e-7c8edd45edb6-305] service.QueryService:424 : Stats of SQL response: isException: false, duration: 8, total scan count 0
2019-01-04 10:16:32,656 DEBUG [Query b3000106-f881-4aa2-b51e-7c8edd45edb6-305] util.CheckUtil:35 : query is too lightweight with duration: 8 (threshold 2000), scan count: 0 (threshold 10240), scan bytes: 0 (threshold 1048576)
2019-01-04 10:16:32,656 DEBUG [http-bio-7070-exec-13] cachesync.Broadcaster:281 : Done broadcasting UPDATE, user, admin