[DRILL-6200] ERROR Quering hive through HiverServer2 via JDBC!

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.12.0
• Component/s: Client - JDBC, Storage - Hive, Storage - JDBC

Environment

CentOS Linux release 7.4.1708 (Core) (It's not a cluster node - thats why i'm using jdbc on hiveserver2).

Hive 2.1.1 Version

• Flags: Important
• Assignee: Unassigned
• Reporter: Willian Mattos Ribeiro
• Created: 01/Mar/18 14:24
• Updated: 31/May/18 21:37

Description

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)