[
https://issues.apache.org/jira/browse/HIVE-12263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14977808#comment-14977808
]
Chen Xin Yu commented on HIVE-12263:
------------------------------------
Hi Ashutosh Chauhan,
Thanks for your review, I went through the failed UTs, that's not related to
this fix, so could you please help commit this fix into trunk build? Thanks!
Any further information just feel free to let me know.
> Hive SchemaTool does not tolerate leading spaces in JDBC url
> ------------------------------------------------------------
>
> Key: HIVE-12263
> URL: https://issues.apache.org/jira/browse/HIVE-12263
> Project: Hive
> Issue Type: Bug
> Affects Versions: 1.2.1
> Reporter: Chen Xin Yu
> Assignee: Chen Xin Yu
> Attachments: HIVE-12263.1.patch
>
>
> With configuration as below:
> <property>
> <name>
> javax.jdo.option.ConnectionURL
> </name>
> <value>
> jdbc:mysql://host/hive?createDatabaseIfNotExist=true
> </value>
> </property>
> SchemaTool will failed:
> export HIVE_CONF_DIR=$HIVE_CONF_DIR; schematool -dbType mysql -userName hive
> -passWord xxx -initSchema -verbose
> exception as below:
> Metastore connection URL:
> jdbc:mysql://host/hive?createDatabaseIfNotExist=true
> Metastore Connection Driver : com.mysql.jdbc.Driver
> Metastore connection User: hive
> org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema
> version.
> org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema
> version.
> at
> org.apache.hive.beeline.HiveSchemaHelper.getConnectionToMetastore(HiveSchemaHelper.java:77)
> at
> org.apache.hive.beeline.HiveSchemaTool.getConnectionToMetastore(HiveSchemaTool.java:113)
> at
> org.apache.hive.beeline.HiveSchemaTool.testConnectionToMetastore(HiveSchemaTool.java:159)
> at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:257)
> at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:243)
> at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:473)
> 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:497)
> at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
> at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
> Caused by: java.sql.SQLException: No suitable driver found for
> jdbc:mysql://host/hive?createDatabaseIfNotExist=true
> at java.sql.DriverManager.getConnection(DriverManager.java:689)
> at java.sql.DriverManager.getConnection(DriverManager.java:247)
> at
> org.apache.hive.beeline.HiveSchemaHelper.getConnectionToMetastore(HiveSchemaHelper.java:73)
> ... 11 more
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
