4 ms·
Disclosure, I am a Drill committer. If you are looking for an open source technology to meet this need, Apache Drill is a distributed SQL engine that can talk
by jaltekruse 11y ago
Disclosure, I am a Drill committer.
If you are looking for an open source technology to meet this need, Apache Drill is a distributed SQL engine that can talk to multiple datasources and make them available in a single namespace. Joins across sources are supported and can actually perform well when you use enough nodes for your data volume.
Because Drill exposes ODBC and JDBC interfaces, it can very easily be used with BI tools to expose all kinds of data to analysts.
The architecture is fully pluggable so anyone can write a connector to a new datastore and just include it on the classpath when starting the cluster. In the current 1.2 release Drill can connect to any database that exposes JDBC, like MySQL, Postgres, Oracle, as well as a number of non-relational datastores like HDFS, MongoDB and HBase.
https://drill.apache.org/ https://drill.apache.org/
- salsakran 11y agoDumb question, but what dialect of SQL does the JDBC interface use?
- jaltekruse 11y agoDrill uses standards compliant SQL for flat data. To work with all of the non-relational stores Drill supports complex types like maps and lists. The syntax for working with this complex data is the same javascript, i.e. a.b.c[3], so this is a compliant extension of SQL, but is non-standard.