> 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