[
https://issues.apache.org/jira/browse/AMBARI-22090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pallav Kulshreshtha updated AMBARI-22090:
-----------------------------------------
Resolution: Fixed
Status: Resolved (was: Patch Available)
code committed to trunk.
> INCORROUT in Hive SELECT-JOIN query using Hive View 2.0
> -------------------------------------------------------
>
> Key: AMBARI-22090
> URL: https://issues.apache.org/jira/browse/AMBARI-22090
> Project: Ambari
> Issue Type: Bug
> Components: ambari-views
> Reporter: Pallav Kulshreshtha
> Assignee: Pallav Kulshreshtha
> Priority: Critical
> Fix For: 2.6.0
>
> Attachments: AMBARI-22090_branch-trunk.patch
>
>
> TESTCASE:
> DROP TABLE IF EXISTS mydim;
> DROP TABLE IF EXISTS staging;
> CREATE TABLE mydim (
> key int,
> value string,
> status string)
> PARTITIONED BY (last_updated timestamp)
> CLUSTERED BY (key) INTO 5 BUCKETS
> STORED AS ORC TBLPROPERTIES ('transactional'='true');
> INSERT INTO mydim PARTITION(last_updated) VALUES
> (1, 'value1', 'original value', '2017-01-01'),
> (2, 'value2', 'original value', '2017-01-01'),
> (3, 'value3', 'original value', '2017-01-01'),
> (4, 'value4', 'original value', '2017-01-01'),
> (5, 'value5', 'original value', '2017-01-01');
> CREATE TABLE staging(
> key int,
> value string)
> STORED AS ORC;
> INSERT INTO staging VALUES
> (0, 'value0'),
> (1, 'value1_new');
> – INCORROUT: 1 value1_new original value 2017-01-01 00:00:00.0
> 1 value1_new
> – EXPECTED: 1 value1 original value 2017-01-01 00:00:00.0 1
> value1_new
> SELECT *
> FROM mydim,staging
> WHERE mydim.key = staging.key;
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
