hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Takahiko Saito <tysa...@gmail.com>
Subject Re: Hive Server Load Data InPath Fails
Date Fri, 11 Sep 2015 20:26:29 GMT
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