[
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)
