Modifying the external database is an exception

[francis-du]

Issue : Modifying the external database is an exception

QSQL Version : 0.5

OS : Centos 7

Action:

1. Modify the metadata.properties configuration file:
   vim metadata.properties
2. Initialize the metabase:
   metadata --dbType mysql --action init
3. Select table from mysql DB
   qsql -e 'select * from test_table_sqoop1'

Exception :

2019-01-17 14:59:10,718 [main] INFO - Parsing table names has finished, you will query tables: [test.test_table_sqoop1] Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: path to '///usr/local/qsql-0.5/bin/../sqlite/schema.db': '/usr/local/qsql-0.5/bin/../sqlite' does not exist at com.qihoo.qsql.metadata.MetadataClient.createConnection(MetadataClient.java:246) at com.qihoo.qsql.metadata.MetadataClient.<init>(MetadataClient.java:38) at com.qihoo.qsql.metadata.MetadataPostman$MetadataFetcher.transformSchemaFormat(MetadataPostman.java:86) at com.qihoo.qsql.metadata.MetadataPostman$MetadataFetcher.access$100(MetadataPostman.java:74) at com.qihoo.qsql.metadata.MetadataPostman.lambda$getAssembledSchema$0(MetadataPostman.java:50) at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193) at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382) at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708) at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499) at com.qihoo.qsql.metadata.MetadataPostman.getAssembledSchema(MetadataPostman.java:52) at com.qihoo.qsql.launcher.ExecutionDispatcher.tryToExecuteQueryDirectly(ExecutionDispatcher.java:111) at com.qihoo.qsql.launcher.ExecutionDispatcher.main(ExecutionDispatcher.java:71) Caused by: java.sql.SQLException: path to '///usr/local/qsql-0.5/bin/../sqlite/schema.db': '/usr/local/qsql-0.5/bin/../sqlite' does not exist at org.sqlite.core.CoreConnection.open(CoreConnection.java:192) at org.sqlite.core.CoreConnection.<init>(CoreConnection.java:76) at org.sqlite.jdbc3.JDBC3Connection.<init>(JDBC3Connection.java:26) at org.sqlite.jdbc4.JDBC4Connection.<init>(JDBC4Connection.java:24) at org.sqlite.SQLiteConnection.<init>(SQLiteConnection.java:45) at org.sqlite.JDBC.createConnection(JDBC.java:114) at org.sqlite.JDBC.connect(JDBC.java:88) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:270) at com.qihoo.qsql.metadata.MetadataClient.createConnection(MetadataClient.java:242) ... 14 more

[Functor10]

Thanks for your feedback and PR, Francis!!

[lianneli]

Thanks for your feedback, and the PR has been accepted.