You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Vineet Garg (Jira)" <ji...@apache.org> on 2020/07/06 19:41:00 UTC
[jira] [Assigned] (HIVE-23807) Wrong results with vectorization
enabled
[ https://issues.apache.org/jira/browse/HIVE-23807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vineet Garg reassigned HIVE-23807:
----------------------------------
> 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
>
> *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;
> set hive.vectorized.execution.enabled=true;
> select Cast(`test13`.`price_cut_off_datetime` AS date) from test13;
> {code:sql}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)