Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
MIME-Version: 1.0
Date: Wed, 20 Jan 2016 11:46:18 +0800
Message-ID: 
 <CAKf=WiWPb2=Wc6iwVRQFLA8kA8TdsHurPoFhw92Uu3V4ffee4g@mail.gmail.com>
Subject: the `use database` command will change the scheme of target table?
From: =?UTF-8?B?6JGj5Lqa5Yab?= <ric.dong@liulishuo.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=089e013cbeb42f15700529bbd4d5

--089e013cbeb42f15700529bbd4d5
Content-Type: text/plain; charset=UTF-8

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.

--089e013cbeb42f15700529bbd4d5
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><font face=3D"verdana, sans-serif">hi list,=C2=A0</font><d=
iv><font face=3D"verdana, sans-serif"><br></font></div><blockquote style=3D=
"margin:0px 0px 0px 40px;border:none;padding:0px">we use the HDFS and S3 as=
 the Hive Filesystem at the same time. =C2=A0 here has an issue:=C2=A0<br><=
br><br><u>scenario</u> 1:<br><br>hive command: <br>=C2=A0<br>use default;=
=C2=A0<br><br>create table temp.t1 =C2=A0 =C2=A0 =C2=A0 // the database of =
temp which points to HDFS=C2=A0<br>as=C2=A0<br>select c1 from prd.t2; =C2=
=A0 =C2=A0 // the database of prd and the table t2 are all points to S3<br>=
<br>it works well.=C2=A0<br><br><br><u>scenario</u> 2:=C2=A0<br><br>hive co=
mmand:=C2=A0<br><br><b>use prd;=C2=A0</b><br><br>create table temp.t1 =C2=
=A0 =C2=A0 =C2=A0 // the database of temp which points to HDFS=C2=A0<br>as=
=C2=A0<br>select c1 from prd.t2; =C2=A0 =C2=A0 // the database of prd and t=
he table t2 are all point to S3<br><br>the exception occurred with:=C2=A0<b=
r><br>Failed with exception Unable to move source s3a://warehouse-tmp/tmp/h=
ive-ubuntu/hive_2016-01-20_xxxxxx/-ext-10001 to destination hdfs://hadoop-0=
/warehouse/temp.db/t1/<br><br>and then, I try to change the Scratch space b=
y the configuration key: hive.exec.scratchdir, and set the value to hdfs://=
hadoop-0/<b>tmp-foo</b>/... , but also failed with:<br><br>Unable to move s=
ource s3a://warehouse-tmp<b>/tmp-foo</b> ... to=C2=A0<br><br>it seems to th=
e <i><b>use database</b></i> command change the scheme of the path for targ=
et table?=C2=A0<br><br>hive version: 0.13.1=C2=A0</blockquote><br><div>than=
ks.=C2=A0</div></div>

--089e013cbeb42f15700529bbd4d5--