Query 7d47f694e4a2cb22:b70fd66700000000


Download Profile (Available Formats): Thrift Json Text 

Query (id=7d47f694e4a2cb22:b70fd66700000000):
  Summary:
    Session ID: 7044b8eb0053daaa:e683040c29c65fba
    Session Type: HIVESERVER2
    HiveServer2 Protocol Version: V6
    Start Time: 2025-09-22 12:57:54.096961000
    End Time: 2025-09-22 12:57:54.254810000
    Duration: 157.849ms (157849 us)
    Query Type: DDL
    Query State: FINISHED
    Impala Query State: FINISHED
    Query Status: OK
    Impala Version: impalad version 4.4.1-RELEASE RELEASE (build ced4193fbfdc9b5635407157c0f18ce00480327c)
    User: psantos
    Connected User: psantos
    Delegated User: 
    Network Address: 172.19.147.17:59658
    Default Db: default
    Sql Statement: SHOW CREATE TABLE people
    Coordinator: impala-0.impala-sv.impala-flight-sql.svc.cluster.local:27000
    Query Options (set by configuration): COMPRESSION_CODEC=TCompressionCodec(codec=ZSTD, compression_level=3),DEFAULT_JOIN_DISTRIBUTION_MODE=SHUFFLE,TIMEZONE=Europe/Moscow,DEFAULT_FILE_FORMAT=PARQUET,DEFAULT_HINTS_INSERT_STATEMENT=NOCLUSTERED,FETCH_ROWS_TIMEOUT_MS=0,ENABLE_OUTER_JOIN_TO_INNER_TRANSFORMATION=1,UTF8_MODE=1
    Query Options (set by configuration and planner): COMPRESSION_CODEC=TCompressionCodec(codec=ZSTD, compression_level=3),MT_DOP=0,DEFAULT_JOIN_DISTRIBUTION_MODE=SHUFFLE,TIMEZONE=Europe/Moscow,DEFAULT_FILE_FORMAT=PARQUET,DEFAULT_HINTS_INSERT_STATEMENT=NOCLUSTERED,FETCH_ROWS_TIMEOUT_MS=0,ENABLE_OUTER_JOIN_TO_INNER_TRANSFORMATION=1,UTF8_MODE=1
    Tables Queried: default.people
    DDL Type: SHOW_CREATE_TABLE
    DDL execution mode: synchronous
    Query Compilation: 109.966ms
       - Metadata of all 1 tables cached: 109.573ms (109.573ms)
       - Analysis finished: 109.695ms (121.695us)
       - Authorization finished (noop): 109.848ms (153.410us)
       - Planning finished: 109.966ms (117.853us)
    Query Timeline: 157.882ms
       - Query submitted: 59.296us (59.296us)
       - Planning finished: 110.506ms (110.447ms)
       - Rows available: 111.488ms (981.698us)
       - Unregister query: 157.882ms (46.393ms)
    Memory Reserve:
    Frontend:
      Referenced Tables: default.people
      Expr memory estimated bytes: 0
       - CatalogFetch.ColumnStats.Hits: 2
       - CatalogFetch.ColumnStats.Misses: 2
       - CatalogFetch.ColumnStats.Requests: 4
       - CatalogFetch.ColumnStats.Time: 0
       - CatalogFetch.DatabaseList.Hits: 1
       - CatalogFetch.DatabaseList.Misses: 0
       - CatalogFetch.DatabaseList.Requests: 1
       - CatalogFetch.DatabaseList.Time: 0
       - CatalogFetch.PartitionLists.Hits: 0
       - CatalogFetch.PartitionLists.Misses: 1
       - CatalogFetch.PartitionLists.Requests: 1
       - CatalogFetch.PartitionLists.Time: 0
       - CatalogFetch.Partitions.Hits: 0
       - CatalogFetch.Partitions.Misses: 1
       - CatalogFetch.Partitions.Requests: 1
       - CatalogFetch.Partitions.Time: 0
       - CatalogFetch.RPCs.Bytes: 8.64 KB (8848)
       - CatalogFetch.RPCs.Requests: 5
       - CatalogFetch.RPCs.Time: 0
       - CatalogFetch.StorageLoad.Time: 0
       - CatalogFetch.TableList.Hits: 1
       - CatalogFetch.TableList.Misses: 0
       - CatalogFetch.TableList.Requests: 1
       - CatalogFetch.TableList.Time: 0
       - CatalogFetch.Tables.Hits: 0
       - CatalogFetch.Tables.Misses: 3
       - CatalogFetch.Tables.Requests: 3
       - CatalogFetch.Tables.Time: 107ms
       - ExecutorGroupsConsidered: 1 (1)
      Executor group 1:
        Verdict: Assign to first group because query is not auto-scalable
         - MemoryMax: 8589934592.00 GB (9223372036854775807)
  ImpalaServer:
     - ClientFetchWaitTimeStats: (Avg: 44.619ms ; Min: 44.619ms ; Max: 44.619ms ; Number of samples: 1)
     - GetInFlightProfileTimeStats: 0.000ns (Number of samples: 0)
     - ClientFetchLockWaitTimer: 167.000ns
     - ClientFetchWaitTimer: 44.619ms
     - NumRowsFetched: 0 (0)
     - NumRowsFetchedFromCache: 0 (0)
     - RPCCount: 4 (4)
     - RPCReadTimer: 6.000us
     - RPCWriteTimer: 176.000us
     - RowMaterializationRate: 0
     - RowMaterializationTimer: 0.000ns