Active Sessions

User Name IP Address Operation Count Active Time (s) Idle Time (s)
airflow 192.168.0.106 1 27 0
airflow 192.168.0.20 1 1155 0
airflow 192.168.0.21 1 70 0
airflow 192.168.1.210 1 813 0
airflow 192.168.0.210 1 434 0
Total number of sessions: 5

Open Queries

User Name Query Execution Engine State Opened Timestamp Opened (s) Latency (s) Drilldown Link
airflow ALTER TABLE helium.l1_blocks ADD IF NOT EXISTS PARTITION ( partition_0='2021-09-21' ) LOCATION 'abfss://helium-l1-archive@topledgerprodciapp01.dfs.core.windows.net/blocks/2021-09-21/' tez RUNNING Sat Dec 20 05:50:16 UTC 2025 0 Not finished Drilldown
airflow ALTER TABLE spltoken22.parsed ADD IF NOT EXISTS PARTITION ( partition_0='2024-09-05' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/token22/parsed/2024-09-05/' tez RUNNING Sat Dec 20 05:50:16 UTC 2025 0 Not finished Drilldown
airflow ALTER TABLE helium_oracle_iot.iotrewardshare ADD IF NOT EXISTS PARTITION ( partition_0='2025-12-19' ) LOCATION 'abfss://helium-solana@topledgerprodciapp01.dfs.core.windows.net/helium-oracle-latest/IotRewardShare/2025-12-19/' tez RUNNING Sat Dec 20 05:50:16 UTC 2025 0 Not finished Drilldown
airflow UNKNOWN tez RUNNING Sat Dec 20 05:50:16 UTC 2025 0 Not finished Drilldown
airflow Unknown tez RUNNING Sat Dec 20 05:50:16 UTC 2025 0 Not finished Drilldown
Total number of queries: 5

Last Max 25 Closed Queries

User Name Query Execution Engine State Opened (s) Closed Timestamp Latency (s) Drilldown Link
airflow ALTER TABLE metaplex.mpl_core ADD IF NOT EXISTS PARTITION ( partition_0='2025-12-10' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/metaplex/parsed/mpl-core/2025-12-10/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE stake_pool.parsed ADD IF NOT EXISTS PARTITION ( partition_0='2024-03-25' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/stake_pool/parsed/2024-03-25/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE helium_oracle_iot.iotrewardshare ADD IF NOT EXISTS PARTITION ( partition_0='2025-05-26' ) LOCATION 'abfss://helium-solana@topledgerprodciapp01.dfs.core.windows.net/helium-oracle-latest/IotRewardShare/2025-05-26/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE spltoken22.parsed ADD IF NOT EXISTS PARTITION ( partition_0='2023-08-06' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/token22/parsed/2023-08-06/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE helium.l1_blocks ADD IF NOT EXISTS PARTITION ( partition_0='2021-12-20' ) LOCATION 'abfss://helium-l1-archive@topledgerprodciapp01.dfs.core.windows.net/blocks/2021-12-20/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE metaplex.mpl_core ADD IF NOT EXISTS PARTITION ( partition_0='2025-06-26' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/metaplex/parsed/mpl-core/2025-06-26/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE stake_pool.parsed ADD IF NOT EXISTS PARTITION ( partition_0='2024-11-04' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/stake_pool/parsed/2024-11-04/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE helium_oracle_iot.iotrewardshare ADD IF NOT EXISTS PARTITION ( partition_0='2023-09-06' ) LOCATION 'abfss://helium-solana@topledgerprodciapp01.dfs.core.windows.net/helium-oracle-latest/IotRewardShare/2023-09-06/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE spltoken22.parsed ADD IF NOT EXISTS PARTITION ( partition_0='2023-06-22' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/token22/parsed/2023-06-22/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE helium.l1_blocks ADD IF NOT EXISTS PARTITION ( partition_0='2022-09-20' ) LOCATION 'abfss://helium-l1-archive@topledgerprodciapp01.dfs.core.windows.net/blocks/2022-09-20/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE metaplex.mpl_core ADD IF NOT EXISTS PARTITION ( partition_0='2025-09-04' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/metaplex/parsed/mpl-core/2025-09-04/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE stake_pool.parsed ADD IF NOT EXISTS PARTITION ( partition_0='2024-08-17' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/stake_pool/parsed/2024-08-17/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE helium_oracle_iot.iotrewardshare ADD IF NOT EXISTS PARTITION ( partition_0='2023-09-04' ) LOCATION 'abfss://helium-solana@topledgerprodciapp01.dfs.core.windows.net/helium-oracle-latest/IotRewardShare/2023-09-04/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE spltoken22.parsed ADD IF NOT EXISTS PARTITION ( partition_0='2025-09-10' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/token22/parsed/2025-09-10/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE helium.l1_blocks ADD IF NOT EXISTS PARTITION ( partition_0='2022-05-31' ) LOCATION 'abfss://helium-l1-archive@topledgerprodciapp01.dfs.core.windows.net/blocks/2022-05-31/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE metaplex.mpl_core ADD IF NOT EXISTS PARTITION ( partition_0='2025-08-09' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/metaplex/parsed/mpl-core/2025-08-09/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE stake_pool.parsed ADD IF NOT EXISTS PARTITION ( partition_0='2024-06-18' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/stake_pool/parsed/2024-06-18/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE helium_oracle_iot.iotrewardshare ADD IF NOT EXISTS PARTITION ( partition_0='2023-11-13' ) LOCATION 'abfss://helium-solana@topledgerprodciapp01.dfs.core.windows.net/helium-oracle-latest/IotRewardShare/2023-11-13/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE spltoken22.parsed ADD IF NOT EXISTS PARTITION ( partition_0='2024-12-15' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/token22/parsed/2024-12-15/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE helium.l1_blocks ADD IF NOT EXISTS PARTITION ( partition_0='2021-10-26' ) LOCATION 'abfss://helium-l1-archive@topledgerprodciapp01.dfs.core.windows.net/blocks/2021-10-26/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE metaplex.mpl_core ADD IF NOT EXISTS PARTITION ( partition_0='2025-01-01' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/metaplex/parsed/mpl-core/2025-01-01/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE stake_pool.parsed ADD IF NOT EXISTS PARTITION ( partition_0='2024-09-17' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/stake_pool/parsed/2024-09-17/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE helium_oracle_iot.iotrewardshare ADD IF NOT EXISTS PARTITION ( partition_0='2025-03-15' ) LOCATION 'abfss://helium-solana@topledgerprodciapp01.dfs.core.windows.net/helium-oracle-latest/IotRewardShare/2025-03-15/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE spltoken22.parsed ADD IF NOT EXISTS PARTITION ( partition_0='2025-06-15' ) LOCATION 'abfss://tl-substreams@topledgerprodciapp01.dfs.core.windows.net/token22/parsed/2025-06-15/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
airflow ALTER TABLE helium.l1_blocks ADD IF NOT EXISTS PARTITION ( partition_0='2020-06-27' ) LOCATION 'abfss://helium-l1-archive@topledgerprodciapp01.dfs.core.windows.net/blocks/2020-06-27/' tez FINISHED 0 Sat Dec 20 05:50:16 UTC 2025 0 Drilldown
Total number of queries: 25

Software Attributes

Attribute Name Value Description
Hive Version 4.0.0, r183f8cb41d3dbed961ffd27999876468ff06690c Hive version and revision
Hive Compiled Fri Mar 29 10:31:16 UTC 2024, runner When Hive was compiled and by whom
HiveServer2 Start Time Sat Dec 20 05:50:16 UTC 2025 Date stamp of when this HiveServer2 was started