You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Daniel Barclay (Drill) (JIRA)" <ji...@apache.org> on 2015/03/18 02:59:38 UTC
[jira] [Commented] (DRILL-2487) Schema is ignored when using ":"
between schema and zk on sqlline connection string
[ https://issues.apache.org/jira/browse/DRILL-2487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14366484#comment-14366484 ]
Daniel Barclay (Drill) commented on DRILL-2487:
-----------------------------------------------
> Invoking sqlline using a ":" between the schema and zk causes sqlline not to connect the specified schema.
Is doing that supposed to work?
Where is the specification or documentation of what the syntax of Drill JDBC URLs is supposed to be?
> 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)
>
> 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)