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)

Reply via email to