[jira] [Created] (HIVE-15417) Glitches using ACID's row__id hidden column

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

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)