I got it worked. Thanks anyways!
On Sat, Sep 12, 2015 at 1:56 AM, Takahiko Saito <tysa...@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 <clearmido...@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 >
