Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6200

ERROR Quering hive through HiverServer2 via JDBC!

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.12.0
    • Fix Version/s: None
    • Labels:
      None
    • 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

      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)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              willianmattos Willian Mattos Ribeiro
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: