hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vineet Mishra <clearmido...@gmail.com>
Subject Re: Hive Server Load Data InPath Fails
Date Sun, 13 Sep 2015 05:56:02 GMT
I got it worked.

Thanks anyways!

On Sat, Sep 12, 2015 at 1:56 AM, Takahiko Saito <tysaito@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 <clearmidoubt@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
>

Mime
View raw message