[HIVE-11510] Metatool updateLocation warning on views

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.14.0
• Fix Version/s: 1.3.0, 2.0.0
• Component/s: Database/Schema
• Assignee: Wei Zheng
• Reporter: Eric Czech
• Created: 10/Aug/15 13:32
• Updated: 16/Feb/16 23:53
• Resolved: 10/Sep/15 19:16

Description

If views are present in a hive database, issuing a 'hive metatool -updateLocation' command will result in an error like this:

...
Warning: Found records with bad LOCATION in SDS table..
bad location URI: null
bad location URI: null
bad location URI: null
....

Based on the source code for Metatool, it looks like there would then be a "bad location URI: null" message for every view and it also appears this is happening simply because the 'sds' table in the hive schema has a column called location that is NULL only for views.