[
https://issues.apache.org/jira/browse/DRILL-7815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
luocong updated DRILL-7815:
---------------------------
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".
{code:java}
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)
{code}
was:
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 dadabases".
{code:java}
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)
{code}
> 1.18 cannot connect to Hive 2.3 with embedded metastore
> -------------------------------------------------------
>
> Key: DRILL-7815
> URL: https://issues.apache.org/jira/browse/DRILL-7815
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Hive
> Affects Versions: 1.18.0
> Environment: Hive 2.3.7
> Reporter: luocong
> Priority: Major
>
> 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".
> {code:java}
> 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)
> {code}
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
