hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepak Jaiswal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-19481) sample10.q returns wrong results
Date Mon, 25 Jun 2018 22:23:00 GMT

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

Deepak Jaiswal commented on HIVE-19481:
---------------------------------------

Yes the results are valid. If you look at the logic in Partition.java, if the number of files
is not equal to number of partitions, it would blow, which is now fixed, giving correct number
of rows.

 

Thanks for the review [~sershe]

> sample10.q returns wrong results 
> ---------------------------------
>
>                 Key: HIVE-19481
>                 URL: https://issues.apache.org/jira/browse/HIVE-19481
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 3.0.0
>            Reporter: Steve Yeom
>            Assignee: Deepak Jaiswal
>            Priority: Major
>             Fix For: 3.1.0, 4.0.0
>
>         Attachments: HIVE-19481.1.patch, HIVE-19481.2.patch, HIVE-19481.3.patch, HIVE-19481.4.patch
>
>
> Ran "mvn test -Dtest=TestMiniLlapLocalCliDriver -Dqfile=sample10.q " after changing the
table to be 
> insert-only transactional. 
> The following queries returns couple of rows whereis no row results returns for non-ACID
table. 
> query: select ds, count(1) from srcpartbucket tablesample (bucket 2 out of 4 on key)
where ds is not null group by ds ORDER BY ds ASC
> 2008-04-08      14
> 2008-04-09      14
> ..
> query: select ds, count(1) from srcpartbucket tablesample (bucket 1 out of 2 on key)
where ds is not null group by ds ORDER BY ds ASC
> 2008-04-08      4
> 2008-04-09      4



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message