yiqijiu commented on code in PR #5556:
URL: https://github.com/apache/hive/pull/5556#discussion_r1875391598
##########
ql/src/test/queries/clientpositive/explain_big_table_multiple_ptf.q:
##########
@@ -0,0 +1,31 @@
+create table explain_multiple_ptf_big_table
+(
+ key1 string,
+ value_str1 string,
+ key3 string
+);
+create table explain_multiple_ptf_big_table2
+(
+ key21 string,
+ value_str21 string,
+ key23 string
+);
+alter table explain_multiple_ptf_big_table
+ update statistics set('numRows' = '4611686036854775807',
+ 'rawDataSize' = '922337203685477500');
+alter table explain_multiple_ptf_big_table2
+ update statistics set('numRows' = '4611686036854775807',
+ 'rawDataSize' = '9223372036854775800');
+explain
+select *,row_number() over (partition by key order by key2 desc) rn,
+ row_number() over (partition by key2 order by key desc) rn2,
+ max(value_str) over (partition by key2 order by key desc) max1,
+ max(value_str) over (partition by key order by key2 desc) max3,
+ min(value_str) over (partition by key2 order by key desc) min1,
+ min(value_str) over (partition by key order by key2 desc) min3,
+ last_value(value_str) over (partition by key) lv,
+ first_value(value_str) over (partition by key2) fv,
+ max(value_str) over (partition by key) fv21
+from (select key1 key, value_str1 value_str, key3 key2 from
explain_multiple_ptf_big_table
+union all select key21 key, value_str21 value_str, key23 key2 from
explain_multiple_ptf_big_table2) a1
+;
Review Comment:
Thank you for providing the information. I will follow these steps and test
it tonight.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
