[jira] [Updated] (AMBARI-22090) INCORROUT in Hive SELECT-JOIN query using Hive View 2.0

["Pallav Kulshreshtha (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/AMBARI-22090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pallav Kulshreshtha updated AMBARI-22090:
-----------------------------------------
    Attachment: AMBARI-22090_branch-trunk.patch

> 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)