Hi Ajay Welcome to the Drill forum. Below are my thoughts for some of your questions.
On Sat, Dec 6, 2014 at 7:19 PM, Ajay <[email protected]> wrote: > 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/Spark) (A common Query interface + > Computation engine) > | > No SQL databases (One or more. May be RDBMS directly too) (Only Read Only > access) > | (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? > [Neeraja] It actually depends on the specific use case. We see a number of users getting value from the current phase of the Drill release. However from a broader perspective, we consider Drill as not fully ready for production deployments. The stability/quality is improving rapidly with the monthly releases and we expect it to be production-ready in the next 2-3 months timeframe. 2) Can Drill SQL be used a query interface for Business Intelligence, > Analytics and Reporting (Dynamic and Real time querying) > [Neeraja] Drill comes with JDBC, ODBC drivers and a simple REST interface. So yes,you can connect to the BI/Analytics tools as well as custom apps through a low level APIs. > 3) Does Drill support only Hadoop, HBase and MongoDB currently? (Is there > RoadMap for other No SQL solutions)?. We may use Cassandra or CouchBase as > well. > [Neeraja] Drill supports file system (local or any distributed such as Hadoop, MapRFS, S3 etc), HBase , Hive and MongoDB. We recently saw a lot of interest in the Cassandra/Couchbase plugins and you can collaborate/contribute by connecting with interested folks on this group and drill-dev list. 4) Does Drill supports RDBMS too?. We can have a single interface to > drill/pull out data from multiple data sources? > [Neeraja] Not at this point, but again there is a lot of interest on this and you are welcome to contribute as well. > 5) Any recommendations (not limited to usage of Drill) for our specific > requirement described above. > [Neeraja] I am curious to know what kinds of data you have in RDBMS, NoSQL and Hadoop and how you are looking to leverage Drill as common query layer. It would be good if you can share more detail on your use case. > Thanks > Ajay Garga >
