Hi Neeraja, Thanks for your clarifications.
Our use case is more or less like this: 1) Right now most of the data is in RDBMS (which make sense for related data and which have transactional properties) 2) Planning to move all read only data or user action/transaction history to No SQL (exploring different options and may end up with one or more as well depending on the use case) 3) To build a common platform to support interactive query and computation(for BI, Analytics and Reporting) on data from multiple sources (No SQL + RDBMS). For this, I am looking at Apache Spark or Drill. Thanks Ajay On Sun, Dec 7, 2014 at 10:47 AM, Neeraja Rentachintala < [email protected]> wrote: > 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 > > >
