Dear Team,
Requesting to assist integrating Apache drill with a 4 node Cassandra cluster.
Problem statement: Unable to query data from Apache Drill UI and CLI from
Cassandra database.
Description
We have set-up a 4 node Cassandra cluster which is running perfectly fine and
able to query the data from both cqlsh and DBeaver query tool.
However after installing apache drill on the same 4 nodes as a cluster, failing
to query the Cassandra DB post configuring the required storage plugins.
PFB the required configurations:
storage-plugins-override.conf
"storage": {
cassandra: {
type: "cassandra",
host: "10.125.64.202,10.125.64.203,10.125.64.204,10.125.64.205",
port: 9042,
enabled: true
}
}
drill-override.conf
drill.exec: {
cluster-id: "drill-cluster",
zk.connect:
"h-medi-p-vemm1:2181,h-medi-p-vemm2:2181,h-medi-p-vemm3:2181,h-medi-p-vemm4:2181"
}
Error from Drill UI
[cid:[email protected]]
Error from sqlline
[cid:[email protected]]
Apache Drill version: Apache Drill 1.22.0
Cassandra version: Cassandra 4.1.3
Please note there are no firewall and connectivity issues among these 4 nodes.
Required ports are open and accessible across the machines.
Thanks in advance
Best Regards,
Nikhil Thallapally
Expert Solution Architect/Service Enablement & Mediation
+971-508123794
e&
________________________________
Emirates Telecommunications Group Company PJSC (Etisalat Group, e&) is a Public
Joint Stock Company registered in the UAE.
The content of this email (including its attachments) is private and contains
confidential information. If you are not the intended recipient and you have
received this email in error, any disclosure, copying, distribution or use of
its contents is strictly prohibited, and you should please notify the sender
immediately and then delete it permanently (including any attachments) from
your system. eand does not conclude agreements through email communications and
nothing in this email shall be construed or interpreted as binding eand or
creating any obligation on eand.
eand has taken reasonable precautions to ensure no viruses are present in this
email, however eand cannot accept liability and responsibility for any loss or
damage sustained as a result of computer viruses or malwares. The recipient
must ensure that the email (and its attachments) are virus free.
Information on how we use personal data and about how data subject rights can
be exercised is available on our website here [eand.com]. As a controller of
personal data, we take great care over how we collect, use and protect that
information. If you have any queries in relation to our processing of personal
data you can contact us at +97126283333
