yiqijiu commented on code in PR #5556:
URL: https://github.com/apache/hive/pull/5556#discussion_r1874713810
##########
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:
> You can sign in Jenkins with your GitHub account, and you can see the
result of CI. I will also document it. It is just a regulation of not Hive but
POSIX to end a file with \n. Thanks for tweaking it
Thank you, I think I understand now. There are still some minor formatting
issues. I will run it again. I'm not sure if it's because of my local
computer's performance, but each test run takes more than 20 minutes.
--
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]
