Hello,
I am Ajay Garga, work for an ecommerce company. Currently we are looking at
building a Datawarehouse platform as described below:
DW as a Service
|
REST API
|
SQL On No SQL (Drill/Pig/Hive)
|
No SQL databases (One or more. May be RDBMS directly too)
| (Bulk load)
My SQL Database
I wish to get a few clarifications on Apache Drill as follows:
1) Is Drill(latest stable release) Production ready?. Can we use Drill for
SQL on No SQL or do we need to mix them with Pig/Hive or any other for any
reason?
2) Can Drill SQL be used a query interface for Business Intelligence,
Analytics and Reporting
3) Is Drill supports only Hadoop, HBase and MongoDB currently? (Is there
RoadMap for other No SQL solutions)?. We may use Cassandra or CouchBase as
well.
4) Is Drill supports RDBMS too?. We can have a single interface to
drill/pull out data from multiple data sources?
5) Any recommendations(not limited to usage of Drill) for our specific
requirement described above.
Thanks
Ajay Garga
