[HIVE-1451] Creating a table stores the full address of namenode in the metadata. This leads to problems when the namenode address changes.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 0.5.0
• Component/s: Metastore, Query Processor

Environment

Any

• Assignee: Unassigned
• Reporter: Arvind Prabhakar
• Created: 07/Jul/10 01:42
• Updated: 13/Oct/11 18:57
• Resolved: 13/Oct/11 18:57

Description

Here is an excerpt from table metadata for an arbitrary table table1:

hive> describe extended table1;
OK
...
Detailed Table Information	...
location:hdfs://localhost:9000/user/arvind/hive/warehouse/table1, 
...

As can be seen, the full address of namenode is captured in the location information for the table. This information is later used to run any queries on the table - thus making it impossible to change the namenode location once the table has been created. For example, for the above table, a query will fail if the namenode is migrated from port 9000 to 8020:

hive> select * from table1;
OK
Failed with exception java.io.IOException:java.net.ConnectException: Call to localhost/127.0.0.1:9000
failed on connection exception: java.net.ConnectException: Connection refused
Time taken: 10.78 seconds
hive> 

It should be possible to change the namenode location regardless of when the tables are created. Also, any query execution should work with the configured namenode at that point in time rather than requiring the configuration to be exactly the same at the time when the tables were created.