You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Hannibal07 (JIRA)" <ji...@apache.org> on 2018/03/01 14:25:00 UTC

[jira] [Created] (DRILL-6200) ERROR Quering hive through HiverServer2 via JDBC!

Hannibal07 created DRILL-6200:
---------------------------------

             Summary: ERROR Quering hive through HiverServer2 via JDBC!
                 Key: DRILL-6200
                 URL: https://issues.apache.org/jira/browse/DRILL-6200
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - JDBC
    Affects Versions: 1.12.0
            Reporter: Hannibal07


ERROR [HY000] [MapR][Drill] (1040) Drill failed to execute the query: select * from dim_parameter
[30034]Query execution error. Details:[ 
DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query.

sql SELECT *
FROM.dw.dim_parameter
plugin hive
Fragment 0:0

[Error Id: e522f220-b857-4273-af0a-2a2d05d992f2 on 172.28.32.7:31010]

(org.apache.hive.service.cli.HiveSQLException) Error while compiling statement: FAILED: ParseException line 2:4 cannot recognize input near '.' 'dw' '.' in join source
 org.apache.hive.jdbc.Utils.verifySuccess():267
 org.apache.hive.jdbc.Utils.verifySuccessWithInfo():253
 org.apache.hive.jdbc.HiveStatement.runAsyncOnServer():309
 org.apache.hive.jdbc.HiveStatement.execute():250
 org.apache.hive.jdbc.HiveStatement.executeQuery():434
 org.apache.commons.dbcp.DelegatingStatement.executeQuery():208
 org.apache.commons.dbcp.DelegatingStatement.executeQuery():208
 org.apache.drill.exec.store.jdbc.JdbcRecordReader.setup():177
 org.apache.drill.exec.p...
 em System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
 em System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
 em System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
 em System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
 em DrillExplorer.DROdbcProvider.GetStatmentColumns(String in_query)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)