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)