[GitHub] [hive] ghanko commented on a diff in pull request #3592: HIVE-25848 Empty result for structs in point lookup optimization with…

[GitBox <gi...@apache.org>]

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: gitbox-unsubscribe@hive.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org