Hi Gopal, My mapreduce.input.fileinputformat.input.dir.recursive was set to false. Setting it to true fixed it.
Thanks a lot! Gufran Pathan| +91 7760913355| www.mu-sigma.com | Correlation does not imply causation, but it does waggle its eyebrows suggestively and gesture furtively while mouthing "look over there." -Randall Munroe -----Original Message----- From: Gopal Vijayaraghavan [mailto:go...@hortonworks.com] On Behalf Of Gopal Vijayaraghavan Sent: Thursday, June 11, 2015 11:53 AM To: user@hive.apache.org Subject: Re: Empty Table in MR with "union all" (created in Tez) > set hive.execution.engine=mr; > select * from test_table; --gives empty table > Any ideas on why this must be happening? This issue does not occur >when I don¹t use a ³union all² query. What is the value of the parameter mapreduce.input.fileinputformat.input.dir.recursive in your mapred-site.xml? Cheers, Gopal Disclaimer: http://www.mu-sigma.com/disclaimer.html