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.
|Status||Patch Available [ 10002 ]||Open [ 1 ]|
|Status||Patch Available [ 10002 ]||Resolved [ 5 ]|
|Hadoop Flags||Reviewed [ 10343 ]|
|Resolution||Fixed [ 1 ]|
|Fix Version/s||0.10.0 [ 12320745 ]|
|Status||Resolved [ 5 ]||Closed [ 6 ]|