Queries

This page lists all running queries, plus any completed queries that are archived in memory. The size of that archive is controlled with the --query_log_size command line parameter.

0 queries in flight

User Default Db Statement Query Type Start Time Duration Scan Progress State Last Event # rows fetched Resource Pool Details Action

0 waiting to be closed [?]

User Default Db Statement Query Type Start Time Waiting Time Duration Scan Progress State Last Event # rows fetched Resource Pool Details Action

Last 25 Completed Queries

User Default Db Statement Query Type Start Time End Time Duration Scan Progress State # rows fetched Resource Pool Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:59:01.511987000 2025-06-18 05:59:01.730483000 218.496ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:58:02.057149000 2025-06-18 05:58:02.187694000 130.544ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:57:01.411719000 2025-06-18 05:57:01.541451000 129.732ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:56:01.859606000 2025-06-18 05:56:01.990382000 130.776ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:55:01.455270000 2025-06-18 05:55:01.585148000 129.877ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:54:02.000078000 2025-06-18 05:54:02.129916000 129.838ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:53:01.600579000 2025-06-18 05:53:01.731789000 131.210ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:52:02.106391000 2025-06-18 05:52:02.232478000 126.087ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:51:01.622433000 2025-06-18 05:51:01.751444000 129.011ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:50:02.003843000 2025-06-18 05:50:02.138257000 134.414ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:49:01.409271000 2025-06-18 05:49:01.538968000 129.697ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:48:01.748808000 2025-06-18 05:48:01.879027000 130.219ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:47:02.079454000 2025-06-18 05:47:02.217264000 137.810ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:46:01.706532000 2025-06-18 05:46:01.834991000 128.459ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:45:01.151660000 2025-06-18 05:45:01.281230000 129.570ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:44:01.425587000 2025-06-18 05:44:01.572924000 147.337ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:43:01.669337000 2025-06-18 05:43:01.797963000 128.626ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:42:01.380743000 2025-06-18 05:42:01.513166000 132.423ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:41:02.068791000 2025-06-18 05:41:02.203636000 134.845ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:40:01.456078000 2025-06-18 05:40:01.585843000 129.764ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:39:01.888759000 2025-06-18 05:39:02.020801000 132.042ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:38:01.796971000 2025-06-18 05:38:01.926558000 129.586ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:37:01.560515000 2025-06-18 05:37:01.686743000 126.228ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:36:01.737420000 2025-06-18 05:36:01.870483000 133.063ms 1 / 1 ( 100%) FINISHED 0 root.root Details
root default INSERT overwrite TABLE educator.event_data_impala_tmp SELECT event_name,count(1) as impala_count,date_time FROM educator.t_event WHERE date_time ='2025-06-17' GROUP BY event_name,date_time DML 2025-06-18 05:35:01.712560000 2025-06-18 05:35:01.841324000 128.764ms 1 / 1 ( 100%) FINISHED 0 root.root Details

Query Locations

Location Number of running queries with fragments on this host
hadoop003:22000 0
hadoop002:22000 0
hadoop001:22000 0