hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcin Tustin <mtus...@handybook.com>
Subject Re: the `use database` command will change the scheme of target table?
Date Wed, 20 Jan 2016 03:52:04 GMT
That is the expected behaviour. Managed tables are created within the
directory of their host database.

On Tuesday, 19 January 2016, 董亚军 <ric.dong@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


Mime
View raw message