You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Deepak Jaiswal (JIRA)" <ji...@apache.org> on 2017/11/28 01:56:00 UTC

[jira] [Created] (HIVE-18157) Vectorization : Insert in bucketed table is broken with vectorization

Deepak Jaiswal created HIVE-18157:
-------------------------------------

             Summary: 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


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)