[HIVE-3486] CTAS in database with location on non-default name node fails

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.10.0
• Fix Version/s: 0.10.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Kevin Wilfong
• Reporter: Kevin Wilfong
• Created: 19/Sep/12 05:23
• Updated: 10/Jan/13 19:53
• Resolved: 20/Sep/12 04:05

Description

If a database has a location which is on a different name node than the default database's location, CTAS queries run in that database will fail.

This is because the intermediate location which is where the final FileSinkOperator writes to is determined based on the scheme and authority of the value of hive.metastore.warehouse.dir instead of the table's database's location.