[ https://issues.apache.org/jira/browse/AMBARI-22090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16186031#comment-16186031 ]
Hudson commented on AMBARI-22090: --------------------------------- FAILURE: Integrated in Jenkins build Ambari-trunk-Commit #8170 (See [https://builds.apache.org/job/Ambari-trunk-Commit/8170/]) AMBARI-22090. INCORROUT in Hive SELECT-JOIN query using Hive View 2.0 (pallavkul: [http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=045fc072588632429bc53f6b6a1ee0e0a83179d0]) * (edit) contrib/views/hive20/src/main/resources/ui/app/components/query-result-table.js > 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)