[jira] [Updated] (HIVE-27878) Implement query summary for HS2-only queries

2023-11-16 Thread Jira 


 [ 
https://issues.apache.org/jira/browse/HIVE-27878?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

László Bodor updated HIVE-27878:

Description: 
While running a cluster query (hs2, tez am, tez+llap), we have a handy summary 
attached as:  [^tpcds78_10GB_query_summary_example.txt] 
However, we get no info about simply fetch tasks, we can see only this below:
{code}
0: jdbc:hive2://hs2-lbodor-aws-bug.dw-dw-team> select * from customer limit 10;
INFO  : Compiling 
command(queryId=hive_20231116094515_5f3e5f7b-da6a-4026-9b36-be63ee11ff61): 
select * from customer limit 10
INFO  : Semantic Analysis Completed (retrial = false)
INFO  : Created Hive schema: 
Schema(fieldSchemas:[FieldSchema(name:customer.c_customer_sk, type:bigint, 
comment:null), FieldSchema(name:customer.c_customer_id, type:char(16), 
comment:null), FieldSchema(name:customer.c_current_cdemo_sk, type:bigint, 
comment:null), FieldSchema(name:customer.c_current_hdemo_sk, type:bigint, 
comment:null), FieldSchema(name:customer.c_current_addr_sk, type:bigint, 
comment:null), FieldSchema(name:customer.c_first_shipto_date_sk, type:bigint, 
comment:null), FieldSchema(name:customer.c_first_sales_date_sk, type:bigint, 
comment:null), FieldSchema(name:customer.c_salutation, type:char(10), 
comment:null), FieldSchema(name:customer.c_first_name, type:char(20), 
comment:null), FieldSchema(name:customer.c_last_name, type:char(30), 
comment:null), FieldSchema(name:customer.c_preferred_cust_flag, type:char(1), 
comment:null), FieldSchema(name:customer.c_birth_day, type:int, comment:null), 
FieldSchema(name:customer.c_birth_month, type:int, comment:null), 
FieldSchema(name:customer.c_birth_year, type:int, comment:null), 
FieldSchema(name:customer.c_birth_country, type:varchar(20), comment:null), 
FieldSchema(name:customer.c_login, type:char(13), comment:null), 
FieldSchema(name:customer.c_email_address, type:char(50), comment:null), 
FieldSchema(name:customer.c_last_review_date_sk, type:bigint, comment:null)], 
properties:null)
INFO  : Completed compiling 
command(queryId=hive_20231116094515_5f3e5f7b-da6a-4026-9b36-be63ee11ff61); Time 
taken: 0.257 seconds
INFO  : Executing 
command(queryId=hive_20231116094515_5f3e5f7b-da6a-4026-9b36-be63ee11ff61): 
select * from customer limit 10
INFO  : Completed executing 
command(queryId=hive_20231116094515_5f3e5f7b-da6a-4026-9b36-be63ee11ff61); Time 
taken: 0.007 seconds
INFO  : OK
+-+-+--+--+-+--+-+++-+-+---+-++---+---++-+
| customer.c_customer_sk  | customer.c_customer_id  | 
customer.c_current_cdemo_sk  | customer.c_current_hdemo_sk  | 
customer.c_current_addr_sk  | customer.c_first_shipto_date_sk  | 
customer.c_first_sales_date_sk  | customer.c_salutation  | 
customer.c_first_name  |  customer.c_last_name   | 
customer.c_preferred_cust_flag  | customer.c_birth_day  | 
customer.c_birth_month  | customer.c_birth_year  | customer.c_birth_country  | 
customer.c_login  |  customer.c_email_address  | 
customer.c_last_review_date_sk  |
+-+-+--+--+-+--+-+++-+-+---+-++---+---++-+
| 1   | BAAA| 980124
   | 7135 | 32946   | 2452238   
   | 2452208 | Mr.| 
Javier | Lewis   | Y
   | 9 | 12  | 1936 
  | CHILE | NULL  | 
javier.le...@vfaxlnzevox.org   | 2452508
 |
| 2   | CAAA| 819667
   | 1461 | 181655  | 2452318   
   | 2452288 | Dr.| 
Amy| Moses   | Y
   | 9

[jira] [Updated] (HIVE-27878) Implement query summary for HS2-only queries

2023-11-16 Thread Jira 


 [ 
https://issues.apache.org/jira/browse/HIVE-27878?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

László Bodor updated HIVE-27878:

Description: 
While running a cluster query (hs2, tez am, tez+llap), we have a handy summary 
attached as:  [^tpcds78_10GB_query_summary_example.txt] 
However, we get no info about simply fetch tasks, we can see only this below:
{code}
0: jdbc:hive2://hs2-lbodor-aws-bug.dw-dw-team> select * from customer limit 10;
INFO  : Compiling 
command(queryId=hive_20231116094515_5f3e5f7b-da6a-4026-9b36-be63ee11ff61): 
select * from customer limit 10
INFO  : Semantic Analysis Completed (retrial = false)
INFO  : Created Hive schema: 
Schema(fieldSchemas:[FieldSchema(name:customer.c_customer_sk, type:bigint, 
comment:null), FieldSchema(name:customer.c_customer_id, type:char(16), 
comment:null), FieldSchema(name:customer.c_current_cdemo_sk, type:bigint, 
comment:null), FieldSchema(name:customer.c_current_hdemo_sk, type:bigint, 
comment:null), FieldSchema(name:customer.c_current_addr_sk, type:bigint, 
comment:null), FieldSchema(name:customer.c_first_shipto_date_sk, type:bigint, 
comment:null), FieldSchema(name:customer.c_first_sales_date_sk, type:bigint, 
comment:null), FieldSchema(name:customer.c_salutation, type:char(10), 
comment:null), FieldSchema(name:customer.c_first_name, type:char(20), 
comment:null), FieldSchema(name:customer.c_last_name, type:char(30), 
comment:null), FieldSchema(name:customer.c_preferred_cust_flag, type:char(1), 
comment:null), FieldSchema(name:customer.c_birth_day, type:int, comment:null), 
FieldSchema(name:customer.c_birth_month, type:int, comment:null), 
FieldSchema(name:customer.c_birth_year, type:int, comment:null), 
FieldSchema(name:customer.c_birth_country, type:varchar(20), comment:null), 
FieldSchema(name:customer.c_login, type:char(13), comment:null), 
FieldSchema(name:customer.c_email_address, type:char(50), comment:null), 
FieldSchema(name:customer.c_last_review_date_sk, type:bigint, comment:null)], 
properties:null)
INFO  : Completed compiling 
command(queryId=hive_20231116094515_5f3e5f7b-da6a-4026-9b36-be63ee11ff61); Time 
taken: 0.257 seconds
INFO  : Executing 
command(queryId=hive_20231116094515_5f3e5f7b-da6a-4026-9b36-be63ee11ff61): 
select * from customer limit 10
INFO  : Completed executing 
command(queryId=hive_20231116094515_5f3e5f7b-da6a-4026-9b36-be63ee11ff61); Time 
taken: 0.007 seconds
INFO  : OK
+-+-+--+--+-+--+-+++-+-+---+-++---+---++-+
| customer.c_customer_sk  | customer.c_customer_id  | 
customer.c_current_cdemo_sk  | customer.c_current_hdemo_sk  | 
customer.c_current_addr_sk  | customer.c_first_shipto_date_sk  | 
customer.c_first_sales_date_sk  | customer.c_salutation  | 
customer.c_first_name  |  customer.c_last_name   | 
customer.c_preferred_cust_flag  | customer.c_birth_day  | 
customer.c_birth_month  | customer.c_birth_year  | customer.c_birth_country  | 
customer.c_login  |  customer.c_email_address  | 
customer.c_last_review_date_sk  |
+-+-+--+--+-+--+-+++-+-+---+-++---+---++-+
| 1   | BAAA| 980124
   | 7135 | 32946   | 2452238   
   | 2452208 | Mr.| 
Javier | Lewis   | Y
   | 9 | 12  | 1936 
  | CHILE | NULL  | 
javier.le...@vfaxlnzevox.org   | 2452508
 |
| 2   | CAAA| 819667
   | 1461 | 181655  | 2452318   
   | 2452288 | Dr.| 
Amy| Moses   | Y
   | 9

[jira] [Updated] (HIVE-27878) Implement query summary for HS2-only queries

2023-11-16 Thread Jira 


 [ 
https://issues.apache.org/jira/browse/HIVE-27878?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

László Bodor updated HIVE-27878:

Description: While running a cluster query (hs2, tez am, tez+llap), we have 
a handy summary attached as:  [^tpcds78_10GB_query_summary_example.txt] 

> Implement query summary for HS2-only queries
> 
>
> Key: HIVE-27878
> URL: https://issues.apache.org/jira/browse/HIVE-27878
> Project: Hive
>  Issue Type: Improvement
>Reporter: László Bodor
>Priority: Major
> Attachments: tpcds78_10GB_query_summary_example.txt
>
>
> While running a cluster query (hs2, tez am, tez+llap), we have a handy 
> summary attached as:  [^tpcds78_10GB_query_summary_example.txt] 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (HIVE-27878) Implement query summary for HS2-only queries

2023-11-16 Thread Jira 


 [ 
https://issues.apache.org/jira/browse/HIVE-27878?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

László Bodor updated HIVE-27878:

Attachment: tpcds78_10GB_query_summary_example.txt

> Implement query summary for HS2-only queries
> 
>
> Key: HIVE-27878
> URL: https://issues.apache.org/jira/browse/HIVE-27878
> Project: Hive
>  Issue Type: Improvement
>Reporter: László Bodor
>Priority: Major
> Attachments: tpcds78_10GB_query_summary_example.txt
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)