You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hadoop.apache.org by Vineet Mishra <cl...@gmail.com> on 2015/09/11 09:09:47 UTC
Hive Server Load Data InPath Fails
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!
Re: Hive Server Load Data InPath Fails
Posted by Vineet Mishra <cl...@gmail.com>.
I got it worked.
Thanks anyways!
On Sat, Sep 12, 2015 at 1:56 AM, Takahiko Saito <ty...@gmail.com> wrote:
> What version of Hive is being used?
> In the past, I can see we had the following JIRA:
> https://issues.apache.org/jira/browse/HIVE-4256: JDBC2 HiveConnection
> does not use the specified database.
>
> On Fri, Sep 11, 2015 at 12:44 AM, Vineet Mishra <cl...@gmail.com>
> wrote:
>
>>
>> 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!
>>
>>
>
>
> --
> Takahiko Saito
>
Re: Hive Server Load Data InPath Fails
Posted by Takahiko Saito <ty...@gmail.com>.
What version of Hive is being used?
In the past, I can see we had the following JIRA:
https://issues.apache.org/jira/browse/HIVE-4256: JDBC2 HiveConnection does
not use the specified database.
On Fri, Sep 11, 2015 at 12:44 AM, Vineet Mishra <cl...@gmail.com>
wrote:
>
> 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!
>
>
--
Takahiko Saito
Fwd: Hive Server Load Data InPath Fails
Posted by Vineet Mishra <cl...@gmail.com>.
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!