I have a problem to run hql from shell script. I can run partition query just like "use myDB; show partitions myTbl;" But I have a problem count query just like "use myDB; select count(*) from myTbl where date=20141102;" I have these error messages for it.
How can I run my count hive query in shell script? ------------------------------ Time taken: 2.031 seconds Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks determined at compile time: 1 In order to change the average load for a reducer (in bytes): set hive.exec.reducers.bytes.per.reducer=<number> In order to limit the maximum number of reducers: set hive.exec.reducers.max=<number> In order to set a constant number of reducers: set mapred.reduce.tasks=<number> java.io.FileNotFoundException: ....