I0518 18:40:39.061064 54538 Frontend.java:1245] fb4ef8f4ae80c558:6ab6611600000000] Analyzing query: SELECT province AS province,
       sum(if(today_order_count is null
              or today_order_count=0, 0, 1)) AS `产生订单城市数`,
       sum(if(today_order_count is null, 0, today_order_count)) AS sum_today_order_count,
       sum(if(last_day_order_count is null, 0, last_day_order_count)) AS sum_last_day_order_count,
       sum(if(last_week_order_count is null, 0, last_week_order_count)) AS sum_last_week_order_count,
       if(sum(last_day_order_count)=0, 0, (sum(today_order_count)- sum(last_day_order_count))/sum(last_day_order_count)) AS `环比订单增长`,
       if(sum(last_week_order_count)=0, 0, (sum(today_order_count) - sum(last_week_order_count))/sum(last_week_order_count)) AS `同比订单增长`,
       if(sum(today_pcpn>0) is null, 0, sum(today_pcpn>0)) AS `今日降水城市数量`,
       if(sum(today_pcpn>0) is null, 0, sum(today_pcpn>0))/count(1) AS `今日降水城市比例`,
       round(sum(today_pcpn), 2) AS sum_today_pcpn,
       if(sum(last_day_pcpn>0) is null, 0, sum(last_day_pcpn>0)) AS `昨日降水城市数量`,
       if(sum(last_day_pcpn>0) is null, 0, sum(last_day_pcpn>0))/count(1) AS `昨日降水城市比例`,
       round(sum(last_day_pcpn), 2) AS sum_last_day_pcpn,
       if(sum(last_week_pcpn>0) is null, 0, sum(last_week_pcpn>0)) AS `上周降水城市数量`,
       if(sum(last_week_pcpn>0) is null, 0, sum(last_week_pcpn>0))/count(1) AS `上周同期降水城市比例`,
       round(sum(last_week_pcpn), 2) AS sum_last_week_pcpn
FROM temp.view_city_order_realtime_analysis
GROUP BY province
ORDER BY sum_today_order_count DESC
LIMIT 50000 db: default
I0518 18:40:39.061988 54538 FeSupport.java:285] fb4ef8f4ae80c558:6ab6611600000000] Requesting prioritized load of table(s): temp.view_city_order_realtime_analysis
I0518 18:40:42.137147  8936 ImpaladCatalog.java:200] Adding: TABLE:temp.view_city_order_realtime_analysis version: 7322277 size: 10876
I0518 18:40:42.137230  8936 ImpaladCatalog.java:200] Adding: CATALOG_SERVICE_ID version: 7322277 size: 49
I0518 18:40:42.139402  8936 impala-server.cc:1610] Catalog topic update applied with version: 7322277 new min catalog object version: 7321301
I0518 18:40:42.139806 54536 FeSupport.java:285] 0f4ede5f3709c4aa:23f5be8e00000000] Requesting prioritized load of table(s): ods.ods_ebike_city_kudu, ods.ods_ebike_geo_geo_weather_log_kudu, dwd.dwd_area_weather_day_full
I0518 18:40:42.140015 54538 FeSupport.java:285] fb4ef8f4ae80c558:6ab6611600000000] Requesting prioritized load of table(s): ods.ods_ebike_city_kudu, ods.ods_ebike_geo_geo_weather_log_kudu, dwd.dwd_area_weather_day_full
I0518 18:40:46.141919  8936 ImpaladCatalog.java:200] Adding: TABLE:dwd.dwd_area_weather_day_full version: 7322280 size: 88071
I0518 18:40:46.142277  8936 ImpaladCatalog.java:200] Adding: TABLE:ods.ods_ebike_geo_geo_weather_log_kudu version: 7322279 size: 4381
I0518 18:40:46.142450  8936 ImpaladCatalog.java:200] Adding: TABLE:ods.ods_ebike_city_kudu version: 7322278 size: 7006
I0518 18:40:46.142510  8936 ImpaladCatalog.java:200] Adding: CATALOG_SERVICE_ID version: 7322280 size: 49
I0518 18:40:46.143898  8936 impala-server.cc:1610] Catalog topic update applied with version: 7322280 new min catalog object version: 7321301
I0518 18:40:46.147437 54536 jni-util.cc:256] 0f4ede5f3709c4aa:23f5be8e00000000] org.apache.impala.common.AnalysisException: count() unknown
        at org.apache.impala.analysis.FunctionCallExpr.analyzeImpl(FunctionCallExpr.java:493)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:431)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyzeSelectClause(SelectStmt.java:269)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:209)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:451)
        at org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:421)
        at org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:1285)
        at org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:1252)
        at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1222)
        at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:167)
I0518 18:40:46.148516 54536 status.cc:124] 0f4ede5f3709c4aa:23f5be8e00000000] AnalysisException: count() unknown
    @           0xb4c589
    @          0x115024e
    @          0x102af73
    @          0x1052fc2
    @          0x105ecac
    @          0x10af853
    @          0x13b0817
    @          0x13ac99c
    @           0xb18299
/now()
  54: parquet_array_resolution (i32) = 0,
  55: parquet_read_statistics (bool) = true,
  56: default_join_distribution_mode (i32) = 0,
  57: disable_codegen_rows_threshold (i32) = 50000,
  58: default_spillable_buffer_size (i64) = 2097152,
  59: min_spillable_buffer_size (i64) = 65536,
  60: max_row_size (i64) = 524288,
  61: idle_session_timeout (i32) = 0,
  62: compute_stats_min_sample_size (i64) = 1073741824,
  63: exec_time_limit_s (i32) = 0,
  64: shuffle_distinct_exprs (bool) = true,
  65: max_mem_estimate_for_admission (i64) = 0,
  66: thread_reservation_limit (i32) = 3000,
  67: thread_reservation_aggregate_limit (i32) = 0,
  68: kudu_read_mode (i32) = 0,
  69: allow_erasure_coded_files (bool) = false,
  70: timezone (string) = "",
  71: scan_bytes_limit (i64) = 0,
  72: cpu_limit_s (i64) = 0,
  73: topn_bytes_limit (i64) = 536870912,
  75: resource_trace_ratio (double) = 0,
  76: num_remote_executor_candidates (i32) = 3,
  77: num_rows_produced_limit (i64) = 0,
  78: planner_testcase_mode (bool) = false,
}
I0519 02:52:48.349799 29054 impala-server.cc:1018] Found local timezone "Asia/Shanghai".
I0519 02:52:48.351699 29054 impala-server.cc:1078] 6b4e7ce3e5910d28:d53c427500000000] Registered query query_id=6b4e7ce3e5910d28:d53c427500000000 session_id=ad4cbee188301cb7:842d701051656dac
I0519 02:52:48.351863 29054 Frontend.java:1245] 6b4e7ce3e5910d28:d53c427500000000] Analyzing query: SELECT bike_model AS bike_model,
       COUNT(1) AS value
FROM ods.ods_ebike_galaxy_bike_usage_day_full
WHERE create_time >= '2020-05-12 00:00:00'
  AND create_time <= '2020-05-19 02:52:47'
  AND ((event_day = from_unixtime(unix_timestamp(days_sub(now(), 1)), 'yyyyMMdd')))
  AND ((event_day = from_unixtime(unix_timestamp(days_sub(now(), 1)), 'yyyyMMdd')))
  AND ((city_id in (355,
                    398,
                    404,
                    436,
                    473)))
GROUP BY bike_model
HAVING ((COUNT(1) > 20))
LIMIT 10000 db: default
I0519 02:52:48.352419 29054 FeSupport.java:285] 6b4e7ce3e5910d28:d53c427500000000] Requesting prioritized load of table(s): ods.ods_ebike_galaxy_bike_usage_day_full
I0519 02:52:48.367946 29055 impala-hs2-server.cc:284] Opening session: de4f93bde4f4a20f:a9936c73f0436b93 username: root
I0519 02:52:48.368064 29055 impala-hs2-server.cc:363] Opened session: de4f93bde4f4a20f:a9936c73f0436b93 username: root
I0519 02:52:48.371691 29055 impala-hs2-server.cc:414] ExecuteStatement(): request=TExecuteStatementReq {
  01: sessionHandle (struct) = TSessionHandle {
    01: sessionId (struct) = THandleIdentifier {
      01: guid (string) = "\x0f\xa2\xf4\xe4\xbd\x93O\xde\x93kC\xf0sl\x93\xa9",
      02: secret (string) = "j\x88'\xc9[\x95C\xb8\xb0l\xdb\xcfI\xfd\xaf\xa7",
    },
  },
  02: statement (string) = "SELECT SUBSTRING[...](627)",
  04: runAsync (bool) = true,
}
I0519 02:52:48.371739 29055 impala-hs2-server.cc:215] TExecuteStatementReq: TExecuteStatementReq {
  01: sessionHandle (struct) = TSessionHandle {
    01: sessionId (struct) = THandleIdentifier {
      01: guid (string) = "\x0f\xa2\xf4\xe4\xbd\x93O\xde\x93kC\xf0sl\x93\xa9",
      02: secret (string) = "j\x88'\xc9[\x95C\xb8\xb0l\xdb\xcfI\xfd\xaf\xa7",
    },
  },
  02: statement (string) = "SELECT SUBSTRING[...](627)",
  04: runAsync (bool) = true,
}
/now()
  55: parquet_read_statistics (bool) = true,
  56: default_join_distribution_mode (i32) = 0,
  57: disable_codegen_rows_threshold (i32) = 50000,
  58: default_spillable_buffer_size (i64) = 2097152,
  59: min_spillable_buffer_size (i64) = 65536,
  60: max_row_size (i64) = 524288,
  61: idle_session_timeout (i32) = 0,
  62: compute_stats_min_sample_size (i64) = 1073741824,
  63: exec_time_limit_s (i32) = 0,
  64: shuffle_distinct_exprs (bool) = true,
  65: max_mem_estimate_for_admission (i64) = 0,
  66: thread_reservation_limit (i32) = 3000,
  67: thread_reservation_aggregate_limit (i32) = 0,
  68: kudu_read_mode (i32) = 0,
  69: allow_erasure_coded_files (bool) = false,
  70: timezone (string) = "",
  71: scan_bytes_limit (i64) = 0,
  72: cpu_limit_s (i64) = 0,
  73: topn_bytes_limit (i64) = 536870912,
  75: resource_trace_ratio (double) = 0,
  76: num_remote_executor_candidates (i32) = 3,
  77: num_rows_produced_limit (i64) = 0,
  78: planner_testcase_mode (bool) = false,
}
I0519 02:52:48.372236 29055 impala-server.cc:1018] Found local timezone "Asia/Shanghai".
I0519 02:52:48.373980 29055 impala-server.cc:1078] 5345565fdb545a98:49e184b000000000] Registered query query_id=5345565fdb545a98:49e184b000000000 session_id=de4f93bde4f4a20f:a9936c73f0436b93
I0519 02:52:48.374166 29055 Frontend.java:1245] 5345565fdb545a98:49e184b000000000] Analyzing query: SELECT SUBSTRING(bike_sn, 1, 4) AS bike_sn_prefix,
       bike_model AS bike_model,
       COUNT(1) AS value
FROM ods.ods_ebike_galaxy_bike_usage_day_full
WHERE create_time >= '2020-05-12 00:00:00'
  AND create_time <= '2020-05-19 02:52:47'
  AND ((event_day = from_unixtime(unix_timestamp(days_sub(now(), 1)), 'yyyyMMdd')))
  AND ((event_day = from_unixtime(unix_timestamp(days_sub(now(), 1)), 'yyyyMMdd')))
  AND ((city_id in (355,
                    398,
                    404,
                    436,
                    473)))
GROUP BY SUBSTRING(bike_sn, 1, 4),
         bike_model
HAVING ((COUNT(1) > 20))
LIMIT 10000 db: default
I0519 02:52:48.374673 29055 FeSupport.java:285] 5345565fdb545a98:49e184b000000000] Requesting prioritized load of table(s): ods.ods_ebike_galaxy_bike_usage_day_full
I0519 02:52:49.351804 29072 impala-hs2-server.cc:284] Opening session: dc4c234229d6ec43:c108c01ad7bddf8e username: root
I0519 02:52:49.351913 29072 impala-hs2-server.cc:363] Opened session: dc4c234229d6ec43:c108c01ad7bddf8e username: root
I0519 02:52:49.355667 29072 impala-hs2-server.cc:414] ExecuteStatement(): request=TExecuteStatementReq {
  01: sessionHandle (struct) = TSessionHandle {
    01: sessionId (struct) = THandleIdentifier {
      01: guid (string) = "C\xec\xd6)B#L\xdc\x8e\xdf\xbd\xd7\x1a\xc0\b\xc1",
      02: secret (string) = "\x9b*\x10\x06\xe1\xdfI)\x84?#\xba\xa8\f\xe44",
    },
  },
  02: statement (string) = "SELECT SUBSTRING[...](574)",
  04: runAsync (bool) = true,
}
I0519 02:52:49.355825 29072 impala-hs2-server.cc:215] TExecuteStatementReq: TExecuteStatementReq {
  01: sessionHandle (struct) = TSessionHandle {
    01: sessionId (struct) = THandleIdentifier {
      01: guid (string) = "C\xec\xd6)B#L\xdc\x8e\xdf\xbd\xd7\x1a\xc0\b\xc1",
      02: secret (string) = "\x9b*\x10\x06\xe1\xdfI)\x84?#\xba\xa8\f\xe44",
    },
  },
  02: statement (string) = "SELECT SUBSTRING[...](574)",
  04: runAsync (bool) = true,
/now()
  54: parquet_array_resolution (i32) = 0,
  55: parquet_read_statistics (bool) = true,
  56: default_join_distribution_mode (i32) = 0,
  57: disable_codegen_rows_threshold (i32) = 50000,
  58: default_spillable_buffer_size (i64) = 2097152,
  59: min_spillable_buffer_size (i64) = 65536,
  60: max_row_size (i64) = 524288,
  61: idle_session_timeout (i32) = 0,
  62: compute_stats_min_sample_size (i64) = 1073741824,
  63: exec_time_limit_s (i32) = 0,
  64: shuffle_distinct_exprs (bool) = true,
  65: max_mem_estimate_for_admission (i64) = 0,
  66: thread_reservation_limit (i32) = 3000,
  67: thread_reservation_aggregate_limit (i32) = 0,
  68: kudu_read_mode (i32) = 0,
  69: allow_erasure_coded_files (bool) = false,
  70: timezone (string) = "",
  71: scan_bytes_limit (i64) = 0,
  72: cpu_limit_s (i64) = 0,
  73: topn_bytes_limit (i64) = 536870912,
  75: resource_trace_ratio (double) = 0,
  76: num_remote_executor_candidates (i32) = 3,
  77: num_rows_produced_limit (i64) = 0,
  78: planner_testcase_mode (bool) = false,
}
I0519 02:52:49.356329 29072 impala-server.cc:1018] Found local timezone "Asia/Shanghai".
I0519 02:52:49.358278 29072 impala-server.cc:1078] 2045e398d51a7f9f:2891977500000000] Registered query query_id=2045e398d51a7f9f:2891977500000000 session_id=dc4c234229d6ec43:c108c01ad7bddf8e
I0519 02:52:49.358455 29072 Frontend.java:1245] 2045e398d51a7f9f:2891977500000000] Analyzing query: SELECT SUBSTRING(bike_model, 1, 1) AS bike_mode,
       COUNT(1) AS value
FROM ods.ods_ebike_galaxy_bike_usage_day_full
WHERE create_time >= '2020-05-12 00:00:00'
  AND create_time <= '2020-05-19 02:52:47'
  AND ((event_day = from_unixtime(unix_timestamp(days_sub(now(), 1)), 'yyyyMMdd')))
  AND ((event_day = from_unixtime(unix_timestamp(days_sub(now(), 1)), 'yyyyMMdd')))
  AND ((city_id in (355,
                    398,
                    404,
                    436,
                    473)))
GROUP BY SUBSTRING(bike_model, 1, 1)
HAVING ((COUNT(1) > 20))
LIMIT 10000 db: default
I0519 02:52:49.359012 29072 FeSupport.java:285] 2045e398d51a7f9f:2891977500000000] Requesting prioritized load of table(s): ods.ods_ebike_galaxy_bike_usage_day_full
I0519 02:52:49.395826 29073 impala-hs2-server.cc:284] Opening session: b44a36836231ad58:210ca34afc661e80 username: root
I0519 02:52:49.395931 29073 impala-hs2-server.cc:363] Opened session: b44a36836231ad58:210ca34afc661e80 username: root
I0519 02:52:49.399513 29073 impala-hs2-server.cc:414] ExecuteStatement(): request=TExecuteStatementReq {
  01: sessionHandle (struct) = TSessionHandle {
    01: sessionId (struct) = THandleIdentifier {
      01: guid (string) = "X\xad1b\x836J\xb4\x80\x1ef\xfcJ\xa3\f!",
      02: secret (string) = "\xac\xfd\x007zIA\xf6\x88\xef\xdfB=8\xdc\xfe",
    },
  },
  02: statement (string) = "SELECT CONCAT(su[...](1692)",
  04: runAsync (bool) = true,
}
I0519 02:52:49.399550 29073 impala-hs2-server.cc:215] TExecuteStatementReq: TExecuteStatementReq {
  01: sessionHandle (struct) = TSessionHandle {
    01: sessionId (struct) = THandleIdentifier {
      01: guid (string) = "X\xad1b\x836J\xb4\x80\x1ef\xfcJ\xa3\f!",
      02: secret (string) = "\xac\xfd\x007zIA\xf6\x88\xef\xdfB=8\xdc\xfe",
    },
  },
  02: statement (string) = "SELECT CONCAT(su[...](1692)",
  04: runAsync (bool) = true,
}
/now()
    02: operationType (i32) = 0,
    03: hasResultSet (bool) = true,
  },
}
I0519 02:52:54.533201 29180 admission-controller.cc:622] 5345565fdb545a98:49e184b000000000] Stats: agg_num_running=0, agg_num_queued=0, agg_mem_reserved=0,  local_host(local_mem_admitted=0, num_admitted_running=0, num_queued=0, backend_mem_reserved=0)
I0519 02:52:54.533221 29180 admission-controller.cc:654] 5345565fdb545a98:49e184b000000000] Admitted query id=5345565fdb545a98:49e184b000000000
I0519 02:52:54.533260 29180 coordinator.cc:95] 5345565fdb545a98:49e184b000000000] Exec() query_id=5345565fdb545a98:49e184b000000000 stmt=SELECT SUBSTRING(bike_sn, 1, 4) AS bike_sn_prefix,
       bike_model AS bike_model,
       COUNT(1) AS value
FROM ods.ods_ebike_galaxy_bike_usage_day_full
WHERE create_time >= '2020-05-12 00:00:00'
  AND create_time <= '2020-05-19 02:52:47'
  AND ((event_day = from_unixtime(unix_timestamp(days_sub(now(), 1)), 'yyyyMMdd')))
  AND ((event_day = from_unixtime(unix_timestamp(days_sub(now(), 1)), 'yyyyMMdd')))
  AND ((city_id in (355,
                    398,
                    404,
                    436,
                    473)))
GROUP BY SUBSTRING(bike_sn, 1, 4),
         bike_model
HAVING ((COUNT(1) > 20))
LIMIT 10000
I0519 02:52:54.533305 29181 admission-controller.cc:617] 6b4e7ce3e5910d28:d53c427500000000] Schedule for id=6b4e7ce3e5910d28:d53c427500000000 in pool_name=root.users.root per_host_mem_estimate=384.04 MB PoolConfig: max_requests=-1 max_queued=200 max_mem=-1.00 B
I0519 02:52:54.533368 29181 admission-controller.cc:622] 6b4e7ce3e5910d28:d53c427500000000] Stats: agg_num_running=1, agg_num_queued=0, agg_mem_reserved=0,  local_host(local_mem_admitted=1.50 GB, num_admitted_running=1, num_queued=0, backend_mem_reserved=0)
I0519 02:52:54.533383 29181 admission-controller.cc:654] 6b4e7ce3e5910d28:d53c427500000000] Admitted query id=6b4e7ce3e5910d28:d53c427500000000
I0519 02:52:54.533422 29181 coordinator.cc:95] 6b4e7ce3e5910d28:d53c427500000000] Exec() query_id=6b4e7ce3e5910d28:d53c427500000000 stmt=SELECT bike_model AS bike_model,
       COUNT(1) AS value
FROM ods.ods_ebike_galaxy_bike_usage_day_full
WHERE create_time >= '2020-05-12 00:00:00'
  AND create_time <= '2020-05-19 02:52:47'
  AND ((event_day = from_unixtime(unix_timestamp(days_sub(now(), 1)), 'yyyyMMdd')))
  AND ((event_day = from_unixtime(unix_timestamp(days_sub(now(), 1)), 'yyyyMMdd')))
  AND ((city_id in (355,
                    398,
                    404,
                    436,
                    473)))
GROUP BY bike_model
HAVING ((COUNT(1) > 20))
LIMIT 10000
I0519 02:52:54.533452 29182 admission-controller.cc:617] 2045e398d51a7f9f:2891977500000000] Schedule for id=2045e398d51a7f9f:2891977500000000 in pool_name=root.users.root per_host_mem_estimate=384.05 MB PoolConfig: max_requests=-1 max_queued=200 max_mem=-1.00 B
I0519 02:52:54.533465 29180 coordinator.cc:361] 5345565fdb545a98:49e184b000000000] starting execution on 4 backends for query_id=5345565fdb545a98:49e184b000000000
I0519 02:52:54.533495 29182 admission-controller.cc:622] 2045e398d51a7f9f:2891977500000000] Stats: agg_num_running=2, agg_num_queued=0, agg_mem_reserved=0,  local_host(local_mem_admitted=3.00 GB, num_admitted_running=2, num_queued=0, backend_mem_reserved=0)
I0519 02:52:54.533507 29182 admission-controller.cc:654] 2045e398d51a7f9f:2891977500000000] Admitted query id=2045e398d51a7f9f:2891977500000000
I0519 02:52:54.533512 29055 impala-hs2-server.cc:484] ExecuteStatement(): return_val=TExecuteStatementResp {
  01: status (struct) = TStatus {
    01: statusCode (i32) = 0,
  },
  02: operationHandle (struct) = TOperationHandle {
    01: operationId (struct) = THandleIdentifier {
      01: guid (string) = "\x98ZT\xdb_VES\x00\x00\x00\x00\xb0\x84\xe1I",
      02: secret (string) = "j\x88'\xc9[\x95C\xb8\xb0l\xdb\xcfI\xfd\xaf\xa7",
    },
    02: operationType (i32) = 0,
    03: hasResultSet (bool) = true,
  },
}
I0519 02:52:54.533533 29182 coordinator.cc:95] 2045e398d51a7f9f:2891977500000000] Exec() query_id=2045e398d51a7f9f:2891977500000000 stmt=SELECT SUBSTRING(bike_model, 1, 1) AS bike_mode,
       COUNT(1) AS value
FROM ods.ods_ebike_galaxy_bike_usage_day_full
WHERE create_time >= '2020-05-12 00:00:00'
  AND create_time <= '2020-05-19 02:52:47'
  AND ((event_day = from_unixtime(unix_timestamp(days_sub(now(), 1)), 'yyyyMMdd')))
  AND ((event_day = from_unixtime(unix_timestamp(days_sub(now(), 1)), 'yyyyMMdd')))
/now()
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:451)
        at org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:421)
        at org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:1285)
        at org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:1252)
        at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1222)
        at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:167)
I0519 11:31:24.792260 32351 jni-util.cc:256] 1b4f5e3b581d75b3:5160a58400000000] org.apache.impala.common.AnalysisException: now() unknown
        at org.apache.impala.analysis.FunctionCallExpr.analyzeImpl(FunctionCallExpr.java:493)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:431)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyzeWhereClause(SelectStmt.java:332)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:211)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:451)
        at org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:421)
        at org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:1285)
        at org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:1252)
        at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1222)
        at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:167)
I0519 11:31:24.793052 32371 status.cc:124] 804eb3cf6e3dca08:259a6d2f00000000] AnalysisException: sum() unknown
    @           0xb4c589
    @          0x115024e
    @          0x102af73
    @          0x1052fc2
    @          0x105ecac
    @          0x10af853
    @          0x13b0817
    @          0x13ac99c
    @           0xb18299
    @           0xf2d5f8
    @           0xf2406e
    @           0xf24f01
    @          0x11c622f
    @          0x11c6dd9
    @          0x1840c09
    @     0x7f7f3f579dd4
    @     0x7f7f3f2a302c
I0519 11:31:24.793109 32371 impala-server.cc:1157] 804eb3cf6e3dca08:259a6d2f00000000] UnregisterQuery(): query_id=804eb3cf6e3dca08:259a6d2f00000000
I0519 11:31:24.793119 32371 impala-server.cc:1264] 804eb3cf6e3dca08:259a6d2f00000000] Cancel(): query_id=804eb3cf6e3dca08:259a6d2f00000000
I0519 11:31:24.793324 32351 status.cc:124] 1b4f5e3b581d75b3:5160a58400000000] AnalysisException: now() unknown
/now()
FROM temp.view_comp_summary_sg_day_da
WHERE cur_date >= '2020-05-18 00:00:00'
  AND cur_date <= '2020-05-19 14:31:33'
GROUP BY if(rn_all_input <= 10, brand_name, '其他')
LIMIT 50000 db: default
I0519 14:31:33.943261 16435 FeSupport.java:285] bb4c7ed9a1018cc3:08f9bac500000000] Requesting prioritized load of table(s): temp.view_comp_summary_sg_day_da
I0519 14:31:38.123204  8936 ImpaladCatalog.java:200] Adding: TABLE:temp.view_comp_summary_sg_day_da version: 7546493 size: 5992
I0519 14:31:38.123319  8936 ImpaladCatalog.java:200] Adding: CATALOG_SERVICE_ID version: 7546493 size: 49
I0519 14:31:38.124765  8936 impala-server.cc:1610] Catalog topic update applied with version: 7546493 new min catalog object version: 7545512
I0519 14:31:38.128190 16431 jni-util.cc:256] 78471a8ba873cef2:e909fa6300000000] org.apache.impala.common.AnalysisException: sum() unknown
        at org.apache.impala.analysis.FunctionCallExpr.analyzeImpl(FunctionCallExpr.java:493)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:431)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyzeSelectClause(SelectStmt.java:269)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:209)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:451)
        at org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:421)
        at org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:1285)
        at org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:1252)
        at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1222)
        at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:167)
I0519 14:31:38.128202 16435 jni-util.cc:256] bb4c7ed9a1018cc3:08f9bac500000000] org.apache.impala.common.AnalysisException: default.now() unknown
        at org.apache.impala.analysis.FunctionCallExpr.analyzeImpl(FunctionCallExpr.java:493)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:431)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyzeWhereClause(SelectStmt.java:332)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:211)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:451)
        at org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:421)
        at org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:1285)
        at org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:1252)
        at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1222)
        at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:167)
I0519 14:31:38.128194 16433 jni-util.cc:256] db47db4e9e704343:0768a82000000000] org.apache.impala.common.AnalysisException: sum() unknown
        at org.apache.impala.analysis.FunctionCallExpr.analyzeImpl(FunctionCallExpr.java:493)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:431)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyzeSelectClause(SelectStmt.java:269)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:209)
/now()
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:451)
        at org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:421)
        at org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:1285)
        at org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:1252)
        at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1222)
        at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:167)
I0519 14:31:38.129792 16431 status.cc:124] 78471a8ba873cef2:e909fa6300000000] AnalysisException: sum() unknown
    @           0xb4c589
    @          0x115024e
    @          0x102af73
    @          0x1052fc2
    @          0x105ecac
    @          0x10af853
    @          0x13b0817
    @          0x13ac99c
    @           0xb18299
    @           0xf2d5f8
    @           0xf2406e
    @           0xf24f01
    @          0x11c622f
    @          0x11c6dd9
    @          0x1840c09
    @     0x7f7f3f579dd4
    @     0x7f7f3f2a302c
I0519 14:31:38.129900 16431 impala-server.cc:1157] 78471a8ba873cef2:e909fa6300000000] UnregisterQuery(): query_id=78471a8ba873cef2:e909fa6300000000
I0519 14:31:38.129914 16431 impala-server.cc:1264] 78471a8ba873cef2:e909fa6300000000] Cancel(): query_id=78471a8ba873cef2:e909fa6300000000
I0519 14:31:38.130296 16435 status.cc:124] bb4c7ed9a1018cc3:08f9bac500000000] AnalysisException: default.now() unknown
    @           0xb4c589
    @          0x115024e
    @          0x102af73
    @          0x1052fc2
    @          0x105ecac
    @          0x10af853
    @          0x13b0817
    @          0x13ac99c
    @           0xb18299
    @           0xf2d5f8
    @           0xf2406e
    @           0xf24f01
    @          0x11c622f
    @          0x11c6dd9
    @          0x1840c09
    @     0x7f7f3f579dd4
    @     0x7f7f3f2a302c
I0519 14:31:38.130296 16433 status.cc:124] db47db4e9e704343:0768a82000000000] AnalysisException: sum() unknown
    @           0xb4c589
    @          0x115024e
    @          0x102af73
    @          0x1052fc2
    @          0x105ecac
    @          0x10af853
    @          0x13b0817
    @          0x13ac99c
    @           0xb18299
    @           0xf2d5f8
    @           0xf2406e
    @           0xf24f01
    @          0x11c622f
    @          0x11c6dd9
/now()
        at org.apache.impala.analysis.Expr.analyze(Expr.java:431)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyzeWhereClause(SelectStmt.java:332)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:211)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:451)
        at org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:421)
        at org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:1285)
        at org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:1252)
        at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1222)
        at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:167)
I0519 15:10:45.235793  1522 status.cc:124] cb426057af16e04a:0c16fd7a00000000] AnalysisException: now() unknown
    @           0xb4c589
    @          0x115024e
    @          0x102af73
    @          0x1052fc2
    @          0x105ecac
    @          0x10af853
    @          0x13b0817
    @          0x13ac99c
    @           0xb18299
    @           0xf2d5f8
    @           0xf2406e
    @           0xf24f01
    @          0x11c622f
    @          0x11c6dd9
    @          0x1840c09
    @     0x7f7f3f579dd4
    @     0x7f7f3f2a302c
I0519 15:10:45.235831  1529 status.cc:124] 764f5ad58d2dc9a5:a3153fa700000000] AnalysisException: now() unknown
    @           0xb4c589
    @          0x115024e
    @          0x102af73
    @          0x1052fc2
    @          0x105ecac
    @          0x10af853
    @          0x13b0817
    @          0x13ac99c
    @           0xb18299
    @           0xf2d5f8
    @           0xf2406e
    @           0xf24f01
    @          0x11c622f
    @          0x11c6dd9
    @          0x1840c09
    @     0x7f7f3f579dd4
    @     0x7f7f3f2a302c
I0519 15:10:45.235910  1529 impala-server.cc:1157] 764f5ad58d2dc9a5:a3153fa700000000] UnregisterQuery(): query_id=764f5ad58d2dc9a5:a3153fa700000000
I0519 15:10:45.235921  1529 impala-server.cc:1264] 764f5ad58d2dc9a5:a3153fa700000000] Cancel(): query_id=764f5ad58d2dc9a5:a3153fa700000000
I0519 15:10:45.235906  1523 status.cc:124] 5342445e9d84889c:138693a900000000] AnalysisException: now() unknown
/now()
FROM temp.view_comp_summary_day_da
WHERE cur_date >= '2020-04-19 00:00:00'
  AND cur_date <= '2020-05-19 15:30:32'
  AND rn_order <= 15
GROUP BY brand_name,
         TRUNC(cur_date, 'DD')
LIMIT 50000 db: default
I0519 15:30:32.929512 31680 FeSupport.java:285] 3e4e2567244405d1:1387ef2000000000] Requesting prioritized load of table(s): temp.view_comp_summary_day_da
I0519 15:30:32.929595 31682 FeSupport.java:285] d44e28ae963fe4b1:10a67e2000000000] Requesting prioritized load of table(s): temp.view_comp_summary_day_da
I0519 15:30:32.929692 31681 FeSupport.java:285] 4c45a3304d0dc218:56ffa3af00000000] Requesting prioritized load of table(s): temp.view_comp_summary_day_da
I0519 15:30:32.929905 31683 impala-server.cc:1078] 7948060a6ff199fc:a97c8bcb00000000] Registered query query_id=7948060a6ff199fc:a97c8bcb00000000 session_id=594929f4674cce4f:48fdb0732c621bbf
I0519 15:30:32.930023 31683 Frontend.java:1245] 7948060a6ff199fc:a97c8bcb00000000] Analyzing query: SELECT brand_name AS brand_name,
       sum(new_input) AS `最近新投放数`
FROM temp.view_comp_summary_day_da
WHERE cur_date >= '2020-05-18 00:00:00'
  AND cur_date <= '2020-05-19 15:30:32'
  AND rn_new_input <= 15
GROUP BY brand_name
LIMIT 50000 db: default
I0519 15:30:32.930354 31683 FeSupport.java:285] 7948060a6ff199fc:a97c8bcb00000000] Requesting prioritized load of table(s): temp.view_comp_summary_day_da
I0519 15:30:35.720655  8936 ImpaladCatalog.java:200] Adding: TABLE:temp.view_comp_summary_day_da version: 7549458 size: 6339
I0519 15:30:35.720742  8936 ImpaladCatalog.java:200] Adding: CATALOG_SERVICE_ID version: 7549458 size: 49
I0519 15:30:35.722126  8936 impala-server.cc:1610] Catalog topic update applied with version: 7549458 new min catalog object version: 7548455
I0519 15:30:35.722405 31679 FeSupport.java:285] f4476c1c01750e87:8f4cda6300000000] Requesting prioritized load of table(s): dim.dim_comp_xb_brand_df
I0519 15:30:35.722532 31680 FeSupport.java:285] 3e4e2567244405d1:1387ef2000000000] Requesting prioritized load of table(s): dim.dim_comp_xb_brand_df
I0519 15:30:35.722635 31683 FeSupport.java:285] 7948060a6ff199fc:a97c8bcb00000000] Requesting prioritized load of table(s): dim.dim_comp_xb_brand_df
I0519 15:30:35.722709 31682 FeSupport.java:285] d44e28ae963fe4b1:10a67e2000000000] Requesting prioritized load of table(s): dim.dim_comp_xb_brand_df
I0519 15:30:35.722806 31681 FeSupport.java:285] 4c45a3304d0dc218:56ffa3af00000000] Requesting prioritized load of table(s): dim.dim_comp_xb_brand_df
I0519 15:30:35.722885 31678 FeSupport.java:285] d84786b2dc69bd1b:9b40493000000000] Requesting prioritized load of table(s): dim.dim_comp_xb_brand_df
I0519 15:30:39.724175  8936 ImpaladCatalog.java:200] Adding: TABLE:dim.dim_comp_xb_brand_df version: 7549459 size: 38069
I0519 15:30:39.724236  8936 ImpaladCatalog.java:200] Adding: CATALOG_SERVICE_ID version: 7549459 size: 49
I0519 15:30:39.725638  8936 impala-server.cc:1610] Catalog topic update applied with version: 7549459 new min catalog object version: 7548455
I0519 15:30:39.727916 31683 jni-util.cc:256] 7948060a6ff199fc:a97c8bcb00000000] org.apache.impala.common.AnalysisException: now() unknown
        at org.apache.impala.analysis.FunctionCallExpr.analyzeImpl(FunctionCallExpr.java:493)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:431)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:425)
        at org.apache.impala.analysis.TableRef.analyzeJoin(TableRef.java:534)
        at org.apache.impala.analysis.BaseTableRef.analyze(BaseTableRef.java:69)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.InlineViewRef.analyze(InlineViewRef.java:166)
        at org.apache.impala.analysis.FromClause.analyze(FromClause.java:64)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.analyze(SelectStmt.java:207)
        at org.apache.impala.analysis.SelectStmt$SelectAnalyzer.access$100(SelectStmt.java:193)
        at org.apache.impala.analysis.SelectStmt.analyze(SelectStmt.java:186)
        at org.apache.impala.analysis.AnalysisContext.analyze(AnalysisContext.java:451)
        at org.apache.impala.analysis.AnalysisContext.analyzeAndAuthorize(AnalysisContext.java:421)
        at org.apache.impala.service.Frontend.doCreateExecRequest(Frontend.java:1285)
        at org.apache.impala.service.Frontend.getTExecRequest(Frontend.java:1252)
        at org.apache.impala.service.Frontend.createExecRequest(Frontend.java:1222)
        at org.apache.impala.service.JniFrontend.createExecRequest(JniFrontend.java:167)
I0519 15:30:39.727912 31679 jni-util.cc:256] f4476c1c01750e87:8f4cda6300000000] org.apache.impala.common.AnalysisException: default.days_sub() unknown
        at org.apache.impala.analysis.FunctionCallExpr.analyzeImpl(FunctionCallExpr.java:493)
        at org.apache.impala.analysis.Expr.analyze(Expr.java:431)
/now()
    @          0x1052fc2
    @          0x105ecac
    @          0x10af853
    @          0x13b0817
    @          0x13ac99c
    @           0xb18299
    @           0xf2d5f8
    @           0xf2406e
    @           0xf24f01
    @          0x11c622f
    @          0x11c6dd9
    @          0x1840c09
    @     0x7f7f3f579dd4
    @     0x7f7f3f2a302c
I0519 15:30:39.730252 31679 status.cc:124] f4476c1c01750e87:8f4cda6300000000] AnalysisException: default.days_sub() unknown
    @           0xb4c589
    @          0x115024e
    @          0x102af73
    @          0x1052fc2
    @          0x105ecac
    @          0x10af853
    @          0x13b0817
    @          0x13ac99c
    @           0xb18299
    @           0xf2d5f8
    @           0xf2406e
    @           0xf24f01
    @          0x11c622f
    @          0x11c6dd9
    @          0x1840c09
    @     0x7f7f3f579dd4
    @     0x7f7f3f2a302c
I0519 15:30:39.730298 31678 impala-server.cc:1157] d84786b2dc69bd1b:9b40493000000000] UnregisterQuery(): query_id=d84786b2dc69bd1b:9b40493000000000
I0519 15:30:39.730302 31679 impala-server.cc:1157] f4476c1c01750e87:8f4cda6300000000] UnregisterQuery(): query_id=f4476c1c01750e87:8f4cda6300000000
I0519 15:30:39.730306 31678 impala-server.cc:1264] d84786b2dc69bd1b:9b40493000000000] Cancel(): query_id=d84786b2dc69bd1b:9b40493000000000
I0519 15:30:39.730317 31679 impala-server.cc:1264] f4476c1c01750e87:8f4cda6300000000] Cancel(): query_id=f4476c1c01750e87:8f4cda6300000000
I0519 15:30:39.732410 31682 Frontend.java:1286] d44e28ae963fe4b1:10a67e2000000000] Analysis finished.
I0519 15:30:39.735458 31680 impala-hs2-server.cc:369] CloseSession(): request=TCloseSessionReq {
  01: sessionHandle (struct) = TSessionHandle {
    01: sessionId (struct) = THandleIdentifier {
      01: guid (string) = "\xa0\abc3\xd9N\xd3\x9do\xf3\xbc\xe1S%*",
      02: secret (string) = "l\xfa]&\xcb\xd0E\xee\x92\xf80L*\xae4\xe3",
    },
  },
}
I0519 15:30:39.735496 31680 impala-server.cc:1276] Closing session: d34ed933636207a0:2a2553e1bcf36f9d
I0519 15:30:39.735507 31680 impala-server.cc:1323] Closed session: d34ed933636207a0:2a2553e1bcf36f9d
I0519 15:30:39.736064 31678 impala-hs2-server.cc:369] CloseSession(): request=TCloseSessionReq {
  01: sessionHandle (struct) = TSessionHandle {
    01: sessionId (struct) = THandleIdentifier {
      01: guid (string) = "\x1f\xba\x0f\x89\xd0%C6\xb0\x01hE\xf4\xa6\r2",
      02: secret (string) = "\x96\xeeu2\xd7\x94Da\x81\x03z\x98\xb0>\xd6\xd1",
    },
  },
}
I0519 15:30:39.736088 31678 impala-server.cc:1276] Closing session: 364325d0890fba1f:320da6f4456801b0
I0519 15:30:39.736081 31683 impala-hs2-server.cc:369] CloseSession(): request=TCloseSessionReq {
  01: sessionHandle (struct) = TSessionHandle {
    01: sessionId (struct) = THandleIdentifier {
      01: guid (string) = "O\xceLg\xf4)IY\xbf\x1bb,s\xb0\xfdH",
      02: secret (string) = "\xba)\xd5\xc0&(G\xbc\xa8\r\xca\xeb%\x80\xcc+",
    },
  },
}
I0519 15:30:39.736100 31678 impala-server.cc:1323] Closed session: 364325d0890fba1f:320da6f4456801b0