Hi All, Can experts share your view on Hive behaviour in below scenario.
I am facing below issue on using alter partition locations in hive. *select count(*) from table1 where dt = 201501;* *Total 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 mapreduce.job.reduces=<number>* *java.io.IOException: cannot find dir = hdfs:///data/dt =201501/1430201400/* *in pathToPartitionInfo: [hdfs:/data/dt=201501/1430201400/]* Below are the steps I have followed. I have altered a partition location in hive using below command. ALTER TABLE table1 PARTITION (dt=201501) SET LOCATION 'hdfs:///data/dt=201501/1430201400/'; I have inserted new data into this new location. INSERT INTO TABLE table1 SELECT * FROM table2 where dt=201501 *select count(*) from table1 where dt = 201501; doesn't work but * *select * from table1 **where dt = 201501 works good.* Please let me know if you need more information. Thanks Harsha
