[
https://issues.apache.org/jira/browse/HIVE-25848?focusedWorklogId=809730&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-809730
]
ASF GitHub Bot logged work on HIVE-25848:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 17/Sep/22 07:33
Start Date: 17/Sep/22 07:33
Worklog Time Spent: 10m
Work Description: asolimando commented on code in PR #3592:
URL: https://github.com/apache/hive/pull/3592#discussion_r973553929
##########
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;
+set hive.cbo.enable=false;
+
+--embedded expression in struct
+select * from test where (struct(cast(y as int)) IN (struct(2022)));
+
+--first argument of in expression is const struct
+select * from test where (struct(2022) IN (struct(2022)));
+
+set hive.optimize.constant.propagation=false;
Review Comment:
Can you elaborate on why we need to turn off those properties here? It's
probably a good idea to add a comment around that in the qtest itself.
Issue Time Tracking
-------------------
Worklog Id: (was: 809730)
Time Spent: 50m (was: 40m)
> Empty result for structs in point lookup optimization with vectorization on
> ---------------------------------------------------------------------------
>
> Key: HIVE-25848
> URL: https://issues.apache.org/jira/browse/HIVE-25848
> Project: Hive
> Issue Type: Bug
> Reporter: Ádám Szita
> Priority: Major
> Labels: pull-request-available
> Time Spent: 50m
> Remaining Estimate: 0h
>
> Repro steps:
> {code:java}
> set hive.fetch.task.conversion=none;
> create table test (a string) partitioned by (y string, m string);
> insert into test values ('aa', 2022, 1);
> select * from test where (y=year(date_sub(current_date,4)) and
> m=month(date_sub(current_date,4))) or (y=year(date_sub(current_date,10)) and
> m=month(date_sub(current_date,10)) );
> --gives empty result{code}
> Turning either of the feature below off yields to good result (1 row
> expected):
> {code:java}
> set hive.optimize.point.lookup=false;
> set hive.cbo.enable=false;
> set hive.vectorized.execution.enabled=false;
> {code}
> Expected good result is:
> {code}
> +---------+---------+---------+
> | test.a | test.y | test.m |
> +---------+---------+---------+
> | aa | 2022 | 1 |
> +---------+---------+---------+ {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
