You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Sergey Shelukhin (JIRA)" <ji...@apache.org> on 2016/01/06 20:10:40 UTC

[jira] [Commented] (HIVE-12657) selectDistinctStar.q results differ with jdk 1.7 vs jdk 1.8

    [ https://issues.apache.org/jira/browse/HIVE-12657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15086085#comment-15086085 ] 

Sergey Shelukhin commented on HIVE-12657:
-----------------------------------------

It appears the the column order is changed. Is column order defined for select *? If not, that is not a problem; I suspect it is, and anyway it would be nice if it was consistent. My telepathic debugging powers tell me that the code is using a hashset/map somewhere to achieve the "distinct" part, and the order change is expected because that is not ordered and ordering is known to be different in different jdks. 
We need to replace that with linkedhashset.

> selectDistinctStar.q results differ with jdk 1.7 vs jdk 1.8
> -----------------------------------------------------------
>
>                 Key: HIVE-12657
>                 URL: https://issues.apache.org/jira/browse/HIVE-12657
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 2.0.0
>            Reporter: Prasanth Jayachandran
>
> Encountered this issue when analysing test failures of HIVE-12609. selectDistinctStar.q produces the following diff when I ran with java version "1.7.0_55" and java version "1.8.0_60"
> {code}
> < 128   val_128 128     
> ---
> > 128           128     val_128
> 1770c1770
> < 224   val_224 224     
> ---
> > 224           224     val_224
> 1776c1776
> < 369   val_369 369     
> ---
> > 369           369     val_369
> 1799,1810c1799,1810
> < 146   val_146 146     val_146 146     val_146 2008-04-08      11
> < 150   val_150 150     val_150 150     val_150 2008-04-08      11
> < 213   val_213 213     val_213 213     val_213 2008-04-08      11
> < 238   val_238 238     val_238 238     val_238 2008-04-08      11
> < 255   val_255 255     val_255 255     val_255 2008-04-08      11
> < 273   val_273 273     val_273 273     val_273 2008-04-08      11
> < 278   val_278 278     val_278 278     val_278 2008-04-08      11
> < 311   val_311 311     val_311 311     val_311 2008-04-08      11
> < 401   val_401 401     val_401 401     val_401 2008-04-08      11
> < 406   val_406 406     val_406 406     val_406 2008-04-08      11
> < 66    val_66  66      val_66  66      val_66  2008-04-08      11
> < 98    val_98  98      val_98  98      val_98  2008-04-08      11
> ---
> > 146   val_146 2008-04-08      11      146     val_146 146     val_146
> > 150   val_150 2008-04-08      11      150     val_150 150     val_150
> > 213   val_213 2008-04-08      11      213     val_213 213     val_213
> > 238   val_238 2008-04-08      11      238     val_238 238     val_238
> > 255   val_255 2008-04-08      11      255     val_255 255     val_255
> > 273   val_273 2008-04-08      11      273     val_273 273     val_273
> > 278   val_278 2008-04-08      11      278     val_278 278     val_278
> > 311   val_311 2008-04-08      11      311     val_311 311     val_311
> > 401   val_401 2008-04-08      11      401     val_401 401     val_401
> > 406   val_406 2008-04-08      11      406     val_406 406     val_406
> > 66    val_66  2008-04-08      11      66      val_66  66      val_66
> > 98    val_98  2008-04-08      11      98      val_98  98      val_98
> 4212c4212
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)