drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hannibal07 (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-6200) ERROR Quering hive through HiverServer2 via JDBC!
Date Thu, 01 Mar 2018 14:34:00 GMT

     [ https://issues.apache.org/jira/browse/DRILL-6200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Hannibal07 updated DRILL-6200:
------------------------------
    Flags: Important

> 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)

Mime
View raw message