yiqijiu commented on code in PR #5556:
URL: https://github.com/apache/hive/pull/5556#discussion_r1874949637
##########
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:
I think I have identified the cause of the issue. It was due to a problem
with my local environment. I should first run:
mvn clean install -DskipTests
at the root directory, then go to the itests directory and run:
cd itests
mvn clean install -DskipTests
Finally, I should execute:
mvn test -Dtest=TestMiniLlapLocalCliDriver
-Dqfile=explain_multiple_ptf_on_big_table.q -Dtest.output.overwrite=true
instead of directly running the test after making code changes. Skipping the
build steps caused the explain_multiple_ptf_on_big_table.q.out file to remain
the old version rather than being updated to reflect the latest changes.
--
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]
