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
