Hive query returns empty result set - by Pablo Álvarez Doval

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 799283 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 8/30/2013 11:07:31 AM
Access Restriction Public

Description

We've got an scenario where some Hive tables fail to return any result; even a SELECT COUNT(*) FROM Table returns null.

The affected tables are not empty, as can be deduced for the fact that there are files in their Hive Warehouse folder and a 'Hadoop fs -du ...' shows they are not empy. 

The format of the input data is text sequence files. HDInsight cluster versión is 1.5.
Sign in to post a comment.
Posted by Pablo Álvarez Doval on 9/15/2013 at 1:49 PM
Using the provided workaround we can make the tables work as expected. Thanks!