[ https://issues.apache.org/jira/browse/DRILL-6200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kunal Khatua updated DRILL-6200: -------------------------------- Component/s: Storage - JDBC > 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, Storage - Hive, Storage - JDBC > Affects Versions: 1.12.0 > 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 > Reporter: Willian Mattos Ribeiro > Priority: Major > > 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)