drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2416) Zookeeper in sqlline connection string does not override the entry from drill-override.conf
Date Tue, 17 Mar 2015 23:11:38 GMT

    [ 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)

Mime
View raw message