Jesus Camacho Rodriguez created HIVE-15417:
----------------------------------------------
Summary: Glitches using ACID's row__id hidden column
Key: HIVE-15417
URL: https://issues.apache.org/jira/browse/HIVE-15417
Project: Hive
Issue Type: Bug
Affects Versions: 2.2.0
Reporter: Carter Shanklin
Assignee: Jesus Camacho Rodriguez
This only works if you turn PPD off.
{code:sql}
drop table if exists hello_acid;
create table hello_acid (key int, value int)
partitioned by (load_date date)
clustered by(key) into 3 buckets
stored as orc tblproperties ('transactional'='true');
insert into hello_acid partition (load_date='2016-03-01') values (1, 1);
insert into hello_acid partition (load_date='2016-03-02') values (2, 2);
insert into hello_acid partition (load_date='2016-03-03') values (3, 3);
{code}
{code}
hive> set hive.optimize.ppd=true;
hive> select tid from (select row__id.transactionid as tid from hello_acid) sub
where tid = 15;
FAILED: SemanticException MetaException(message:cannot find field row__id from
[0:load_date])
hive> set hive.optimize.ppd=false;
hive> select tid from (select row__id.transactionid as tid from hello_acid) sub
where tid = 15;
OK
tid
15
Time taken: 0.075 seconds, Fetched: 1 row(s)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
