hive - Can't do a CTAS when I use dbname in CTAS -

a piculiarity noticed.

when try

create table dbname.table_name select

i error creating temporary folder on: hdfs://nameservice1/apps/hive/warehouse. error encountered near token 'tok_tmp_file'

but if first do

use dbname;

and then

create table table_name select

it works. why that?

to create table in database user need have write permission on current database , database in table being created.

i.e. while running create table dbname.table_name select statement , need have write permission on current database well.

this known issue reported in jira hive-11427.

TY