Kognitio

Kognitio is a pioneer in the development of scale-out, in-memory software for big data analytics, providing an ultra-fast, high-concurrency SQL layer that allows modern BI and visualization tools to maintain performance, even when the data volume is large and the user count is high.

Kognitio puts standard SQL in front of your Hadoop cluster or data warehouse. On Hadoop it is a standard YARN application, which easily integrates with your existing Hadoop workflows.

It's also free to use on Hadoop: in production, in development, in testing, anywhere. For non-Hadoop data sources, can be installed on a standalone hardware infrastructure.