[
https://issues.apache.org/jira/browse/HIVE-23807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17157135#comment-17157135
]
Jesus Camacho Rodriguez commented on HIVE-23807:
------------------------------------------------
+1
> Wrong results with vectorization enabled
> ----------------------------------------
>
> Key: HIVE-23807
> URL: https://issues.apache.org/jira/browse/HIVE-23807
> Project: Hive
> Issue Type: Bug
> Components: Vectorization
> Affects Versions: 2.3.0
> Reporter: Vineet Garg
> Assignee: Vineet Garg
> Priority: Major
> Labels: compatibility, pull-request-available
> Time Spent: 50m
> Remaining Estimate: 0h
>
> *Repro*
> {code:sql}
> CREATE TABLE `test13`(
> `portfolio_valuation_date` string,
> `price_cut_off_datetime` string,
> `portfolio_id_valuation_source` string,
> `contributor_full_path` string,
> `position_market_value` double,
> `mandate_name` string)
> STORED AS ORC;
> INSERT INTO test13 values (
> "2020-01-31", "2020-02-07T03:14:48.007Z", "37", NULL, -0.26, "foo");
> INSERT INTO test13 values (
> "2020-01-31", "2020-02-07T03:14:48.007Z", "37", NULL, 0.33, "foo");
> INSERT INTO test13 values (
> "2020-01-31", "2020-02-07T03:14:48.007Z", "37", NULL, -0.03, "foo");
> INSERT INTO test13 values (
> "2020-01-31", "2020-02-07T03:14:48.007Z", "37", NULL, 0.16, "foo");
> INSERT INTO test13 values (
> "2020-01-31", "2020-02-07T03:14:48.007Z", "37", NULL, 0.08, "foo");
> set hive.fetch.task.conversion=none;
> set hive.explain.user=false;
> set hive.vectorized.execution.enabled=false;
> select Cast(`test13`.`price_cut_off_datetime` AS date) from test13; <--
> produces NULL
> set hive.vectorized.execution.enabled=true;
> select Cast(`test13`.`price_cut_off_datetime` AS date) from test13; <--
> produces non-null values
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
