You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Sergey Shelukhin (JIRA)" <ji...@apache.org> on 2014/07/23 23:42:39 UTC
[jira] [Assigned] (HIVE-7266) Optimized HashTable with vectorized
map-joins results in String columns extending
[ https://issues.apache.org/jira/browse/HIVE-7266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sergey Shelukhin reassigned HIVE-7266:
--------------------------------------
Assignee: Sergey Shelukhin (was: Matt McCline)
> 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-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)