[jira] [Created] (HIVE-14711) HQL in which involves with join between txt and orc tables returns incorrect result

[Qiuzhuang Lian (JIRA)]

Qiuzhuang Lian created HIVE-14711:
-------------------------------------

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


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)