hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Qiuzhuang Lian (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-14711) HQL in which involves with join between txt and orc tables returns incorrect result
Date Wed, 07 Sep 2016 03:47:20 GMT

    [ https://issues.apache.org/jira/browse/HIVE-14711?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15469429#comment-15469429
] 

Qiuzhuang Lian commented on HIVE-14711:
---------------------------------------

Hi Gopal, both of txt and orc tables are string type for id column.

> HQL in which involves with join between txt and orc tables returns incorrect result
> -----------------------------------------------------------------------------------
>
>                 Key: HIVE-14711
>                 URL: https://issues.apache.org/jira/browse/HIVE-14711
>             Project: Hive
>          Issue Type: Bug
>          Components: ORC, SQL
>    Affects Versions: 1.2.1
>         Environment: Hive 1.2.1 + Hadoop 2.6.2
>            Reporter: Qiuzhuang Lian
>            Assignee: Owen O'Malley
>
> We have the scenario of ORC with ACID joining with TXT table and it can't retrieve that
ID based row which should.
> Here is the HQL:
> select a.id a_id,b.id b_id from txtdb.order a, orcdb.order_cln b where a.id = b.id and
b.id = '8a708a864faf8ef6014fb70426d62a67';
> Table txtdb.order is TXT format and orcdb.order_cln is ORC format. Both of tables have
this ID based row. But the result is empty.
> Surprisingly, if I switch the position of TXT and ORC as follows,
> select a.id a_id,b.id b_id from orcdb.order_cln a, txtdb.order b where a.id = b.id and
b.id = '8a708a864faf8ef6014fb70426d62a67';
> Then this ID based row returns correctly., 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message