spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mohammed Guller <>
Subject Spark SQL unable to recognize schema name
Date Tue, 04 Aug 2015 18:45:19 GMT
Hi -

I am running the Thrift JDBC/ODBC server (v1.4.1) and encountered a problem when querying
tables using fully qualified table names(schemaName.tableName). The following query works
fine from the beeline tool:

SELECT * from test;

However, the following query throws an exception, even though the table “test” does exist
under the “default” schema:

SELECT * from default.test;

Error: org.apache.spark.sql.AnalysisException: no such table default.test; line 1 pos 22 (state=,code=0)

Here is the exception trace on the Thrift Server console:

15/08/04 14:27:03 WARN ThriftCLIService: Error executing statement:
org.apache.hive.service.cli.HiveSQLException: org.apache.spark.sql.AnalysisException: no such
table default.test; line 1 pos 22
        at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(
        at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(
        at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(
        at java.lang.reflect.Method.invoke(
        at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(
        at org.apache.hive.service.cli.session.HiveSessionProxy.access$000(
        at org.apache.hive.service.cli.session.HiveSessionProxy$
        at Method)

Is it a bug in 1.4.1 or am I missing some configuration parameter?


View raw message