You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Parth Chandra (JIRA)" <ji...@apache.org> on 2015/04/06 20:00:13 UTC
[jira] [Updated] (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:all-tabpanel ]
Parth Chandra updated DRILL-2487:
---------------------------------
Fix Version/s: (was: 1.0.0)
1.1.0
> 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)