[
https://issues.apache.org/jira/browse/DRILL-6200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hannibal07 updated DRILL-6200:
------------------------------
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
> 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
> 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: Hannibal07
> 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)
