You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ambari.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2017/10/04 19:40:00 UTC
[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&focusedCommentId=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&a=commit&h=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: 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)