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

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

Pallav Kulshreshtha created AMBARI-22090:
--------------------------------------------

             Summary: 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


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)