Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hadoop.apache.org
MIME-Version: 1.0
Date: Fri, 11 Sep 2015 12:39:47 +0530
Message-ID: 
 <CAOi=ZKR3mnwM4uVVYtF+VfLCykSWo8F+mSQNDDEqP3GHb-PWfw@mail.gmail.com>
Subject: Hive Server Load Data InPath Fails
From: Vineet Mishra <clearmidoubt@gmail.com>
To: cdh-user@cloudera.org, user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=001a113dea22ac4025051f73668d

--001a113dea22ac4025051f73668d
Content-Type: text/plain; charset=UTF-8

Hi All,

I am making a Hive Thrift connection to Hive Server and with load data
inpath command to one of my table I am landing into some bizzare exception.

Other queries seems out to be working fine, but this is the only query
which is getting failed

15/09/11 11:40:32 ERROR utils.HCatalogUtil: Executing Query: load data
inpath '/data/mount/si/piu/' overwrite into table scnrt2.piu
HiveServerException(message:Query returned non-zero code: 10001, cause:
FAILED: SemanticException [Error 10001]: Line 1:130 Table not found 'piu',
errorCode:10001, SQLState:42S02)

The table is created in the scnrt2 database and exist before the command is
invoked.

I have even tried executing the same query using the query "use scnrt2"
before firing the load data but still not luck, while the same query is
executing fine from the hive command line.

Any quick feedback would be appreciated!

Thanks!

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

<div dir=3D"ltr">Hi All,<div><br></div><div>I am making a Hive Thrift conne=
ction to Hive Server and with load data inpath command to one of my table I=
 am landing into some bizzare exception.</div><div><br></div><div>Other que=
ries seems out to be working fine, but this is the only query which is gett=
ing failed</div><div><br></div><div><div>15/09/11 11:40:32 ERROR utils.HCat=
alogUtil: Executing Query: load data inpath &#39;/data/mount/si/piu/&#39; o=
verwrite into table scnrt2.piu</div><div>HiveServerException(message:Query =
returned non-zero code: 10001, cause: FAILED: SemanticException [Error 1000=
1]: Line 1:130 Table not found &#39;piu&#39;, errorCode:10001, SQLState:42S=
02)</div></div><div><br></div><div>The table is created in the scnrt2 datab=
ase and exist before the command is invoked.</div><div><br></div><div>I hav=
e even tried executing the same query using the query &quot;use scnrt2&quot=
; before firing the load data but still not luck, while the same query is e=
xecuting fine from the hive command line.</div><div><br></div><div>Any quic=
k feedback would be appreciated!</div><div><br></div><div>Thanks!</div></di=
v>

--001a113dea22ac4025051f73668d--