Tuesday, August 20, 2013
12:00 PM - 12:30 PM
|Level: ||Technical - Intermediate|
2013 is the year of that SQL meets Hadoop & NoSQL. There is a surprisingly good fit between thirty-something SQL and the upstart millennial data technologies. SQL helps you deliver faster value, improve integration with visualization and analytics tools, and bring your data to a larger audience.
Julian Hyde, author of Mondrian and Optiq, and a contributor to Apache Drill and Cascading Lingual, shows how to quickly build a SQL interface to a NoSQL system using the Optiq framework.
As a case study, he shows how Optiq has allowing Mondrian in-memory analysis engine (part of Pentaho's business intelligence suite) to leverage the memory and compute power of a cluster and pull data from hybrid SQL and NoSQL sources.
Julian Hyde is lead developer of Apache Calcite, and a contributor to Apache Hive, Apache Drill and Cascading. He wrote the Mondrian OLAP engine (Pentaho Analysis) and the book "Mondrian in Action". He is an architect at Hortonworks and lives in Berkeley, CA with his wife and two sons.