Thrift JDBC/ODBC Server - JDBC/ODBC Session

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

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

SQL Statistics

Page:

User	JobID	GroupID	Start Time ▾	Finish Time	Close Time	Execution Time	Duration	Statement	State	Detail
jonathan	[41]	8dfd850b-e621-4e50-a84a-47507293ee16	2025/06/13 23:34:48	2025/06/13 23:34:48	2025/06/13 23:34:49	110 ms	507 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#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, BOOLEAN#4013, DATE#4014, TIMESTAMP#4015, DATETIME#4016, BINARY#4017, ARRAY#4018, MAP#4019, STRUCT#4020, VARCHAR#4021, CHAR#4022] +- SubqueryAlias spark_catalog.default.alltypes +- HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, 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#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, BOO..., Partition Cols: []] == Physical Plan == CollectLimit 1000 +- Scan hive spark_catalog.default.alltypes [STRING#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, BOOLEAN#4013, DATE#4014, TIMESTAMP#4015, DATETIME#4016, BINARY#4017, ARRAY#4018, MAP#4019, STRUCT#4020, VARCHAR#4021, CHAR#4022], HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, BOO..., Partition Cols: []]
jonathan		94b17ac6-9bb4-4db3-8a74-8665ab43bdde	2025/06/13 23:34:48	2025/06/13 23:34:48	2025/06/13 23:34:48	55 ms	325 ms	DESCRIBE TABLE `default`.`alltypes`	CLOSED	== Parsed Logical Plan == +details == Parsed Logical Plan == 'DescribeRelation false, [col_name#3979, data_type#3980, comment#3981] +- '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#3979, data_type#3980, comment#3981] == Optimized Logical Plan == CommandResult [col_name#3979, data_type#3980, comment#3981], 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#3979, data_type#3980, comment#3981] == Physical Plan == CommandResult [col_name#3979, data_type#3980, comment#3981] +- Execute DescribeTableCommand +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3979, data_type#3980, comment#3981]
jonathan		bce964e2-7852-4f5d-a13d-f4db03b76edc	2025/06/13 23:34:47	2025/06/13 23:34:47	2025/06/13 23:34:48	65 ms	617 ms	DESCRIBE TABLE `default`.`alltypes`	CLOSED	== Parsed Logical Plan == +details == Parsed Logical Plan == 'DescribeRelation false, [col_name#3952, data_type#3953, comment#3954] +- '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#3952, data_type#3953, comment#3954] == Optimized Logical Plan == CommandResult [col_name#3952, data_type#3953, comment#3954], 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#3952, data_type#3953, comment#3954] == Physical Plan == CommandResult [col_name#3952, data_type#3953, comment#3954] +- Execute DescribeTableCommand +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3952, data_type#3953, comment#3954]

User

JobID

GroupID

Start Time ▾

Finish Time

Close Time

Execution Time

Duration

Statement

State

Detail

jonathan

[41]

8dfd850b-e621-4e50-a84a-47507293ee16

2025/06/13 23:34:48

2025/06/13 23:34:49

110 ms

507 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#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, BOOLEAN#4013, DATE#4014, TIMESTAMP#4015, DATETIME#4016, BINARY#4017, ARRAY#4018, MAP#4019, STRUCT#4020, VARCHAR#4021, CHAR#4022]
      +- SubqueryAlias spark_catalog.default.alltypes
         +- HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, 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#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, BOO..., Partition Cols: []]

== Physical Plan ==
CollectLimit 1000
+- Scan hive spark_catalog.default.alltypes [STRING#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, BOOLEAN#4013, DATE#4014, TIMESTAMP#4015, DATETIME#4016, BINARY#4017, ARRAY#4018, MAP#4019, STRUCT#4020, VARCHAR#4021, CHAR#4022], HiveTableRelation [`spark_catalog`.`default`.`alltypes`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [STRING#4006, DOUBLE#4007, INTEGER#4008, BIGINT#4009L, FLOAT#4010, DECIMAL#4011, NUMBER#4012, BOO..., Partition Cols: []]

jonathan

94b17ac6-9bb4-4db3-8a74-8665ab43bdde

2025/06/13 23:34:48

55 ms

325 ms

DESCRIBE TABLE `default`.`alltypes`

CLOSED

== Parsed Logical Plan == +details

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3979, data_type#3980, comment#3981]
+- '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#3979, data_type#3980, comment#3981]

== Optimized Logical Plan ==
CommandResult [col_name#3979, data_type#3980, comment#3981], 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#3979, data_type#3980, comment#3981]

== Physical Plan ==
CommandResult [col_name#3979, data_type#3980, comment#3981]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3979, data_type#3980, comment#3981]

jonathan

bce964e2-7852-4f5d-a13d-f4db03b76edc

2025/06/13 23:34:47

2025/06/13 23:34:48

65 ms

617 ms

DESCRIBE TABLE `default`.`alltypes`

CLOSED

== Parsed Logical Plan == +details

== Parsed Logical Plan ==
'DescribeRelation false, [col_name#3952, data_type#3953, comment#3954]
+- '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#3952, data_type#3953, comment#3954]

== Optimized Logical Plan ==
CommandResult [col_name#3952, data_type#3953, comment#3954], 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#3952, data_type#3953, comment#3954]

== Physical Plan ==
CommandResult [col_name#3952, data_type#3953, comment#3954]
   +- Execute DescribeTableCommand
         +- DescribeTableCommand `spark_catalog`.`default`.`alltypes`, false, [col_name#3952, data_type#3953, comment#3954]

Page: