Quicksql
Quicksql copied to clipboard
A Flexible, Fast, Federated(3F) SQL Analysis Middleware for Multiple Data Sources
tpc-ds27.sql select i_item_id, s_state, grouping(s_state) g_state, avg(ss_quantity) agg1, avg(ss_list_price) agg2, avg(ss_coupon_amt) agg3, avg(ss_sales_price) agg4 from store_sales, customer_demographics, date_dim, store, item where ss_sold_date_sk = d_date_sk and ss_item_sk = i_item_sk and ss_store_sk...
Example: select user_id,order_value,order_id from lie_col lateral view explode(split(order_value,',')) num as order_id limit 10
Example: tpc-ds-38.sql **Try to divide INTERSECT logical node when quering mysql.** select count(*) from ( select distinct c_last_name, c_first_name, d_date from store_sales, date_dim, customer where store_sales.ss_sold_date_sk = date_dim.d_date_sk and store_sales.ss_customer_sk...
Federated compute cannot be performed when `JDBC Runner` is specified. Calcite's ability to query multiple data sources can be integrated into Quicksql, enabling Calcite to execute as a local calculation...
Bumps `jetty.version` from 9.2.19.v20160908 to 9.4.27.v20200227. Updates `jetty-server` from 9.2.19.v20160908 to 9.4.27.v20200227 Commits - [`a304fd9`](https://github.com/eclipse/jetty.project/commit/a304fd9f351f337e7c0e2a7c28878dd536149c6c) Updating to version 9.4.27.v20200227 - [`5b7472f`](https://github.com/eclipse/jetty.project/commit/5b7472f616ebd23efe02ba658dc1b1e5b4f0e3e7) Fixing setuid.mod to use specific version of jar -...
### Background Currently, mixed-query only supports the default push-down mode, which needs to be adjusted to the dynamic configuration. ### Requirements 1. Add a config param in Builder which is...
mysql and hive have high priority
Metadata collect and query load different jars