Note for readers – I wrote this patch a year back and it no longer works. Please treat this just as a reference code.
In this crisp post I would be talking about Drill's Cassandra Storage plugin which would enable us to query Cassandra via Apache Drill. That also means that we would be able to issue ANSI SQL queries on Cassandra which is not inherently supported on Cassandra.
That it we have finished with the Drill build and installation – and its time we can start using Drill.
Hit 'show schemas' to view existing schemas.
No we should be able to see the Drill web interface on localhost:8047.
Now its time we configure our Cassandra with Drill.
Go to the Storage page from top navigation bar & add a new plugin by name 'cassandra'. On the next page provide the details of your Cassandra installation.
Thats it. Enough work. Its playtime now.
Its time we can start querying Cassandra via Drill.
Go to the Query page from top navigation menu and Fire your Sql query on existing Cassandra tables.
Note: Make sure Cassandra is up and running.
Stop Sqlline and Restart if required.
Cool. Try some complex SQL now. Play Around.
Thats all for this post. Hope it was helpful.
"fatal: corrupt patch at line 3308".
Please help me out in achieving the cassandra querying through drill. Your help would be greatly appreciated.
Would you mind to point at what is the problem?
Please kindly point out what is the solution for above errors.
I'm having the exact same problem and I would like some help. Did this ever get resolved for you?
we could not compile it.