BTW, if you can let us know how you did the upgrade, it should help us to find out the root cause of the problem. Thanks. ... View more

You are welcome. This is the safest method. You may want to come up a script to do so. ... View more

For this table, you can use alter table employees set location ' hdfs://:8020/user/hive/warehouse/employees' to fix it. Do you see the problem for other tables? If you create a new table, does it have this problem too? ... View more

What's your setting "fs.defaultFS"? What's the output of "describe formatted employees"? ... View more

What's your setting "hive.metastore.warehouse.dir"? ... View more

It seems you missed a "," between pagename and year after SELECT. ... View more

Have you tried to restart the whole cluster, use hbck to fix meta/assignment? Is the log level DEBUG? If so, you should get quite some information. Without knowing why it is stuck, it would be hard to fix. ... View more

That's bad. Do you see anything wrong in the region server log? How many regions in total do you have? ... View more