[Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement

Question

I'm getting the following error while executing queries against a database in impala. With other databases its working fine.

Error trace is as follows.

[Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: select * from test_table limit 1, SQL state: {1}, Query: {2}.[]
java.sql.SQLException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: [Simba][JSQLEngine](12010) The table "test_table"    could not be found., SQL state: HY000, Query: select count(*) from test_table.
            at     com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngine.prepare(Unknown Source)
            at com.cloudera.impala.jdbc.common.SStatement.executeNoParams(Unknown Source)
            at com.cloudera.impala.jdbc.common.SStatement.executeQuery(Unknown Source)
Caused by: com.cloudera.impala.support.exceptions.GeneralException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: [Simba][JSQLEngine](12010) The table "test_table" could not be found., SQL state: HY000, Query: select count(*) from test_table.
            ... 3 more

if I execute show tables its listing the table name.

If I execute it from hue its not displaying anything in the result.

I tried by invalidating the metadata.

I tried by changing to latest driver jdbc41 same problem.

Where might be the problem?

Answer 1

In my case, this error was caused by not having a /user/scott directory on hdfs with write permissions for the Hiveserver (running as cloudera-scm user)(my jdbc connection uses scott as the user id). Once I created the dir and chmod'ed it, I could run all queries. Earlier only select * worked but select count(*) did not.