Apache Drill 1.0 – Schema-Free SQL Query Engine for Hadoop and NoSQL
1–10 of 31 posts
Re: Apache Drill 1.0 – Schema-Free SQL Query Engine for Hadoop and NoSQL
#2Nice
Re: Apache Drill 1.0 – Schema-Free SQL Query Engine for Hadoop and NoSQL
#3Congratulations to the Apache Drill team, Drill's awesome.
Re: Apache Drill 1.0 – Schema-Free SQL Query Engine for Hadoop and NoSQL
#4Wow. That looks pretty amazing.
Re: Apache Drill 1.0 – Schema-Free SQL Query Engine for Hadoop and NoSQL
#5How does Apache Drill compare to Power Pivot/ Power Query? As far as I understand, both aim to solve the problem if heterogeneous data sources. What I don't understand is how they differ.
Re: Apache Drill 1.0 – Schema-Free SQL Query Engine for Hadoop and NoSQL
#6@polskibus,
Heterogeneous can mean different things. Drill attacks problems where there is no well defined schema. Other heterogeneous data source tools are more about accessing different data sources, all relational.
To do what Drill does requires that SQL be changed from a statically typed language to a dynamically typed language that generates code on the fly. Drill also does this in parallel.
Re: Apache Drill 1.0 – Schema-Free SQL Query Engine for Hadoop and NoSQL
#7This is sort of similar to the Dremel tool used internally at Google, right? They might mention this on their web site.
Re: Apache Drill 1.0 – Schema-Free SQL Query Engine for Hadoop and NoSQL
#8I prefer the term "schema-on-read" to "schema-free" or "schema-less". One needs to correctly understand the implications of the fact that all data has SOME schema and that if it changes you need to be able to read the old and new.
Re: Apache Drill 1.0 – Schema-Free SQL Query Engine for Hadoop and NoSQL
#9I prefer the term "schema-on-read" to "schema-free" or "schema-less". One needs to correctly understand the implications of the fact that all data has SOME schema and that if it changes you need to be able to read the old and new.
I agree. My employer Treasure Data (http://www.treasuredata.com/product) has been offering exactly this (SQL on schema-on-read data) for the last three years as a cloud service. But in reality, people "get" schema-less much better than "schema-on-read" thanks to all the marketing that MongoDB folks have done for "schemaless".
Re: Apache Drill 1.0 – Schema-Free SQL Query Engine for Hadoop and NoSQL
#10.
I wish I had Drill a few years ago, but even more nowadays.
Drill and Dremel approach to data querying is really interesting in the sense that it's the tool that changes the 'lenses' on how it sees the data, rather than you have to re-shape the data for how would you like to see it. ++glasses && --photoshop;
Thanks Drill team!