You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Kunal Khatua (JIRA)" <ji...@apache.org> on 2015/04/30 04:51:05 UTC
[jira] [Reopened] (DRILL-2811) Need option to specify Drillbit in
the connection URI to connect to that specific Drillbit
[ https://issues.apache.org/jira/browse/DRILL-2811?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kunal Khatua reopened DRILL-2811:
---------------------------------
Flag isn't being honoured. Looks like the drillbit specific code path isn't being executed. Are we defaulting to the ZK even in the presence of the property?
[root@ucs-node1 drillTester]# ./testOnNode.sh 10.10.120.103 "select * from sys.drillbits where \`current\`"
Start time of the Drill Query 19:41:33
sqlline version 1.1.6
0: jdbc:drill:schema=dfs.parquet> select * from sys.drillbits where `current`
. . . . . . . . . . . . . . . . > +------------+------------+--------------+------------+------------+
| hostname | user_port | control_port | data_port | current |
+------------+------------+--------------+------------+------------+
| ucs-node2.perf.lab | 31010 | 31011 | 31012 | true |
+------------+------------+--------------+------------+------------+
1 row selected (1.242 seconds)
0: jdbc:drill:schema=dfs.parquet> Closing: org.apache.drill.jdbc.DrillJdbc41Factory$DrillJdbc41Connection
Exit code 1
Query time is: 6 sec
[root@ucs-node1 drillTester]# ./testOnNode.sh 10.10.120.103 "select * from sys.drillbits where \`current\`"
Start time of the Drill Query 19:41:49
sqlline version 1.1.6
0: jdbc:drill:schema=dfs.parquet> select * from sys.drillbits where `current`
. . . . . . . . . . . . . . . . > +------------+------------+--------------+------------+------------+
| hostname | user_port | control_port | data_port | current |
+------------+------------+--------------+------------+------------+
| ucs-node7.perf.lab | 31010 | 31011 | 31012 | true |
+------------+------------+--------------+------------+------------+
1 row selected (0.206 seconds)
0: jdbc:drill:schema=dfs.parquet> Closing: org.apache.drill.jdbc.DrillJdbc41Factory$DrillJdbc41Connection
Exit code 1
Query time is: 7 sec
The script opens the connection as follows:
/opt/mapr/drill/specter-drill/bin/sqlline -u "jdbc:drill:schema=dfs.parquet;drillbit=10.10.120.103"
> Need option to specify Drillbit in the connection URI to connect to that specific Drillbit
> ------------------------------------------------------------------------------------------
>
> Key: DRILL-2811
> URL: https://issues.apache.org/jira/browse/DRILL-2811
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
> Affects Versions: 0.9.0
> Environment: RHEL 6.4
> Reporter: Kunal Khatua
> Assignee: Parth Chandra
> Priority: Blocker
> Fix For: 1.0.0
>
> Attachments: DRILL-2811.2.patch.diff, DRILL-2811.3.patch.diff
>
>
> DRILL-2613 introduced randomization in selection of the Drillbits from the list provided by Zookeeper. It would be nice to have the ability to specify which Drillbit to connect to by specifying within the JDBC Connection.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)