[
https://issues.apache.org/jira/browse/HIVE-26132?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David updated HIVE-26132:
-------------------------
Affects Version/s: 3.1.3
> Schematool upgradeSchema fails with nullPointerException
> ---------------------------------------------------------
>
> Key: HIVE-26132
> URL: https://issues.apache.org/jira/browse/HIVE-26132
> Project: Hive
> Issue Type: Bug
> Affects Versions: 3.1.3
> Reporter: David
> Priority: Major
>
> When running schematool upgradeSchema against a mysql database with a
> metastore_db, I get a nullPointerException. The command is:
>
> {{schematool -dbType mysql -upgradeSchema -verbose}}
>
> The same exception can be created by running the relevant hive upgrade script
> directly in beeline with the following command:
>
> {{beeline -u jdbc:mysql://mysql:3306/metastore_db -n [USER] -p[PASS] -f
> /usr/local/hive/scripts/metastore/upgrade/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql}}
>
> Removing the follow lines from the sql script fixes this:
>
> {{SELECT 'Upgrading MetaStore schema from 2.3.0 to 3.0.0' AS ' ';}}
> {{SELECT 'Finished upgrading MetaStore schema from 2.3.0 to 3.0.0' AS ' ';}}
>
> The beeline exception is:
> {quote}Connecting to jdbc:mysql://mysql:3306/metastore_db
> Connected to: MySQL (version 5.6.51)
> Driver: MySQL Connector/J (version mysql-connector-java-8.0.28 (Revision:
> 7ff2161da3899f379fb3171b6538b191b1c5c7e2))
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> 0: jdbc:mysql://mysql:3306/metastore_db> SELECT 'Finished upgrading MetaStore
> schema from 2.3.0 to 3.0.0' AS ' ';
> The statement instance is not HiveStatement type: class
> com.mysql.cj.jdbc.StatementImpl
> The statement instance is not HiveStatement type: class
> com.mysql.cj.jdbc.StatementImpl
> java.lang.NullPointerException
> at java.lang.StringBuilder.<init>(StringBuilder.java:112)
> at org.apache.hive.beeline.ColorBuffer.center(ColorBuffer.java:81)
> at
> org.apache.hive.beeline.TableOutputFormat.getOutputString(TableOutputFormat.java:123)
> at
> org.apache.hive.beeline.TableOutputFormat.getOutputString(TableOutputFormat.java:108)
> at
> org.apache.hive.beeline.TableOutputFormat.print(TableOutputFormat.java:51)
> at org.apache.hive.beeline.BeeLine.print(BeeLine.java:2257)
> at org.apache.hive.beeline.Commands.executeInternal(Commands.java:1026)
> at org.apache.hive.beeline.Commands.execute(Commands.java:1201)
> at org.apache.hive.beeline.Commands.sql(Commands.java:1130)
> at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:1425)
> at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:1287)
> at org.apache.hive.beeline.BeeLine.executeFile(BeeLine.java:1261)
> at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:1064)
> at
> org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:538)
> at org.apache.hive.beeline.BeeLine.main(BeeLine.java:520)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.apache.hadoop.util.RunJar.run(RunJar.java:226)
> at org.apache.hadoop.util.RunJar.main(RunJar.java:141)
> Closing: 0: jdbc:mysql://mysql:3306/metastore_db
> {quote}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
