[jira] [Commented] (DRILL-2487) Schema is ignored when using ":" between schema and zk on sqlline connection string

["Daniel Barclay (Drill) (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14574892#comment-14574892 ] 

Daniel Barclay (Drill) commented on DRILL-2487:
-----------------------------------------------

When you used a colon between the {{schema}} parameter assignment and the {{zk}} parameter assignment, did the {{zk}} parameter assignment seem to take effect?


Since the inter-assignment separator seems to be semicolon, it's not surprising that using a colon instead would cause a problem with the schema setting.

However, I would also expert there to be a problem with the {{zk}} setting.  (Instead of having a {{schema}} setting of "hive" and a {{zk}} setting of "10.10.100.113:5181", you would have a {{schema}} setting of "hive:zk=10.10.100.113:5181" and not have _any_ {{zk}} setting.)


> Schema is ignored when using ":" between schema and zk on sqlline connection string 
> ------------------------------------------------------------------------------------
>
>                 Key: DRILL-2487
>                 URL: https://issues.apache.org/jira/browse/DRILL-2487
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - CLI
>    Affects Versions: 0.8.0
>            Reporter: Krystal
>            Assignee: Daniel Barclay (Drill)
>            Priority: Minor
>             Fix For: 1.1.0
>
>
> git.commit.id=ae2053d2a078a40033a140f2dfaeef802a5e8254
> Invoking sqlline using a ":" between the schema and zk causes sqlline not to connect the specified schema.  For example:
> root@qa-node113:~# /opt/drill/bin/sqlline -u 'jdbc:drill:schema=hive:zk=10.10.100.113:5181'
> touch: cannot touch `/var/log/drill/sqlline.log': No such file or directory
> Drill log directory /var/log/drill does not exist or is not writable, defaulting to /opt/drill/log
> sqlline version 1.1.6
> 0: jdbc:drill:schema=hive:zk=10.10.100.113:51> show tables;
> Query failed: RelConversionException: No schema selected. Select a schema using 'USE schema' command
> If I put a ";" between schema and zk, then sqlline connects to the specified schema:
> root@qa-node113:~# /opt/drill/bin/sqlline -u 'jdbc:drill:schema=hive;zk=10.10.100.113:5181'
> touch: cannot touch `/var/log/drill/sqlline.log': No such file or directory
> Drill log directory /var/log/drill does not exist or is not writable, defaulting to /opt/drill/log
> sqlline version 1.1.6
> 0: jdbc:drill:schema=hive> show tables;
> +--------------+------------+
> | TABLE_SCHEMA | TABLE_NAME |
> +--------------+------------+
> | hive.default | t2         |
> | hive.default | episodes_partitioned |
> | hive.default | store      |
> | hive.default | store_sales |
>  



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)