This repository has been archived by the owner on Mar 30, 2021. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 92
JavaScript Code Generator: Pushing down complex GB
jpullokkaran edited this page Apr 25, 2016
·
1 revision
With 0.0.5 release we are adding support for complex group by expressions using JavaScript Extraction Function. Sparklinedata would convert complex group by expressions to JavaScript using JavaScript Code Generator. Before to 0.0.5 complex group by expressions used to be executed in Spark; by pushing complex group by down to Druid the performance of the solution improves 2-3 times.
Following is an example of such expressions: select sum(c_acctbal) as bal from orderLineItemPartSupplier group by (substr(CAST(Date_Add(TO_DATE(CAST(CONCAT(TO_DATE(o_orderdate), 'T00:00:00.000') AS TIMESTAMP)), 5) AS TIMESTAMP), 0, 10))
- Overview
- Quick Start
-
User Guide
- [Defining a DataSource on a Flattened Dataset](https://github.com/SparklineData/spark-druid-olap/wiki/Defining-a Druid-DataSource-on-a-Flattened-Dataset)
- Defining a Star Schema
- Sample Queries
- Approximate Count and Spatial Queries
- Druid Datasource Options
- Sparkline SQLContext Options
- Using Tableau with Sparkline
- How to debug a Query Plan?
- Running the ThriftServer with Sparklinedata components
- [Setting up multiple Sparkline ThriftServers - Load Balancing & HA] (https://github.com/SparklineData/spark-druid-olap/wiki/Setting-up-multiple-Sparkline-ThriftServers-(Load-Balancing-&-HA))
- Runtime Views
- Sparkline SQL extensions
- Sparkline Pluggable Modules
- Dev. Guide
- Reference Architectures
- Releases
- Cluster Spinup Tool
- TPCH Benchmark