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

1.18 cannot connect to Hive 2.3 with embedded metastore

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.18.0
    • Fix Version/s: None
    • Component/s: Storage - Hive
    • Labels:
      None
    • Environment:

      Hive 2.3.7

      Description

      Hi, I tested the compatibility of the 1.18 RC. As a result, Drill 1.18 can still connect to HDFS 2.6 (Based CDH 5.13), but cannot connect to Hive 2.3. The metadata of Hive 3.1 required by Drill 1.18 has changed a lot. This is the official upgrade script(https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql).

      Here are the errors thrown by trying to connect to Hive 2.3 with embedded metastore. And then I also test the remote metastore, can be created successfully, but don't show anything after "show databases".

      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'CTLG_NAME' in 'field list'
              at sun.reflect.GeneratedConstructorAccessor368.newInstance(Unknown Source)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
      

       

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              luoc Cong Luo
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: