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)