ghanko commented on code in PR #3592:
URL: https://github.com/apache/hive/pull/3592#discussion_r973558878
##########
ql/src/test/queries/clientpositive/vector_struct_in2.q:
##########
@@ -0,0 +1,22 @@
+set hive.fetch.task.conversion=none;
+
+create table test (a string) partitioned by (y string, m string);
+insert into test values ('aa', 2022, 9);
+
+--original bug report
+select * from test where (y=year(date_sub('2022-09-11',4)) and
m=month(date_sub('2022-09-11',4))) or (y=year(date_sub('2022-09-11',10)) and
m=month(date_sub('2022-09-11',10)) );
+
+set hive.optimize.point.lookup=false;
Review Comment:
The original repro case is a complex one so I wanted to break down the issue
to simpler test cases.
The original case runs with point lookup optimization set to true, but it
has to be switched off later for the simpler cases because it would optimize
the problematic parts of the queries away before the vectorization happens.
I was thinking about creating multiple query files for the different
scenarios but I decided not to do so to avoid the overhead of distinct test
runs.
--
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]
