[
https://issues.apache.org/jira/browse/HIVE-7266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Shelukhin updated HIVE-7266:
-----------------------------------
Status: Patch Available (was: Open)
> Optimized HashTable with vectorized map-joins results in String columns
> extending
> ---------------------------------------------------------------------------------
>
> Key: HIVE-7266
> URL: https://issues.apache.org/jira/browse/HIVE-7266
> Project: Hive
> Issue Type: Bug
> Components: Tez, Vectorization
> Affects Versions: 0.14.0
> Reporter: Gopal V
> Assignee: Sergey Shelukhin
> Attachments: HIVE-7266.patch, hive-7266-small-test.tgz
>
>
> The following query returns different results when both vectorized mapjoin
> and the new optimized hashtable are enabled.
> {code}
> hive> set hive.vectorized.execution.enabled=false;
> hive> select s_suppkey, n_name from supplier, nation where s_nationkey =
> n_nationkey limit 25;
> ...
> 316869 JAPAN
> 1636869 RUSSIA
> 1096869 IRAN
> 7236869 RUSSIA
> 2276869 INDIA
> 8516869 ARGENTINA
> 2636869 MOZAMBIQUE
> 3836869 ROMANIA
> 2616869 FRANCE
> {code}
> But when vectorization is enabled, the results are
> {code}
> 316869 JAPAN
> 1636869 RUSSIA
> 1096869 IRANIA
> 7236869 RUSSIA
> 2276869 INDIAA
> 8516869 ARGENTINA
> 2636869 MOZAMBIQUE
> 3836869 ROMANIAQUE
> 2616869 FRANCEAQUE
> {code}
> it works correctly with vectorization when the new optimized map-join
> hashtable is disabled
> {code}
> hive> set hive.vectorized.execution.enabled=true;
>
> hive> set hive.mapjoin.optimized.hashtable=false;
>
> hive> select s_suppkey, n_name from supplier, nation where s_nationkey =
> n_nationkey limit 25;
> 316869 JAPAN
> 1636869 RUSSIA
> 1096869 IRAN
> 7236869 RUSSIA
> 2276869 INDIA
> 8516869 ARGENTINA
> 2636869 MOZAMBIQUE
> 3836869 ROMANIA
> 2616869 FRANCE
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
