That is the expected behaviour. Managed tables are created within the directory of their host database.
On Tuesday, 19 January 2016, 董亚军 <ric.d...@liulishuo.com> wrote: > 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. > -- Want to work at Handy? Check out our culture deck and open roles <http://www.handy.com/careers> Latest news <http://www.handy.com/press> at Handy Handy just raised $50m <http://venturebeat.com/2015/11/02/on-demand-home-service-handy-raises-50m-in-round-led-by-fidelity/> led by Fidelity
