[jira] [Commented] (AMBARI-22090) INCORROUT in Hive SELECT-JOIN query using Hive View 2.0
[ https://issues.apache.org/jira/browse/AMBARI-22090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16191925#comment-16191925 ] Hudson commented on AMBARI-22090: - SUCCESS: Integrated in Jenkins build Ambari-branch-2.6 #331 (See [https://builds.apache.org/job/Ambari-branch-2.6/331/]) 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=commit=ed1f9520cbb0ffb47ed69fb3fb92e5322a798fd2]) * (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: 1value1_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)
[jira] [Commented] (AMBARI-22090) INCORROUT in Hive SELECT-JOIN query using Hive View 2.0
[ https://issues.apache.org/jira/browse/AMBARI-22090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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=commit=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: 1value1_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)
[jira] [Commented] (AMBARI-22090) INCORROUT in Hive SELECT-JOIN query using Hive View 2.0
[ https://issues.apache.org/jira/browse/AMBARI-22090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16184869#comment-16184869 ] Hadoop QA commented on AMBARI-22090: {color:red}-1 overall{color}. Here are the results of testing the latest attachment http://issues.apache.org/jira/secure/attachment/12889569/AMBARI-22090_branch-trunk.patch against trunk revision . {color:green}+1 @author{color}. The patch does not contain any @author tags. {color:red}-1 tests included{color}. The patch doesn't appear to include any new or modified tests. Please justify why no new tests are needed for this patch. Also please list what manual steps were performed to verify this patch. {color:green}+1 release audit{color}. The applied patch does not increase the total number of release audit warnings. {color:green}+1 javac{color}. The applied patch does not increase the total number of javac compiler warnings. {color:red}-1 core tests{color}. The test build failed in [contrib/views/hive20|https://builds.apache.org/job/Ambari-trunk-test-patch/12379//artifact/patch-work/testrun_hive20.txt] Console output: https://builds.apache.org/job/Ambari-trunk-test-patch/12379//console This message is automatically generated. > 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: 1value1_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)