Hi Nikhil, I think the issue is your host field. It’s been a while since we worked on the Cassandra plugin, but if I recall correctly, you only have to give it one IP address and the connection will discover the other hosts. Can you try that and report back? Best, — C
> On Aug 29, 2025, at 06:33, Nikhil Thallapally > <[email protected]> wrote: > > 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 > > > Error from sqlline > > > > 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 <http://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
signature.asc
Description: Message signed with OpenPGP
