Thrift JDBC/ODBC Server - JDBC/ODBC Session

JDBC/ODBC Session

Started at: 2025/06/12 22:03:11
Time since start: 2 days 14 hours 7 minutes

User jonathan, IP 205.250.61.41, Session created at 2025/06/13 23:27:00, Total run 7 SQL

SQL Statistics

Page:

1

User	JobID	GroupID	Start Time ▾	Finish Time	Close Time	Execution Time	Duration	Statement	State	Detail
jonathan		420aad98-a026-4b03-91ed-a2e3e50b509a	2025/06/13 23:27:03	2025/06/13 23:27:03	2025/06/13 23:27:04	11 ms	346 ms	SHOW TABLES IN `global_temp`	CLOSED	== Parsed Logical Plan == +details == Parsed Logical Plan == 'ShowTables [namespace#3798, tableName#3799, isTemporary#3800] +- 'UnresolvedNamespace [global_temp] == Analyzed Logical Plan == namespace: string, tableName: string, isTemporary: boolean ShowTables [namespace#3798, tableName#3799, isTemporary#3800] +- ResolvedNamespace V2SessionCatalog(spark_catalog), [global_temp] == Optimized Logical Plan == CommandResult [namespace#3798, tableName#3799, isTemporary#3800], ShowTables [namespace#3798, tableName#3799, isTemporary#3800], V2SessionCatalog(spark_catalog), [global_temp] +- ShowTables [namespace#3798, tableName#3799, isTemporary#3800] +- ResolvedNamespace V2SessionCatalog(spark_catalog), [global_temp] == Physical Plan == CommandResult <empty>, [namespace#3798, tableName#3799, isTemporary#3800] +- ShowTables [namespace#3798, tableName#3799, isTemporary#3800], V2SessionCatalog(spark_catalog), [global_temp]
jonathan		b35330e2-2881-406e-9686-7716a3933bd4	2025/06/13 23:27:03	2025/06/13 23:27:03	2025/06/13 23:27:03	39 ms	320 ms	SHOW TABLES IN `test`	CLOSED	== Parsed Logical Plan == +details == Parsed Logical Plan == 'ShowTables [namespace#3788, tableName#3789, isTemporary#3790] +- 'UnresolvedNamespace [test] == Analyzed Logical Plan == namespace: string, tableName: string, isTemporary: boolean ShowTables [namespace#3788, tableName#3789, isTemporary#3790] +- ResolvedNamespace V2SessionCatalog(spark_catalog), [test] == Optimized Logical Plan == CommandResult [namespace#3788, tableName#3789, isTemporary#3790], ShowTables [namespace#3788, tableName#3789, isTemporary#3790], V2SessionCatalog(spark_catalog), [test] +- ShowTables [namespace#3788, tableName#3789, isTemporary#3790] +- ResolvedNamespace V2SessionCatalog(spark_catalog), [test] == Physical Plan == CommandResult <empty>, [namespace#3788, tableName#3789, isTemporary#3790] +- ShowTables [namespace#3788, tableName#3789, isTemporary#3790], V2SessionCatalog(spark_catalog), [test]
jonathan		d3607e54-df5f-406c-b493-bbdc49b92c86	2025/06/13 23:27:03	2025/06/13 23:27:03	2025/06/13 23:27:03	26 ms	337 ms	SHOW TABLES IN `onetableschema`	CLOSED	== Parsed Logical Plan == +details == Parsed Logical Plan == 'ShowTables [namespace#3768, tableName#3769, isTemporary#3770] +- 'UnresolvedNamespace [onetableschema] == Analyzed Logical Plan == namespace: string, tableName: string, isTemporary: boolean ShowTables [namespace#3768, tableName#3769, isTemporary#3770] +- ResolvedNamespace V2SessionCatalog(spark_catalog), [onetableschema] == Optimized Logical Plan == CommandResult [namespace#3768, tableName#3769, isTemporary#3770], ShowTables [namespace#3768, tableName#3769, isTemporary#3770], V2SessionCatalog(spark_catalog), [onetableschema], [[0,200000000e,300000000c,0,656c626174656e6f,616d65686373,73657079746c6c61,74736574]] +- ShowTables [namespace#3768, tableName#3769, isTemporary#3770] +- ResolvedNamespace V2SessionCatalog(spark_catalog), [onetableschema] == Physical Plan == CommandResult [namespace#3768, tableName#3769, isTemporary#3770] +- ShowTables [namespace#3768, tableName#3769, isTemporary#3770], V2SessionCatalog(spark_catalog), [onetableschema]
jonathan		12459dfe-ccf0-4f29-ae6a-39888705b926	2025/06/13 23:27:02	2025/06/13 23:27:02	2025/06/13 23:27:02	25 ms	342 ms	SHOW TABLES IN `default`	CLOSED	== Parsed Logical Plan == +details == Parsed Logical Plan == 'ShowTables [namespace#3748, tableName#3749, isTemporary#3750] +- 'UnresolvedNamespace [default] == Analyzed Logical Plan == namespace: string, tableName: string, isTemporary: boolean ShowTables [namespace#3748, tableName#3749, isTemporary#3750] +- ResolvedNamespace V2SessionCatalog(spark_catalog), [default] == Optimized Logical Plan == CommandResult [namespace#3748, tableName#3749, isTemporary#3750], ShowTables [namespace#3748, tableName#3749, isTemporary#3750], V2SessionCatalog(spark_catalog), [default], [[0,2000000007,2800000008,0,746c7561666564,7374726f70726961], [0,2000000007,2800000008,0,746c7561666564,73657079746c6c61], [0,2000000007,2800000009,0,746c7561666564,73657079746c6c61,32], [0,2000000007,280000000d,0,746c7561666564,73657079746c6c61,6369736162], [0,2000000007,280000000e,0,746c7561666564,73657079746c6c61,326369736162], [0,2000000007,2800000009,0,746c7561666564,7079747961727261,65], [0,2000000007,280000000a,0,746c7561666564,7974746e69676962,6570], [0,2000000007,280000000a,0,746c7561666564,79747972616e6962,6570], [0,2000000007,2800000008,0,746c7561666564,6570797465746164], [0,2000000007,280000000b,0,746c7561666564,746c616d69636564,657079], [0,2000000007,2800000009,0,746c7561666564,70797474616f6c66,65], [0,2000000007,2800000008,0,746c7561666564,736570797470616d], [0,2000000007,280000000b,0,746c7561666564,646978617463796e,617461], [0,2000000007,280000000f,0,746c7561666564,746978617463796e,61746164706972], [0,2000000007,2800000010,0,746c7561666564,7365745f656d6f73,32656c6261745f74], [0,2000000007,280000000a,0,746c7561666564,7974746375727473,6570], [0,2000000007,280000000e,0,746c7561666564,656e6f7a69786174,70756b6f6f6c], [0,2000000007,280000000c,0,746c7561666564,74676e696b726f77,73657079], [0,2000000007,2800000016,0,746c7561666564,74676e696b726f77,6874697773657079,7265626d756e]] +- ShowTables [namespace#3748, tableName#3749, isTemporary#3750] +- ResolvedNamespace V2SessionCatalog(spark_catalog), [default] == Physical Plan == CommandResult [namespace#3748, tableName#3749, isTemporary#3750] +- ShowTables [namespace#3748, tableName#3749, isTemporary#3750], V2SessionCatalog(spark_catalog), [default]
jonathan		69bf0b73-65ae-4ec0-b457-1ad9a9ab7c3f	2025/06/13 23:27:02	2025/06/13 23:27:02	2025/06/13 23:27:02	30 ms	363 ms	SHOW TABLES IN `c3ba675f1fb64660ba4a90155b35924e`	CLOSED	== Parsed Logical Plan == +details == Parsed Logical Plan == 'ShowTables [namespace#3728, tableName#3729, isTemporary#3730] +- 'UnresolvedNamespace [c3ba675f1fb64660ba4a90155b35924e] == Analyzed Logical Plan == namespace: string, tableName: string, isTemporary: boolean ShowTables [namespace#3728, tableName#3729, isTemporary#3730] +- ResolvedNamespace V2SessionCatalog(spark_catalog), [c3ba675f1fb64660ba4a90155b35924e] == Optimized Logical Plan == CommandResult [namespace#3728, tableName#3729, isTemporary#3730], ShowTables [namespace#3728, tableName#3729, isTemporary#3730], V2SessionCatalog(spark_catalog), [c3ba675f1fb64660ba4a90155b35924e], [[0,2000000020,400000000c,0,6635373661623363,3036363436626631,3531303961346162,6534323935336235,69746e656469796d,72656966]] +- ShowTables [namespace#3728, tableName#3729, isTemporary#3730] +- ResolvedNamespace V2SessionCatalog(spark_catalog), [c3ba675f1fb64660ba4a90155b35924e] == Physical Plan == CommandResult [namespace#3728, tableName#3729, isTemporary#3730] +- ShowTables [namespace#3728, tableName#3729, isTemporary#3730], V2SessionCatalog(spark_catalog), [c3ba675f1fb64660ba4a90155b35924e]
jonathan		2fe876c5-3a65-4db2-bf8a-7b713edf57cc	2025/06/13 23:27:00	2025/06/13 23:27:00	2025/06/13 23:27:00	55 ms	322 ms	DESCRIBE TABLE `default`.`alltypes`	CLOSED	== Parsed Logical Plan == +details == Parsed Logical Plan == 'DescribeRelation false, [col_name#3701, data_type#3702, comment#3703] +- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true == Analyzed Logical Plan == col_name: string, data_type: string, comment: string DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3701, data_type#3702, comment#3703] == Optimized Logical Plan == CommandResult [col_name#3701, data_type#3702, comment#3703], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]] +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3701, data_type#3702, comment#3703] == Physical Plan == CommandResult [col_name#3701, data_type#3702, comment#3703] +- Execute DescribeTableCommand +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3701, data_type#3702, comment#3703]
jonathan		9589ebd7-ed14-4a9d-a173-a591f1db0105	2025/06/13 23:27:00	2025/06/13 23:27:00	2025/06/13 23:27:00	62 ms	333 ms	DESCRIBE TABLE `default`.`alltypes`	CLOSED	== Parsed Logical Plan == +details == Parsed Logical Plan == 'DescribeRelation false, [col_name#3674, data_type#3675, comment#3676] +- 'UnresolvedTableOrView [default, alltypes], DESCRIBE TABLE, true == Analyzed Logical Plan == col_name: string, data_type: string, comment: string DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3674, data_type#3675, comment#3676] == Optimized Logical Plan == CommandResult [col_name#3674, data_type#3675, comment#3676], Execute DescribeTableCommand, [[STRING,string,null], [DOUBLE,double,null], [INTEGER,int,null], [BIGINT,bigint,null], [FLOAT,float,null], [DECIMAL,decimal(10,2),null], [NUMBER,decimal(10,2),null], [BOOLEAN,boolean,null], [DATE,date,null], [TIMESTAMP,timestamp,null], [DATETIME,timestamp,null], [BINARY,binary,null], [ARRAY,array<int>,null], [MAP,map<string,string>,null], [STRUCT,struct<field1:string,field2:int>,null], [VARCHAR,string,null], [CHAR,string,null]] +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3674, data_type#3675, comment#3676] == Physical Plan == CommandResult [col_name#3674, data_type#3675, comment#3676] +- Execute DescribeTableCommand +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3674, data_type#3675, comment#3676]

Page:

1