You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2015/03/17 23:59:38 UTC
[jira] [Created] (DRILL-2487) Schema is ignored when using ":"
between schema and zk on sqlline connection string
Krystal created DRILL-2487:
------------------------------
Summary: 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)