CODEWITHSUNDEEP
hadoopjdbcclouderaimpala
smali
smali

Reputation: 4805

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

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?

Upvotes: 5

Views: 29804

Answers (2)

kiru
kiru

Reputation: 29

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.

Upvotes: 1

smali
smali

Reputation: 4805

The problem was in the .avro file format. My teamlead has fixed it, Not sure what he has done he just said it was the problem of file format.

Upvotes: 0

Related Questions