[
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)
