[
https://issues.apache.org/jira/browse/HIVE-18157?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16269180#comment-16269180
]
Vihang Karajgaonkar commented on HIVE-18157:
--------------------------------------------
Thanks for confirming [~djaiswal] Linking the break JIRA here so that its
easier to track.
> Vectorization : Insert in bucketed table is broken with vectorization
> ---------------------------------------------------------------------
>
> Key: HIVE-18157
> URL: https://issues.apache.org/jira/browse/HIVE-18157
> Project: Hive
> Issue Type: Bug
> Reporter: Deepak Jaiswal
> Assignee: Deepak Jaiswal
> Attachments: HIVE-18157.1.patch, HIVE-18157.3.patch
>
>
> create temporary table foo (x int) clustered by (x) into 4 buckets;
> insert overwrite table foo values(1),(2),(3),(4),(9);
> select *, regexp_extract(INPUT__FILE__NAME, '.*/(.*)', 1) from foo;
> OK
> 9 000000_0
> 4 000000_0
> 3 000000_0
> 2 000000_0
> 1 000000_0
> set hive.vectorized.execution.enabled=false;
> insert overwrite table foo values(1),(2),(3),(4),(9);
> select *, regexp_extract(INPUT__FILE__NAME, '.*/(.*)', 1) from foo;
> OK
> 4 000000_0
> 9 000001_0
> 1 000001_0
> 2 000002_0
> 3 000003_0
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
