[
https://issues.apache.org/jira/browse/DRILL-2416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14366279#comment-14366279
]
Krystal commented on DRILL-2416:
--------------------------------
I opened drill-2487 for the ":" vs ";" issue.
For this issue, here is my drill-override.conf content:
drill.exec: {
cluster-id: "krystal-drillbits",
zk.connect: "10.10.100.113:5181,10.10.100.114:5181,10.10.100.115:5181"
}
>From sqlline, connecting to the hive schema using the same zk info:
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 |
| hive.default | promotion |
| hive.default | voter |
| hive.default | orc_create_people_staging |
| hive.default | m7_students |
Leaving the drill-override content the same, I updated the zookeeper connection
to point to a remote drillbit:
root@qa-node113:~# /opt/drill/bin/sqlline -u
'jdbc:drill:schema=hive;zk=10.10.100.56: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
No DrillbitEndpoint can be found
sqlline version 1.1.6
If I then update the drill-override.conf on the client node to contain the info
of the remote drillbit, then I was able to successfully connect:
drill.exec: {
cluster-id: "qa-node56-drillbits",
zk.connect: "10.10.100.56:5181"
}
root@qa-node113:~# /opt/drill/bin/sqlline -u
'jdbc:drill:schema=hive;zk=10.10.100.56: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 | bit_table |
| hive.default | stinyint_table |
| hive.default | string_table |
| hive.default | real_table |
| hive.default | interval_table |
| hive.default | binary_table |
| hive.default | emp |
| hive.default | bigint_table |
> Zookeeper in sqlline connection string does not override the entry from
> drill-override.conf
> --------------------------------------------------------------------------------------------
>
> Key: DRILL-2416
> URL: https://issues.apache.org/jira/browse/DRILL-2416
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - CLI
> Affects Versions: 0.8.0
> Reporter: Krystal
> Assignee: Daniel Barclay (Drill)
>
> git.commit.id=f658a3c513ddf7f2d1b0ad7aa1f3f65049a594fe
> On the sqlline jdbc connection string, I changed the zookeeper ip to point to
> another cluster; however, sqlline kept connecting to the drillbits specified
> in drill-override.conf. I updated the drill-override.conf with the other
> zookeeper information, then I was able to successfully connected to the
> drillbits on a remote cluster.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
