[
https://issues.apache.org/jira/browse/HIVE-14711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Qiuzhuang Lian updated HIVE-14711:
----------------------------------
Description:
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.,
was:
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.,
> 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)
