[
https://issues.apache.org/jira/browse/HIVE-21862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16863394#comment-16863394
]
Jesus Camacho Rodriguez commented on HIVE-21862:
------------------------------------------------
[~vgarg], can we upgrade to ORC 1.5.6? Otherwise as I understand it, the issue
is not reproducible. Also it will be good to see whether the two orc patches
are creating issues with other tests.
In addition, there seems to be a typo in latest patch:
{code}
...
set hive.vectorized.execution.enabled=true:when ;
...
{code}
> ORC ppd produces wrong result with timestamp
> --------------------------------------------
>
> Key: HIVE-21862
> URL: https://issues.apache.org/jira/browse/HIVE-21862
> Project: Hive
> Issue Type: Bug
> Components: ORC
> Affects Versions: 4.0.0
> Reporter: Vineet Garg
> Assignee: Vineet Garg
> Priority: Major
> Attachments: HIVE-21862.1.patch, HIVE-21862.2.patch
>
>
> Note that to reproduce this ORC-491 and ORC-477 is required.
> {code:sql}
> set hive.vectorized.execution.enabled=false;
> set hive.support.concurrency=true;
> set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
> set hive.tez.bucket.pruning=true;
> set hive.optimize.index.filter=true;
> set hive.metastore.disallow.incompatible.col.type.changes=false;
> create table change_allowincompatible_vectorization_false_date (ts date)
> partitioned by (s string) clustered by (ts) into 32 buckets stored as orc
> tblproperties ('transactional'='true');
> alter table change_allowincompatible_vectorization_false_date add
> partition(s='aaa');
> alter table change_allowincompatible_vectorization_false_date add
> partition(s='bbb');
> insert into table change_allowincompatible_vectorization_false_date partition
> (s='aaa') select ctimestamp1 from alltypesorc where ctimestamp1 >
> '2000-01-01' limit 50;
> insert into table change_allowincompatible_vectorization_false_date partition
> (s='bbb') select ctimestamp1 from alltypesorc where ctimestamp1 <
> '2000-01-01' limit 50;
> select count(*) from change_allowincompatible_vectorization_false_date;
> alter table change_allowincompatible_vectorization_false_date change column
> ts ts timestamp;
> select count(*) from change_allowincompatible_vectorization_false_date;
> insert into table change_allowincompatible_vectorization_false_date partition
> (s='aaa') values ('2038-03-22 07:26:48.0');
> select ts from change_allowincompatible_vectorization_false_date where
> ts='2038-03-22 07:26:48.0' and s='aaa';
> {code}
> Expected is one row but actual is zero
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
