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.

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


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!