drillbit | Experiments with columns
kandi X-RAY | drillbit Summary
kandi X-RAY | drillbit Summary
Experiments with columns
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of drillbit
drillbit Key Features
drillbit Examples and Code Snippets
Community Discussions
Trending Discussions on drillbit
QUESTION
I'm using a zookeeper connection string to get a connection to a drill cluster. I would like to log which drillbit (hostname or IP address) I successfully connected to, but I can't find any property or method on the java.sql.Connection class to get this information.
I tried connection.getMetaData.getURL
, but that just returns the zookeeper connection string I used to get the connection (scala code below):
ANSWER
Answered 2021-Jun-23 at 19:33Don’t forget that you can ask these questions directly to the Apache Drill community on the drill mailing lists or slack channels. See https://drill.apache.org/community-resources/ for more details.
Specific to your question, check out the system tables (https://drill.apache.org/docs/querying-system-tables/). The sys.profiles_json table, in particular, seems to be the one that is likely to give you the information you need.
It is a generally pretty safe bet that if you can see the information that you need in the web interface for Drill that you will also be able to find that information in the system tables. Commonly, a quick scan of the docs and some trial queries will give you the info you need. Since the web interface is open source, you can also grovel the source code to figure out how the web interface gives you the pertinent info.
In particular, this query gives roughly what you are asking for:
QUESTION
I am trying to connect to Apache Drill from python using jaydebeapi
library.
I have turned on drill in embedded mode via drill-embedded
, and the web ui runs correctly in port 8047. Then, I am trying to connect via JDBC through a python script:
ANSWER
Answered 2020-Oct-07 at 08:43Thanks to @Luke Woodward suggestion, the problem was the port. For drill-embedded
there is no port to select. Below a full query example
QUESTION
I am trying to setup drillv1.18 running. Facing the error below.
The drill-override.conf points to the zookeeper which runs on port 12181. On starting in distributed mode, it fails with the following log output. But the embedded mode has no issues. It appears like permission issue, but both zookeeper, drill, zookeeper data-dir all are running under the same user.
...ANSWER
Answered 2020-May-11 at 15:58The issue here is with the zookeeper version. Perhaps you use 3.4.X version, but the current version of Drill requires 3.5.X. As a workaround, you may replace zookeeper jar in jars/ext/zookeeper-3.5.7.jar
and jars/ext/zookeeper-jute-3.5.7.jar
with the jars that corresponds to your zookeeper version.
QUESTION
I installed Drill(1.16 version) on 3 nodes and use distributed mode. Becuz when i implemented query(join multiple table), I want to distribute the memory usage.
But When I enter Drill Web UI, Only a drillbit that I access gives information about usage. other drillbit says Not Available
.
I wonder if distributed mode is working well or not.
Just for test, When I implement a query which joins 3 tables on different node(PostgreSQL), only single major fragment is created and performed.(that means single drillbit is working and does not distribute the memory usage)
This is Web UI. you can see the Not available
sign.
This is conf/drill-override.conf
...ANSWER
Answered 2020-Mar-10 at 20:28This issue was fixed in the scope of https://issues.apache.org/jira/browse/DRILL-7582 and https://issues.apache.org/jira/browse/DRILL-7619, so on the current master version, these metrics should be displayed.
As a workaround for older versions, you may update your /etc/hosts
file to map nodes IPs with their hostnames.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install drillbit
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page