In resource-intensive systems, even though SQL on Hadoop is being improved constantly, queries will compete for runtime resources and it takes hours to return when the work load is high. SQL on Hadoop is improving continuously, but it's still common to wait minutes or even a couple hours for one single query to return, especially when the dataset is huge. Most of these systems are resource-intensive where queries compete for runtime resources and performance declines when the workload is high.
To solve this problem, Kyligence Analytics Platform (KAP) enables interactive analytics with sub-second query latency on massive dataset. KAP is a leading big data intelligence platform powered by Apache Kylin. It enables interactive analytics with sub-second query latency, even on massive data-set, and is widely adopted by enterprises such as Lenovo, China Mobile, etc.. We are happy to announce that the Kyligence team and Azure HDInsight team have worked closely with each other to bring OLAP capabilities to HDInsight, and KAP is now available on Azure HDInsight as an HDInsight application.
This is the getting started video recorded by Kyligence team, and please take a look at the Azure blog post (https://azure.microsoft.com/en-us/blog/bring-interactive-analytics-to-azure-kyligence-analytics-platform-enables-sub-second-query-on-hdinsight/) for more details.