the `use database` command will change the scheme of target table?

[董亚军]

hi list,

we use the HDFS and S3 as the Hive Filesystem at the same time.   here has
an issue:


*scenario* 1:

hive command:

use default;

create table temp.t1       // the database of temp which points to HDFS
as
select c1 from prd.t2;     // the database of prd and the table t2 are all
points to S3

it works well.


*scenario* 2:

hive command:

*use prd; *

create table temp.t1       // the database of temp which points to HDFS
as
select c1 from prd.t2;     // the database of prd and the table t2 are all
point to S3

the exception occurred with:

Failed with exception Unable to move source
s3a://warehouse-tmp/tmp/hive-ubuntu/hive_2016-01-20_xxxxxx/-ext-10001 to
destination hdfs://hadoop-0/warehouse/temp.db/t1/

and then, I try to change the Scratch space by the configuration key:
hive.exec.scratchdir, and set the value to hdfs://hadoop-0/*tmp-foo*/... ,
but also failed with:

Unable to move source s3a://warehouse-tmp*/tmp-foo* ... to

it seems to the *use database* command change the scheme of the path for
target table?

hive version: 0.13.1


thanks.