Thrift JDBC/ODBC Server - JDBC/ODBC Session

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

User jonathan, IP 205.250.61.41, Session created at 2025/06/13 23:21:31, Total run 3 SQL

SQL Statistics

Page:

User	JobID	GroupID	Start Time ▾	Finish Time	Close Time	Execution Time	Duration	Statement	State	Detail
jonathan	[39]	8999cf5e-c88b-4980-aa38-13e2c37d95c1	2025/06/13 23:21:33	2025/06/13 23:21:33	2025/06/13 23:21:33	130 ms	539 ms	select `STRING`, `DOUBLE`, `INTEGER`, `BIGINT`, `FLOAT`, `DECIMAL`, `NUMBER`, `BOOLEAN`, `DATE`, `TIMESTAMP`, `DATETIME`, `BINARY`, `ARRAY`, `MAP`, `STRUCT`, `VARCHAR`, `CHAR` from `default`.`alltypes` limit 1000	CLOSED	== Parsed Logical Plan == +details == Parsed Logical Plan == 'GlobalLimit 1000 +- 'LocalLimit 1000 +- 'Project ['STRING, 'DOUBLE, 'INTEGER, 'BIGINT, 'FLOAT, 'DECIMAL, 'NUMBER, 'BOOLEAN, 'DATE, 'TIMESTAMP, 'DATETIME, 'BINARY, 'ARRAY, 'MAP, 'STRUCT, 'VARCHAR, 'CHAR] +- 'UnresolvedRelation [default, alltypes], [], false == Analyzed Logical Plan == STRING: string, DOUBLE: double, INTEGER: int, BIGINT: bigint, FLOAT: float, DECIMAL: decimal(10,2), NUMBER: decimal(10,2), BOOLEAN: boolean, DATE: date, TIMESTAMP: timestamp, DATETIME: timestamp, BINARY: binary, ARRAY: array<int>, MAP: map<string,string>, STRUCT: struct<field1:string,field2:int>, VARCHAR: string, CHAR: string GlobalLimit 1000 +- LocalLimit 1000 +- Project [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOOLEAN#3521, DATE#3522, TIMESTAMP#3523, DATETIME#3524, BINARY#3525, ARRAY#3526, MAP#3527, STRUCT#3528, VARCHAR#3529, CHAR#3530] +- SubqueryAlias spark_catalog.default.alltypes +- HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOO..., Partition Cols: []] == Optimized Logical Plan == GlobalLimit 1000 +- LocalLimit 1000 +- HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOO..., Partition Cols: []] == Physical Plan == CollectLimit 1000 +- Scan hive spark_catalog.default.alltypes [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOOLEAN#3521, DATE#3522, TIMESTAMP#3523, DATETIME#3524, BINARY#3525, ARRAY#3526, MAP#3527, STRUCT#3528, VARCHAR#3529, CHAR#3530], HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOO..., Partition Cols: []]
jonathan		51708b4c-da4e-4cdc-96e6-ebf36f4d8c54	2025/06/13 23:21:32	2025/06/13 23:21:33	2025/06/13 23:21:33	67 ms	346 ms	DESCRIBE TABLE `default`.`alltypes`	CLOSED	== Parsed Logical Plan == +details == Parsed Logical Plan == 'DescribeRelation false, [col_name#3487, data_type#3488, comment#3489] +- '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#3487, data_type#3488, comment#3489] == Optimized Logical Plan == CommandResult [col_name#3487, data_type#3488, comment#3489], 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#3487, data_type#3488, comment#3489] == Physical Plan == CommandResult [col_name#3487, data_type#3488, comment#3489] +- Execute DescribeTableCommand +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3487, data_type#3488, comment#3489]
jonathan		a052b843-5569-402b-89ab-e5d7cdbba6db	2025/06/13 23:21:32	2025/06/13 23:21:32	2025/06/13 23:21:32	94 ms	657 ms	DESCRIBE TABLE `default`.`alltypes`	CLOSED	== Parsed Logical Plan == +details == Parsed Logical Plan == 'DescribeRelation false, [col_name#3460, data_type#3461, comment#3462] +- '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#3460, data_type#3461, comment#3462] == Optimized Logical Plan == CommandResult [col_name#3460, data_type#3461, comment#3462], 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#3460, data_type#3461, comment#3462] == Physical Plan == CommandResult [col_name#3460, data_type#3461, comment#3462] +- Execute DescribeTableCommand +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3460, data_type#3461, comment#3462]

User

JobID

GroupID

Start Time ▾

Finish Time

Close Time

Execution Time

Duration

Statement

State

Detail

jonathan

[39]

8999cf5e-c88b-4980-aa38-13e2c37d95c1

2025/06/13 23:21:33

130 ms

539 ms

select `STRING`, `DOUBLE`, `INTEGER`, `BIGINT`, `FLOAT`, `DECIMAL`, `NUMBER`, `BOOLEAN`, `DATE`, `TIMESTAMP`, `DATETIME`, `BINARY`, `ARRAY`, `MAP`, `STRUCT`, `VARCHAR`, `CHAR` from `default`.`alltypes` limit 1000

CLOSED

== Parsed Logical Plan == +details

== Parsed Logical Plan ==
'GlobalLimit 1000
+- 'LocalLimit 1000
   +- 'Project ['STRING, 'DOUBLE, 'INTEGER, 'BIGINT, 'FLOAT, 'DECIMAL, 'NUMBER, 'BOOLEAN, 'DATE, 'TIMESTAMP, 'DATETIME, 'BINARY, 'ARRAY, 'MAP, 'STRUCT, 'VARCHAR, 'CHAR]
      +- 'UnresolvedRelation [default, alltypes], [], false

== Analyzed Logical Plan ==
STRING: string, DOUBLE: double, INTEGER: int, BIGINT: bigint, FLOAT: float, DECIMAL: decimal(10,2), NUMBER: decimal(10,2), BOOLEAN: boolean, DATE: date, TIMESTAMP: timestamp, DATETIME: timestamp, BINARY: binary, ARRAY: array<int>, MAP: map<string,string>, STRUCT: struct<field1:string,field2:int>, VARCHAR: string, CHAR: string
GlobalLimit 1000
+- LocalLimit 1000
   +- Project [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOOLEAN#3521, DATE#3522, TIMESTAMP#3523, DATETIME#3524, BINARY#3525, ARRAY#3526, MAP#3527, STRUCT#3528, VARCHAR#3529, CHAR#3530]
      +- SubqueryAlias spark_catalog.default.alltypes
         +- HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOO..., Partition Cols: []]

== Optimized Logical Plan ==
GlobalLimit 1000
+- LocalLimit 1000
   +- HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOO..., Partition Cols: []]

== Physical Plan ==
CollectLimit 1000
+- Scan hive spark_catalog.default.alltypes [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOOLEAN#3521, DATE#3522, TIMESTAMP#3523, DATETIME#3524, BINARY#3525, ARRAY#3526, MAP#3527, STRUCT#3528, VARCHAR#3529, CHAR#3530], HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#3514, DOUBLE#3515, INTEGER#3516, BIGINT#3517L, FLOAT#3518, DECIMAL#3519, NUMBER#3520, BOO..., Partition Cols: []]

jonathan

51708b4c-da4e-4cdc-96e6-ebf36f4d8c54

2025/06/13 23:21:32

2025/06/13 23:21:33

67 ms

346 ms

DESCRIBE TABLE `default`.`alltypes`

CLOSED

== Parsed Logical Plan == +details

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3487, data_type#3488, comment#3489]
+- '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#3487, data_type#3488, comment#3489]

== Optimized Logical Plan ==
CommandResult [col_name#3487, data_type#3488, comment#3489], 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#3487, data_type#3488, comment#3489]

== Physical Plan ==
CommandResult [col_name#3487, data_type#3488, comment#3489]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3487, data_type#3488, comment#3489]

jonathan

a052b843-5569-402b-89ab-e5d7cdbba6db

2025/06/13 23:21:32

94 ms

657 ms

DESCRIBE TABLE `default`.`alltypes`

CLOSED

== Parsed Logical Plan == +details

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3460, data_type#3461, comment#3462]
+- '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#3460, data_type#3461, comment#3462]

== Optimized Logical Plan ==
CommandResult [col_name#3460, data_type#3461, comment#3462], 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#3460, data_type#3461, comment#3462]

== Physical Plan ==
CommandResult [col_name#3460, data_type#3461, comment#3462]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3460, data_type#3461, comment#3462]

Page: