svn commit: r1852529 - in /kylin/site: cn/docs/tutorial/sql_reference.html docs/index.html docs/tutorial/sql_reference.html feed.xml
Author: lidong Date: Wed Jan 30 15:11:38 2019 New Revision: 1852529 URL: http://svn.apache.org/viewvc?rev=1852529=rev Log: minor, update doc index page Modified: kylin/site/cn/docs/tutorial/sql_reference.html kylin/site/docs/index.html kylin/site/docs/tutorial/sql_reference.html kylin/site/feed.xml Modified: kylin/site/cn/docs/tutorial/sql_reference.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/sql_reference.html?rev=1852529=1852528=1852529=diff == --- kylin/site/cn/docs/tutorial/sql_reference.html (original) +++ kylin/site/cn/docs/tutorial/sql_reference.html Wed Jan 30 15:11:38 2019 @@ -166,7 +166,7 @@ var _hmt = _hmt || []; SQL å¿«éåè - Kylin æ¯ä½¿ç¨ Calcite è¿è¡æ¥è¯¢çï¼ååä¸ Kylin æ¯æææ Calcite è½å¤è¯å«çè¯å¥ã + Apache Kylin ä½¿ç¨ Apache Calcite å SQL 解æåä¼åãä½ä¸ºä¸æ¬¾ OLAP å¼æ, Kylin æ¯æ SELECT æä½ï¼èä¸æ¯æå ¶å®æä½ä¾å¦ INSERTï¼UPDATE å DELETEï¼å æ¤ Kylin ç SQL è¯æ³æ¯ Apache Calcite æ¯æè¯æ³çä¸ä¸ªåéãæ¬æåä¸¾äº Kylin æ¯æç SQL è¯æ³ãå½æ°ä»¥åæ°æ®ç±»åï¼ä½å¯è½å¹¶ä¸å®æ´ãæ¨å¯ä»¥æ¥ç https://calcite.apache.org/docs/reference.html;>Calcite SQL reference 以äºè§£æ´å¤å 容ã è¯æ³ QUERY SYNTAX Modified: kylin/site/docs/index.html URL: http://svn.apache.org/viewvc/kylin/site/docs/index.html?rev=1852529=1852528=1852529=diff == --- kylin/site/docs/index.html (original) +++ kylin/site/docs/index.html Wed Jan 30 15:11:38 2019 @@ -6249,7 +6249,7 @@ var _hmt = _hmt || []; Apache Kylin⢠is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop supporting extremely large datasets. -This is the document for the latest released version (v2.5). Document of prior versions: +This is the document for the latest released version (v2.5 v2.6). Document of prior versions: * v2.4 document * v2.3 document * v2.1 and v2.2 document @@ -6272,7 +6272,7 @@ var _hmt = _hmt || []; Web Interface Cube Wizard Cube Build and Job Monitoring - SQL reference: by Apache Calcite + SQL reference Build Cube with Streaming Data Build Cube with Spark Engine Cube Build Tuning Modified: kylin/site/docs/tutorial/sql_reference.html URL: http://svn.apache.org/viewvc/kylin/site/docs/tutorial/sql_reference.html?rev=1852529=1852528=1852529=diff == --- kylin/site/docs/tutorial/sql_reference.html (original) +++ kylin/site/docs/tutorial/sql_reference.html Wed Jan 30 15:11:38 2019 @@ -6245,7 +6245,7 @@ var _hmt = _hmt || []; - Kylin uses Calcite for the query. In principle, Kylin supports all statements that Calcite recognizes. + Apache Kylin relies on Apache Calcite to parse and optimize the SQL statements. As an OLAP engine, Kylin supports SELECT statements, while doesnât support others like INSERT, UPDATE and DELETE operations in SQL, so Kylinâs SQL grammer is a subset of Apache Calcite. This page lists the SQL grammar, the functions and the basic data types that Kylin supports. You can also check https://calcite.apache.org/docs/reference.html;>Calcite SQL reference for more detailed info. Grammar Modified: kylin/site/feed.xml URL: http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1852529=1852528=1852529=diff == --- kylin/site/feed.xml (original) +++ kylin/site/feed.xml Wed Jan 30 15:11:38 2019 @@ -19,8 +19,8 @@ Apache Kylin Home http://kylin.apache.org/ http://kylin.apache.org/feed.xml; rel="self" type="application/rss+xml"/> -Wed, 30 Jan 2019 05:59:20 -0800 -Wed, 30 Jan 2019 05:59:20 -0800 +Wed, 30 Jan 2019 07:03:13 -0800 +Wed, 30 Jan 2019 07:03:13 -0800 Jekyll v2.5.3
[kylin] branch document updated: minor, update doc index page
This is an automated email from the ASF dual-hosted git repository. shaofengshi pushed a commit to branch document in repository https://gitbox.apache.org/repos/asf/kylin.git The following commit(s) were added to refs/heads/document by this push: new 63c15bb minor, update doc index page 63c15bb is described below commit 63c15bb7dae93795f905ce82dbe37f2cfa59d554 Author: shaofengshi AuthorDate: Wed Jan 30 22:50:44 2019 +0800 minor, update doc index page --- website/_docs/index.md | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/website/_docs/index.md b/website/_docs/index.md index 4762913..bb6cd8e 100644 --- a/website/_docs/index.md +++ b/website/_docs/index.md @@ -11,7 +11,7 @@ Welcome to Apache Kylin™: Extreme OLAP Engine for Big Data Apache Kylin™ is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop supporting extremely large datasets. -This is the document for the latest released version (v2.5). Document of prior versions: +This is the document for the latest released version (v2.5 & v2.6). Document of prior versions: * [v2.4 document](/docs24) * [v2.3 document](/docs23) * [v2.1 and v2.2 document](/docs21/) @@ -33,7 +33,7 @@ Tutorial 2. [Web Interface](tutorial/web.html) 3. [Cube Wizard](tutorial/create_cube.html) 4. [Cube Build and Job Monitoring](tutorial/cube_build_job.html) -5. [SQL reference: by Apache Calcite](tutorial/sql_reference.html) +5. [SQL reference](tutorial/sql_reference.html) 6. [Build Cube with Streaming Data](tutorial/cube_streaming.html) 7. [Build Cube with Spark Engine](tutorial/cube_spark.html) 8. [Cube Build Tuning](tutorial/cube_build_performance.html)
[kylin] branch document updated: minor update on sql_reference doc
This is an automated email from the ASF dual-hosted git repository. shaofengshi pushed a commit to branch document in repository https://gitbox.apache.org/repos/asf/kylin.git The following commit(s) were added to refs/heads/document by this push: new eacfb18 minor update on sql_reference doc eacfb18 is described below commit eacfb18d9d56bce7f22b5f7bec0cde9ddf3f Author: shaofengshi AuthorDate: Wed Jan 30 22:47:02 2019 +0800 minor update on sql_reference doc --- website/_docs/tutorial/sql_reference.cn.md | 2 +- website/_docs/tutorial/sql_reference.md| 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/website/_docs/tutorial/sql_reference.cn.md b/website/_docs/tutorial/sql_reference.cn.md index 263c740..d645fff 100644 --- a/website/_docs/tutorial/sql_reference.cn.md +++ b/website/_docs/tutorial/sql_reference.cn.md @@ -5,7 +5,7 @@ categories: tutorial permalink: /cn/docs/tutorial/sql_reference.html --- -Kylin 是使用 Calcite 进行查询的,原则上 Kylin 支持所有 Calcite 能够识别的语句。 +Apache Kylin 使用 Apache Calcite 做 SQL 解析和优化。作为一款 OLAP 引擎, Kylin 支持 `SELECT` 操作,而不支持其它操作例如 `INSERT`,`UPDATE` 和 `DELETE`,因此 Kylin 的 SQL 语法是 Apache Calcite 支持语法的一个子集。本文列举了 Kylin 支持的 SQL 语法、函数以及数据类型,但可能并不完整。您可以查看 [Calcite SQL reference](https://calcite.apache.org/docs/reference.html) 以了解更多内容。 ## 语法 [QUERY SYNTAX](#QUERYSYNTAX) diff --git a/website/_docs/tutorial/sql_reference.md b/website/_docs/tutorial/sql_reference.md index 4af4709..d352773 100644 --- a/website/_docs/tutorial/sql_reference.md +++ b/website/_docs/tutorial/sql_reference.md @@ -5,7 +5,7 @@ categories: tutorial permalink: /docs/tutorial/sql_reference.html --- -Kylin uses Calcite for the query. In principle, Kylin supports all statements that Calcite recognizes. +Apache Kylin relies on Apache Calcite to parse and optimize the SQL statements. As an OLAP engine, Kylin supports `SELECT` statements, while doesn't support others like `INSERT`, `UPDATE` and `DELETE` operations in SQL, so Kylin's SQL grammer is a subset of Apache Calcite. This page lists the SQL grammar, the functions and the basic data types that Kylin supports. You can also check [Calcite SQL reference](https://calcite.apache.org/docs/reference.html) for more detailed info. ## Grammar
svn commit: r1852525 [15/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/
Modified: kylin/site/docs21/gettingstarted/events.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/gettingstarted/events.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs21/gettingstarted/events.html (original) +++ kylin/site/docs21/gettingstarted/events.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5131,6 +5345,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/docs21/gettingstarted/faq.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/gettingstarted/faq.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs21/gettingstarted/faq.html (original) +++ kylin/site/docs21/gettingstarted/faq.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5131,6 +5345,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/docs21/gettingstarted/terminology.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/gettingstarted/terminology.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs21/gettingstarted/terminology.html (original) +++ kylin/site/docs21/gettingstarted/terminology.html Wed Jan 30 14:13:48 2019
svn commit: r1852525 [18/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/
Modified: kylin/site/docs23/tutorial/cube_streaming.html URL: http://svn.apache.org/viewvc/kylin/site/docs23/tutorial/cube_streaming.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs23/tutorial/cube_streaming.html (original) +++ kylin/site/docs23/tutorial/cube_streaming.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5131,6 +5345,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/docs23/tutorial/flink.html URL: http://svn.apache.org/viewvc/kylin/site/docs23/tutorial/flink.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs23/tutorial/flink.html (original) +++ kylin/site/docs23/tutorial/flink.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5131,6 +5345,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/docs23/tutorial/hue.html URL: http://svn.apache.org/viewvc/kylin/site/docs23/tutorial/hue.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs23/tutorial/hue.html (original) +++ kylin/site/docs23/tutorial/hue.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; +
svn commit: r1852525 [1/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/0
Author: lidong Date: Wed Jan 30 14:13:48 2019 New Revision: 1852525 URL: http://svn.apache.org/viewvc?rev=1852525=rev Log: KYLIN-3766 Merge docs for Query SQL Grammar, Function and Data Type Added: kylin/site/cn/docs/tutorial/sql_reference.html kylin/site/docs/tutorial/sql_reference.html Modified: kylin/site/about/index.html kylin/site/assets/css/docs.css kylin/site/blog/2015/01/25/introduce-data-model/index.html kylin/site/blog/2015/06/10/release-v0.7.1-incubating/index.html kylin/site/blog/2015/08/13/kylin-dictionary/index.html kylin/site/blog/2015/08/15/fast-cubing/index.html kylin/site/blog/2015/09/06/release-v1.0-incubating/index.html kylin/site/blog/2015/09/09/fast-cubing-on-spark/index.html kylin/site/blog/2015/09/25/hybrid-model/index.html kylin/site/blog/2015/10/14/Apache-Kylin-Meetup/index.html kylin/site/blog/2015/10/25/release-v1.1-incubating/index.html kylin/site/blog/2015/12/23/release-v1.2/index.html kylin/site/blog/2015/12/25/support-powerbi-tableau9/index.html kylin/site/blog/2016/02/03/streaming-cubing/index.html kylin/site/blog/2016/02/18/new-aggregation-group/index.html kylin/site/blog/2016/03/16/release-v1.3.0/index.html kylin/site/blog/2016/03/17/release-v1.5.0/index.html kylin/site/blog/2016/03/19/approximate-topn-measure/index.html kylin/site/blog/2016/04/12/release-v1.5.1/index.html kylin/site/blog/2016/05/26/release-v1.5.2/index.html kylin/site/blog/2016/05/29/raw-measure-in-kylin/index.html kylin/site/blog/2016/06/10/diagnosis-tool/index.html kylin/site/blog/2016/06/10/standalone-hbase-cluster/index.html kylin/site/blog/2016/07/28/release-v1.5.3/index.html kylin/site/blog/2016/08/01/count-distinct-in-kylin/index.html kylin/site/blog/2016/08/27/query-metrics-in-kylin/index.html kylin/site/blog/2016/10/18/new-nrt-streaming/index.html kylin/site/blog/2016/11/16/window-function/index.html kylin/site/blog/2016/11/28/intersect-count/index.html kylin/site/blog/2016/12/04/release-v1.6.0/index.html kylin/site/blog/2017/02/23/by-layer-spark-cubing/index.html kylin/site/blog/2017/02/25/v2.0.0-beta-ready/index.html kylin/site/blog/2017/04/01/percentile-measure/index.html kylin/site/blog/2017/07/21/Improving-Spark-Cubing/index.html kylin/site/blog/2018/01/01/kylin-and-superset/index.html kylin/site/blog/2018/03/04/release-v2.3.0/index.html kylin/site/blog/2018/05/08/redash-kylin-plugin-strikingly/index.html kylin/site/blog/2018/07/16/Star-Schema-Benchmark-on-Apache-Kylin/index.html kylin/site/blog/2018/09/20/release-v2.5.0/index.html kylin/site/blog/2018/12/12/why-did-meituan-develop-kylin-on-druid-part1-of-2/index.html kylin/site/blog/2019/01/16/introduce-data-source-sdk-v2.6.0/index.html kylin/site/blog/2019/01/17/cisco-throughput-5x/index.html kylin/site/blog/2019/01/18/release-v2.6.0/index.html kylin/site/blog/index.html kylin/site/cn/blog/2015/10/25/release-v1.1-incubating/index.html kylin/site/cn/blog/2015/12/23/release-v1.2/index.html kylin/site/cn/blog/2015/12/25/support-powerbi-tableau9/index.html kylin/site/cn/blog/2016/03/16/release-v1.3.0/index.html kylin/site/cn/blog/2016/03/17/release-v1.5.0/index.html kylin/site/cn/blog/2016/04/12/release-v1.5.1/index.html kylin/site/cn/blog/2016/05/26/release-v1.5.2/index.html kylin/site/cn/blog/2016/07/28/release-v1.5.3/index.html kylin/site/cn/blog/2016/12/04/release-v1.6.0/index.html kylin/site/cn/blog/2017/02/25/v2.0.0-beta-ready/index.html kylin/site/cn/blog/2018/09/20/release-v2.5.0/index.html kylin/site/cn/blog/2019/01/18/release-v2.6.0/index.html kylin/site/cn/development/datasource_sdk.html kylin/site/cn/docs/howto/howto_backup_metadata.html kylin/site/cn/docs/howto/howto_build_cube_with_restapi.html kylin/site/cn/docs/howto/howto_cleanup_storage.html kylin/site/cn/docs/howto/howto_jdbc.html kylin/site/cn/docs/howto/howto_optimize_build.html kylin/site/cn/docs/howto/howto_optimize_cubes.html kylin/site/cn/docs/howto/howto_use_cli.html kylin/site/cn/docs/howto/howto_use_restapi.html kylin/site/cn/docs/index.html kylin/site/cn/docs/install/advance_settings.html kylin/site/cn/docs/install/configuration.html kylin/site/cn/docs/install/index.html kylin/site/cn/docs/install/kylin_aws_emr.html kylin/site/cn/docs/install/kylin_cluster.html kylin/site/cn/docs/install/kylin_docker.html kylin/site/cn/docs/tutorial/Qlik.html kylin/site/cn/docs/tutorial/acl.html kylin/site/cn/docs/tutorial/create_cube.html kylin/site/cn/docs/tutorial/cube_build_job.html kylin/site/cn/docs/tutorial/cube_build_performance.html kylin/site/cn/docs/tutorial/cube_spark.html kylin/site/cn/docs/tutorial/cube_streaming.html kylin/site/cn/docs/tutorial/hybrid.html kylin/site/cn/docs/tutorial/jdbc.html
svn commit: r1852525 [19/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/
Modified: kylin/site/docs24/gettingstarted/terminology.html URL: http://svn.apache.org/viewvc/kylin/site/docs24/gettingstarted/terminology.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs24/gettingstarted/terminology.html (original) +++ kylin/site/docs24/gettingstarted/terminology.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5306,6 +5520,10 @@ var _hmt = _hmt || []; + + + + Superset @@ -7236,6 +7454,10 @@ They are basic knowledge of Apache Kylin + + + + Web Interface @@ -7642,6 +7864,196 @@ They are basic knowledge of Apache Kylin + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -8562,6 +8974,10 @@ They are basic knowledge of Apache Kylin + + + + Use Cube Planner @@ -8772,6 +9188,10 @@ They are basic knowledge of Apache Kylin + + + + Use Dashboard @@ -9770,6 +10190,10 @@ They are basic knowledge of Apache Kylin + + + + Tableau 8 @@ -9972,6 +10396,10 @@ They are basic knowledge of Apache Kylin + + + + Tableau 9 @@ -10482,6 +10910,10 @@ They are basic knowledge of Apache Kylin + + + + SQuirreL @@ -11065,6 +11497,10 @@ They are basic knowledge of Apache Kylin + + + + Modified: kylin/site/docs24/howto/howto_backup_metadata.html URL: http://svn.apache.org/viewvc/kylin/site/docs24/howto/howto_backup_metadata.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs24/howto/howto_backup_metadata.html (original) +++ kylin/site/docs24/howto/howto_backup_metadata.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt ||
svn commit: r1852525 [11/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/
Modified: kylin/site/docs/tutorial/hue.html URL: http://svn.apache.org/viewvc/kylin/site/docs/tutorial/hue.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs/tutorial/hue.html (original) +++ kylin/site/docs/tutorial/hue.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5306,6 +5520,10 @@ var _hmt = _hmt || []; + + + + Superset @@ -7457,6 +7675,10 @@ Nowadays, it isnât compatible, you + + + + Web Interface @@ -7863,6 +8085,196 @@ Nowadays, it isnât compatible, you + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -8783,6 +9195,10 @@ Nowadays, it isnât compatible, you + + + + Use Cube Planner @@ -8993,6 +9409,10 @@ Nowadays, it isnât compatible, you + + + + Use Dashboard @@ -9991,6 +10411,10 @@ Nowadays, it isnât compatible, you + + + + Tableau 8 @@ -10193,6 +10617,10 @@ Nowadays, it isnât compatible, you + + + + Tableau 9 @@ -10703,6 +11131,10 @@ Nowadays, it isnât compatible, you + + + + SQuirreL @@ -11286,6 +11718,10 @@ Nowadays, it isnât compatible, you + + + + Modified: kylin/site/docs/tutorial/hybrid.html URL: http://svn.apache.org/viewvc/kylin/site/docs/tutorial/hybrid.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs/tutorial/hybrid.html (original) +++ kylin/site/docs/tutorial/hybrid.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference
svn commit: r1852525 [10/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/
Modified: kylin/site/docs/install/index.html URL: http://svn.apache.org/viewvc/kylin/site/docs/install/index.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs/install/index.html (original) +++ kylin/site/docs/install/index.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5306,6 +5520,10 @@ var _hmt = _hmt || []; + + + + Superset @@ -6034,7 +6252,7 @@ var _hmt = _hmt || []; Hive: 0.13 - 1.2.1+ HBase: 1.1+, 2.0 (since v2.5) Spark (optional) 2.1.1+ - Kafka (optional) 0.10.0+ + Kafka (optional) 1.0.0+ (since v2.5) JDK: 1.8+ (since v2.5) OS: Linux only, CentOS 6.5+ or Ubuntu 16.0.4+ @@ -7305,6 +7523,10 @@ Kylin with pid 25964 has been stopped. + + + + Web Interface @@ -7711,6 +7933,196 @@ Kylin with pid 25964 has been stopped. + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -8631,6 +9043,10 @@ Kylin with pid 25964 has been stopped. + + + + Use Cube Planner @@ -8841,6 +9257,10 @@ Kylin with pid 25964 has been stopped. + + + + Use Dashboard @@ -9839,6 +10259,10 @@ Kylin with pid 25964 has been stopped. + + + + Tableau 8 @@ -10041,6 +10465,10 @@ Kylin with pid 25964 has been stopped. + + + + Tableau 9 @@ -10551,6 +10979,10 @@ Kylin with pid 25964 has been stopped. + + + + SQuirreL @@ -11134,6 +11566,10 @@ Kylin with pid 25964 has been stopped. + + + + Modified: kylin/site/docs/install/kylin_aws_emr.html URL: http://svn.apache.org/viewvc/kylin/site/docs/install/kylin_aws_emr.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs/install/kylin_aws_emr.html (original) +++ kylin/site/docs/install/kylin_aws_emr.html Wed Jan 30 14:13:48 2019 @@
svn commit: r1852525 [5/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/0
Added: kylin/site/cn/docs/tutorial/sql_reference.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/sql_reference.html?rev=1852525=auto == --- kylin/site/cn/docs/tutorial/sql_reference.html (added) +++ kylin/site/cn/docs/tutorial/sql_reference.html Wed Jan 30 14:13:48 2019 @@ -0,0 +1,5676 @@ + + + + + + + + + + + + Apache Kylin | SQL å¿«éåè + + + + + + + + + + + + + + + + + + + + + http://kylin.apache.org/cn/docs/tutorial/sql_reference.html;> + http://kylin.apache.org/feed.xml; /> + + + +https://www.googletagmanager.com/gtag/js?id=UA-120788561-1"> + + window.dataLayer = window.dataLayer || []; + function gtag(){dataLayer.push(arguments);} + gtag('js', new Date()); + + gtag('config', 'UA-120788561-1'); + + + + + +var _hmt = _hmt || []; +(function() { + var hm = document.createElement("script"); + hm.src = "https://hm.baidu.com/hm.js?bdc5e03add430c0b72cc0eb91eabfa99"; + var s = document.getElementsByTagName("script")[0]; + s.parentNode.insertBefore(hm, s); +})(); + + + + + + + + + + + + + + + + Toggle navigation + + + + + +https://twitter.com/apachekylin; target="_blank" class="fa fa-twitter fa-lg" title="Twitter: @ApacheKylin" > +https://github.com/apache/kylin; target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/kylin" > +https://www.facebook.com/kylinio; target="_blank" class="fa fa-facebook fa-lg" title="Facebook: kylin.io" > + + + + + + +é¦é¡µ +ææ¡£ +ä¸è½½ +ç¤¾åº +å¼å +å客 +English + + + + + + + + + + http://apache.org/foundation/contributing.html; title="Support Apache" style="margin-left: 150px;"> + + https://www.apache.org/images/SupportApache-small.png;> + + + + + + + + + + + + + + SQL å¿«éåè + + Kylin æ¯ä½¿ç¨ Calcite è¿è¡æ¥è¯¢çï¼ååä¸ Kylin æ¯æææ Calcite è½å¤è¯å«çè¯å¥ã + +è¯æ³ +QUERY SYNTAX +SELECT +ãSTATEMENT +ãEXPRESSION +SUBQUERY +JOIN +ãINNER JOIN +ãLEFT JOIN +UNION +UNION ALL + +å½æ° + +COUNT +ãCOUNT(COLUMN) +ãCOUNT(*) +COUNT_DISTINCT +MAX +MIN +PERCENTILE +SUM +TOP_N + +WINDOW +ãROW_NUMBER +ãAVG +ãRANK +ãDENSE_RANK +ãFIRST_VALUE +ãLAST_VALUE +ãLAG +ãLEAD +ãNTILE +ãCASE WHEN +ãCAST + +SUSTRING +COALESCE + +æ°æ®ç±»å +æ°æ®ç±»å + +æ¥è¯¢è¯æ³ + +statement: +| query + +query: + values + | WITH withItem [ , withItem ]* query + | { + select + | selectWithoutFrom + | query UNION [ ALL | DISTINCT ] query + | query INTERSECT [ ALL | DISTINCT ] query + } + [ ORDER BY orderItem [, orderItem ]* ] + [ LIMIT { count | ALL } ] + [ OFFSET start { ROW | ROWS } ] + [ FETCH { FIRST | NEXT } [ count ] { ROW| ROWS } ] + +withItem: + name + ['(' column [, column ]* ')' ] + AS '(' query ')' + +orderItem: + expression [ ASC | DESC ]ï¼» NULLS FIRST |NULLS LAST ï¼½ + +select: + SELECT [ ALL | DISTINCT] + { * | projectItem [, projectItem ]* } + FROM tableExpression + [ WHERE booleanExpression ] + [ GROUP BY { groupItem [, groupItem ]* }] + [ HAVING booleanExpression ] + [ WINDOW windowName AS windowSpec [,windowName AS windowSpec ]* ] + +selectWithoutFrom: + SELECT [ ALL | DISTINCT ] + { * | projectItem [, projectItem ]* } + +projectItem: + expression [ [ AS ] columnAlias ] + | tableAlias . * + +tableExpression: + tableReference [, tableReference ]* + | tableExpression [ NATURAL ]ï¼»( LEFT | RIGHT | FULL ) [ OUTER ] ï¼½ JOIN tableExpression [ joinCondition ] + +joinCondition: + ON booleanExpression + | USING '(' column [, column ]* ')' + +tableReference: + tablePrimary + [ matchRecognize ] + [ [ AS ] alias [ '(' columnAlias [,columnAlias ]* ')' ] ] + +tablePrimary: + [ [ catalogName . ] schemaName . ] tableName + '(' TABLE [ [ catalogName . ] schemaName. ] tableName ')' + | [ LATERAL ] '(' query ')' + | UNNEST '(' expression ')' [ WITH ORDINALITY ] + | [ LATERAL ] TABLE '(' [ SPECIFIC ] functionName '(' expression [, expression ]*')' ')' + +values: + VALUES expression
svn commit: r1852525 [7/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/0
Modified: kylin/site/cn/docs24/tutorial/kylin_sample.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs24/tutorial/kylin_sample.html?rev=1852525=1852524=1852525=diff == --- kylin/site/cn/docs24/tutorial/kylin_sample.html (original) +++ kylin/site/cn/docs24/tutorial/kylin_sample.html Wed Jan 30 14:13:48 2019 @@ -1151,6 +1151,10 @@ var _hmt = _hmt || []; + + + + Web çé¢ @@ -1548,6 +1552,193 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL å¿«éåè + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2450,6 +2641,10 @@ var _hmt = _hmt || []; + + + + ä½¿ç¨ Cube Planner @@ -2657,6 +2852,10 @@ var _hmt = _hmt || []; + + + + ä½¿ç¨ Dashboard @@ -3637,6 +3836,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -3836,6 +4039,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4213,6 +4420,10 @@ var _hmt = _hmt || []; + + + + @@ -4396,6 +4607,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -4519,6 +4734,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/cn/docs24/tutorial/odbc.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs24/tutorial/odbc.html?rev=1852525=1852524=1852525=diff == --- kylin/site/cn/docs24/tutorial/odbc.html (original) +++ kylin/site/cn/docs24/tutorial/odbc.html Wed Jan 30 14:13:48 2019 @@ -1156,6 +1156,10 @@ var _hmt = _hmt || []; + + + + Web çé¢ @@ -1553,6 +1557,193 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL å¿«éåè + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2455,6 +2646,10 @@ var _hmt = _hmt || []; + + + + ä½¿ç¨ Cube Planner @@ -2662,6 +2857,10 @@ var _hmt = _hmt || []; + + + + ä½¿ç¨ Dashboard @@ -3642,6 +3841,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -3841,6 +4044,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4218,6 +4425,10 @@ var _hmt = _hmt || []; + + + + @@ -4401,6 +4612,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -4524,6 +4739,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/cn/docs24/tutorial/powerbi.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs24/tutorial/powerbi.html?rev=1852525=1852524=1852525=diff == ---
svn commit: r1852525 [14/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/
Modified: kylin/site/docs20/howto/howto_use_beeline.html URL: http://svn.apache.org/viewvc/kylin/site/docs20/howto/howto_use_beeline.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs20/howto/howto_use_beeline.html (original) +++ kylin/site/docs20/howto/howto_use_beeline.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5131,6 +5345,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/docs20/howto/howto_use_distributed_scheduler.html URL: http://svn.apache.org/viewvc/kylin/site/docs20/howto/howto_use_distributed_scheduler.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs20/howto/howto_use_distributed_scheduler.html (original) +++ kylin/site/docs20/howto/howto_use_distributed_scheduler.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5131,6 +5345,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/docs20/howto/howto_use_restapi.html URL: http://svn.apache.org/viewvc/kylin/site/docs20/howto/howto_use_restapi.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs20/howto/howto_use_restapi.html (original)
svn commit: r1852525 [3/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/0
Modified: kylin/site/cn/blog/2016/04/12/release-v1.5.1/index.html URL: http://svn.apache.org/viewvc/kylin/site/cn/blog/2016/04/12/release-v1.5.1/index.html?rev=1852525=1852524=1852525=diff == --- kylin/site/cn/blog/2016/04/12/release-v1.5.1/index.html (original) +++ kylin/site/cn/blog/2016/04/12/release-v1.5.1/index.html Wed Jan 30 14:13:48 2019 @@ -1304,6 +1304,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1710,6 +1714,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2630,6 +2824,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2840,6 +3038,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3835,6 +4037,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4037,6 +4243,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4547,6 +4757,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5130,6 +5344,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/cn/blog/2016/05/26/release-v1.5.2/index.html URL: http://svn.apache.org/viewvc/kylin/site/cn/blog/2016/05/26/release-v1.5.2/index.html?rev=1852525=1852524=1852525=diff == --- kylin/site/cn/blog/2016/05/26/release-v1.5.2/index.html (original) +++ kylin/site/cn/blog/2016/05/26/release-v1.5.2/index.html Wed Jan 30 14:13:48 2019 @@ -1304,6 +1304,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1710,6 +1714,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2630,6 +2824,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2840,6 +3038,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3835,6 +4037,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4037,6 +4243,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4547,6 +4757,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5130,6 +5344,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/cn/blog/2016/07/28/release-v1.5.3/index.html URL: http://svn.apache.org/viewvc/kylin/site/cn/blog/2016/07/28/release-v1.5.3/index.html?rev=1852525=1852524=1852525=diff == ---
svn commit: r1852525 [16/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/
Modified: kylin/site/docs21/release_notes.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/release_notes.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs21/release_notes.html (original) +++ kylin/site/docs21/release_notes.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5131,6 +5345,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/docs21/tutorial/Qlik.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/Qlik.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs21/tutorial/Qlik.html (original) +++ kylin/site/docs21/tutorial/Qlik.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5131,6 +5345,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/docs21/tutorial/acl.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/acl.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs21/tutorial/acl.html (original) +++ kylin/site/docs21/tutorial/acl.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web
svn commit: r1852525 [6/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/0
Modified: kylin/site/cn/docs21/install/index.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs21/install/index.html?rev=1852525=1852524=1852525=diff == --- kylin/site/cn/docs21/install/index.html (original) +++ kylin/site/cn/docs21/install/index.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5131,6 +5345,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/cn/docs24/howto/howto_backup_metadata.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs24/howto/howto_backup_metadata.html?rev=1852525=1852524=1852525=diff == --- kylin/site/cn/docs24/howto/howto_backup_metadata.html (original) +++ kylin/site/cn/docs24/howto/howto_backup_metadata.html Wed Jan 30 14:13:48 2019 @@ -1165,6 +1165,10 @@ kylin.metadata.url=kylin_metadata@hbase< + + + + Web çé¢ @@ -1562,6 +1566,193 @@ kylin.metadata.url=kylin_metadata@hbase< + + + + + + + + + + + + + + + + + + + + + +SQL å¿«éåè + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2464,6 +2655,10 @@ kylin.metadata.url=kylin_metadata@hbase< + + + + ä½¿ç¨ Cube Planner @@ -2671,6 +2866,10 @@ kylin.metadata.url=kylin_metadata@hbase< + + + + ä½¿ç¨ Dashboard @@ -3651,6 +3850,10 @@ kylin.metadata.url=kylin_metadata@hbase< + + + + Tableau 8 @@ -3850,6 +4053,10 @@ kylin.metadata.url=kylin_metadata@hbase< + + + + Tableau 9 @@ -4227,6 +4434,10 @@ kylin.metadata.url=kylin_metadata@hbase< + + + + @@ -4410,6 +4621,10 @@ kylin.metadata.url=kylin_metadata@hbase< + + + + SQuirreL @@ -4533,6 +4748,10 @@ kylin.metadata.url=kylin_metadata@hbase< + + + + Modified: kylin/site/cn/docs24/howto/howto_build_cube_with_restapi.html URL:
svn commit: r1852525 [20/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/
Modified: kylin/site/docs24/howto/howto_use_restapi.html URL: http://svn.apache.org/viewvc/kylin/site/docs24/howto/howto_use_restapi.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs24/howto/howto_use_restapi.html (original) +++ kylin/site/docs24/howto/howto_use_restapi.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5306,6 +5520,10 @@ var _hmt = _hmt || []; + + + + Superset @@ -8501,6 +8719,10 @@ $.ajaxSetup({ + + + + Web Interface @@ -8907,6 +9129,196 @@ $.ajaxSetup({ + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -9827,6 +10239,10 @@ $.ajaxSetup({ + + + + Use Cube Planner @@ -10037,6 +10453,10 @@ $.ajaxSetup({ + + + + Use Dashboard @@ -11035,6 +11455,10 @@ $.ajaxSetup({ + + + + Tableau 8 @@ -11237,6 +11661,10 @@ $.ajaxSetup({ + + + + Tableau 9 @@ -11747,6 +12175,10 @@ $.ajaxSetup({ + + + + SQuirreL @@ -12330,6 +12762,10 @@ $.ajaxSetup({ + + + + Modified: kylin/site/docs24/howto/howto_use_restapi_in_js.html URL: http://svn.apache.org/viewvc/kylin/site/docs24/howto/howto_use_restapi_in_js.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs24/howto/howto_use_restapi_in_js.html (original) +++ kylin/site/docs24/howto/howto_use_restapi_in_js.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + +
svn commit: r1852525 [12/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/
Added: kylin/site/docs/tutorial/sql_reference.html URL: http://svn.apache.org/viewvc/kylin/site/docs/tutorial/sql_reference.html?rev=1852525=auto == --- kylin/site/docs/tutorial/sql_reference.html (added) +++ kylin/site/docs/tutorial/sql_reference.html Wed Jan 30 14:13:48 2019 @@ -0,0 +1,12789 @@ + + + + + + + + + + + + Apache Kylin | SQL Reference + + + + + + + + + + + + + + + + + + + + + + http://kylin.apache.org/docs/tutorial/sql_reference.html;> + http://kylin.apache.org/feed.xml; /> + + + +https://www.googletagmanager.com/gtag/js?id=UA-120788561-1"> + + window.dataLayer = window.dataLayer || []; + function gtag(){dataLayer.push(arguments);} + gtag('js', new Date()); + + gtag('config', 'UA-120788561-1'); + + + + + +var _hmt = _hmt || []; +(function() { + var hm = document.createElement("script"); + hm.src = "https://hm.baidu.com/hm.js?bdc5e03add430c0b72cc0eb91eabfa99"; + var s = document.getElementsByTagName("script")[0]; + s.parentNode.insertBefore(hm, s); +})(); + + + + + + + + + + + + + + + + + + Toggle navigation + + + + + +https://twitter.com/apachekylin; target="_blank" class="fa fa-twitter fa-lg" title="Twitter: @ApacheKylin" > +https://github.com/apache/kylin; target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/kylin" > +https://www.facebook.com/kylinio; target="_blank" class="fa fa-facebook fa-lg" title="Facebook: kylin.io" > + + + + + + + + + Home + +Docs + + + Download + Community + Development + Blog + ä¸æç + + + + + + + + http://apache.org/foundation/contributing.html; title="Support Apache" style="margin-left: 150px;"> + + https://www.apache.org/images/SupportApache-small.png; > + + + + + + + + + + + + + + SQL Reference + + + + Kylin uses Calcite for the query. In principle, Kylin supports all statements that Calcite recognizes. + +Grammar + +QUERY SYNTAX +SELECT +ãSTATEMENT +ãEXPRESSION +SUBQUERY +JOIN +ãINNER JOIN +ãLEFT JOIN +UNION +UNION ALL + +Function + +COUNT +ãCOUNT(COLUMN) +ãCOUNT(*) +COUNT_DISTINCT +MAX +MIN +PERCENTILE +SUM +TOP_N +WINDOW +ãROW_NUMBER +ãAVG +ãRANK +ãDENSE_RANK +ãFIRST_VALUE +ãLAST_VALUE +ãLAG +ãLEAD +ãNTILE +ãCASE WHEN +ãCAST +SUSTRING +COALESCE + +Data Type + +DATA TYPE + +QUERY SYNTAX + +statement: +| query + +query: + values + | WITH withItem [ , withItem ]* query + | { + select + | selectWithoutFrom + | query UNION [ ALL | DISTINCT ] query + | query INTERSECT [ ALL | DISTINCT ] query + } + [ ORDER BY orderItem [, orderItem ]* ] + [ LIMIT { count | ALL } ] + [ OFFSET start { ROW | ROWS } ] + [ FETCH { FIRST | NEXT } [ count ] { ROW| ROWS } ] + +withItem: + name + ['(' column [, column ]* ')' ] + AS '(' query ')' + +orderItem: + expression [ ASC | DESC ]ï¼» NULLS FIRST |NULLS LAST ï¼½ + +select: + SELECT [ ALL | DISTINCT] + { * | projectItem [, projectItem ]* } + FROM tableExpression + [ WHERE booleanExpression ] + [ GROUP BY { groupItem [, groupItem ]* }] + [ HAVING booleanExpression ] + [ WINDOW windowName AS windowSpec [,windowName AS windowSpec ]* ] + +selectWithoutFrom: + SELECT [ ALL | DISTINCT ] + { * | projectItem [, projectItem ]* } + +projectItem: + expression [ [ AS ] columnAlias ] + | tableAlias . * + +tableExpression: + tableReference [, tableReference ]* + | tableExpression [ NATURAL ]ï¼»( LEFT | RIGHT | FULL ) [ OUTER ] ï¼½ JOIN tableExpression [ joinCondition ] + +joinCondition: + ON booleanExpression + | USING '(' column [, column ]* ')' + +tableReference: + tablePrimary + [ matchRecognize ] + [ [ AS ] alias [ '(' columnAlias [,columnAlias ]* ')' ] ] + +tablePrimary: + [ [ catalogName . ] schemaName . ] tableName + '(' TABLE [ [ catalogName . ] schemaName. ] tableName ')' + | [ LATERAL ] '(' query ')' + | UNNEST '(' expression ')' [ WITH ORDINALITY ] + | [ LATERAL ] TABLE '(' [
svn commit: r1852525 [13/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/
Modified: kylin/site/docs/tutorial/squirrel.html URL: http://svn.apache.org/viewvc/kylin/site/docs/tutorial/squirrel.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs/tutorial/squirrel.html (original) +++ kylin/site/docs/tutorial/squirrel.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5306,6 +5520,10 @@ var _hmt = _hmt || []; + + + + Superset @@ -7326,6 +7544,10 @@ order by part_dt + + + + Web Interface @@ -7732,6 +7954,196 @@ order by part_dt + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -8652,6 +9064,10 @@ order by part_dt + + + + Use Cube Planner @@ -8862,6 +9278,10 @@ order by part_dt + + + + Use Dashboard @@ -9860,6 +10280,10 @@ order by part_dt + + + + Tableau 8 @@ -10062,6 +10486,10 @@ order by part_dt + + + + Tableau 9 @@ -10572,6 +11000,10 @@ order by part_dt + + + + SQuirreL @@ -11155,6 +11587,10 @@ order by part_dt + + + + Modified: kylin/site/docs/tutorial/superset.html URL: http://svn.apache.org/viewvc/kylin/site/docs/tutorial/superset.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs/tutorial/superset.html (original) +++ kylin/site/docs/tutorial/superset.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + +
svn commit: r1852525 [9/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/0
Modified: kylin/site/docs/howto/howto_jdbc.html URL: http://svn.apache.org/viewvc/kylin/site/docs/howto/howto_jdbc.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs/howto/howto_jdbc.html (original) +++ kylin/site/docs/howto/howto_jdbc.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5306,6 +5520,10 @@ var _hmt = _hmt || []; + + + + Superset @@ -7307,6 +7525,10 @@ while (tables.next()) { + + + + Web Interface @@ -7713,6 +7935,196 @@ while (tables.next()) { + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -8633,6 +9045,10 @@ while (tables.next()) { + + + + Use Cube Planner @@ -8843,6 +9259,10 @@ while (tables.next()) { + + + + Use Dashboard @@ -9841,6 +10261,10 @@ while (tables.next()) { + + + + Tableau 8 @@ -10043,6 +10467,10 @@ while (tables.next()) { + + + + Tableau 9 @@ -10553,6 +10981,10 @@ while (tables.next()) { + + + + SQuirreL @@ -11136,6 +11568,10 @@ while (tables.next()) { + + + + Modified: kylin/site/docs/howto/howto_ldap_and_sso.html URL: http://svn.apache.org/viewvc/kylin/site/docs/howto/howto_ldap_and_sso.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs/howto/howto_ldap_and_sso.html (original) +++ kylin/site/docs/howto/howto_ldap_and_sso.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + +
svn commit: r1852525 [2/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/0
Modified: kylin/site/blog/2016/06/10/standalone-hbase-cluster/index.html URL: http://svn.apache.org/viewvc/kylin/site/blog/2016/06/10/standalone-hbase-cluster/index.html?rev=1852525=1852524=1852525=diff == --- kylin/site/blog/2016/06/10/standalone-hbase-cluster/index.html (original) +++ kylin/site/blog/2016/06/10/standalone-hbase-cluster/index.html Wed Jan 30 14:13:48 2019 @@ -1304,6 +1304,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1710,6 +1714,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2630,6 +2824,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2840,6 +3038,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3835,6 +4037,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4037,6 +4243,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4547,6 +4757,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5130,6 +5344,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/blog/2016/07/28/release-v1.5.3/index.html URL: http://svn.apache.org/viewvc/kylin/site/blog/2016/07/28/release-v1.5.3/index.html?rev=1852525=1852524=1852525=diff == --- kylin/site/blog/2016/07/28/release-v1.5.3/index.html (original) +++ kylin/site/blog/2016/07/28/release-v1.5.3/index.html Wed Jan 30 14:13:48 2019 @@ -1304,6 +1304,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1710,6 +1714,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2630,6 +2824,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2840,6 +3038,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3835,6 +4037,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4037,6 +4243,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4547,6 +4757,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5130,6 +5344,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/blog/2016/08/01/count-distinct-in-kylin/index.html URL: http://svn.apache.org/viewvc/kylin/site/blog/2016/08/01/count-distinct-in-kylin/index.html?rev=1852525=1852524=1852525=diff ==
svn commit: r1852525 [17/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/
Modified: kylin/site/docs23/howto/howto_cleanup_storage.html URL: http://svn.apache.org/viewvc/kylin/site/docs23/howto/howto_cleanup_storage.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs23/howto/howto_cleanup_storage.html (original) +++ kylin/site/docs23/howto/howto_cleanup_storage.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5131,6 +5345,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/docs23/howto/howto_enable_zookeeper_acl.html URL: http://svn.apache.org/viewvc/kylin/site/docs23/howto/howto_enable_zookeeper_acl.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs23/howto/howto_enable_zookeeper_acl.html (original) +++ kylin/site/docs23/howto/howto_enable_zookeeper_acl.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5131,6 +5345,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/docs23/howto/howto_install_ranger_kylin_plugin.html URL: http://svn.apache.org/viewvc/kylin/site/docs23/howto/howto_install_ranger_kylin_plugin.html?rev=1852525=1852524=1852525=diff == ---
svn commit: r1852525 [21/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/
Modified: kylin/site/docs24/tutorial/cube_build_job.html URL: http://svn.apache.org/viewvc/kylin/site/docs24/tutorial/cube_build_job.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs24/tutorial/cube_build_job.html (original) +++ kylin/site/docs24/tutorial/cube_build_job.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5306,6 +5520,10 @@ var _hmt = _hmt || []; + + + + Superset @@ -7293,6 +7511,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -7699,6 +7921,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -8619,6 +9031,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -8829,6 +9245,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -9827,6 +10247,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -10029,6 +10453,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -10539,6 +10967,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -11122,6 +11554,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/docs24/tutorial/cube_build_performance.html URL: http://svn.apache.org/viewvc/kylin/site/docs24/tutorial/cube_build_performance.html?rev=1852525=1852524=1852525=diff == --- kylin/site/docs24/tutorial/cube_build_performance.html (original) +++ kylin/site/docs24/tutorial/cube_build_performance.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +
svn commit: r1852525 [4/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/0
Modified: kylin/site/cn/docs/tutorial/create_cube.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/create_cube.html?rev=1852525=1852524=1852525=diff == --- kylin/site/cn/docs/tutorial/create_cube.html (original) +++ kylin/site/cn/docs/tutorial/create_cube.html Wed Jan 30 14:13:48 2019 @@ -1398,6 +1398,10 @@ Percentile 代表äºç¾å� + + + + Web çé¢ @@ -1795,6 +1799,193 @@ Percentile 代表äºç¾å� + + + + + + + + + + + + + + + + + + + + + +SQL å¿«éåè + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2697,6 +2888,10 @@ Percentile 代表äºç¾å� + + + + ä½¿ç¨ Cube Planner @@ -2904,6 +3099,10 @@ Percentile 代表äºç¾å� + + + + ä½¿ç¨ Dashboard @@ -3884,6 +4083,10 @@ Percentile 代表äºç¾å� + + + + Tableau 8 @@ -4083,6 +4286,10 @@ Percentile 代表äºç¾å� + + + + Tableau 9 @@ -4460,6 +4667,10 @@ Percentile 代表äºç¾å� + + + + @@ -4643,6 +4854,10 @@ Percentile 代表äºç¾å� + + + + SQuirreL @@ -4766,6 +4981,10 @@ Percentile 代表äºç¾å� + + + + Modified: kylin/site/cn/docs/tutorial/cube_build_job.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/cube_build_job.html?rev=1852525=1852524=1852525=diff == --- kylin/site/cn/docs/tutorial/cube_build_job.html (original) +++ kylin/site/cn/docs/tutorial/cube_build_job.html Wed Jan 30 14:13:48 2019 @@ -1196,6 +1196,10 @@ var _hmt = _hmt || []; + + + + Web çé¢ @@ -1593,6 +1597,193 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL å¿«éåè + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2495,6 +2686,10 @@ var _hmt = _hmt || []; + + + + ä½¿ç¨ Cube Planner @@ -2702,6 +2897,10 @@ var _hmt = _hmt || []; + + + + ä½¿ç¨ Dashboard @@ -3682,6 +3881,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -3881,6 +4084,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4258,6 +4465,10 @@ var _hmt = _hmt || []; + + + + @@ -4441,6 +4652,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -4564,6 +4779,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/cn/docs/tutorial/cube_build_performance.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/cube_build_performance.html?rev=1852525=1852524=1852525=diff
svn commit: r1852525 [8/22] - in /kylin/site: ./ about/ assets/css/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/0
Modified: kylin/site/development/howto_package.html URL: http://svn.apache.org/viewvc/kylin/site/development/howto_package.html?rev=1852525=1852524=1852525=diff == --- kylin/site/development/howto_package.html (original) +++ kylin/site/development/howto_package.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5131,6 +5345,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/development/howto_release.html URL: http://svn.apache.org/viewvc/kylin/site/development/howto_release.html?rev=1852525=1852524=1852525=diff == --- kylin/site/development/howto_release.html (original) +++ kylin/site/development/howto_release.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + Web Interface @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + +SQL Reference + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Project Level ACL @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + Use Cube Planner @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + Use Dashboard @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + Tableau 8 @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + Tableau 9 @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + SQuirreL @@ -5131,6 +5345,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/development/howto_test.html URL: http://svn.apache.org/viewvc/kylin/site/development/howto_test.html?rev=1852525=1852524=1852525=diff == --- kylin/site/development/howto_test.html (original) +++ kylin/site/development/howto_test.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || [];
[kylin] branch master updated: KYLIN-3797 Too many or filters may break Kylin server when flatting filter
This is an automated email from the ASF dual-hosted git repository. shaofengshi pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/kylin.git The following commit(s) were added to refs/heads/master by this push: new 24f1987 KYLIN-3797 Too many or filters may break Kylin server when flatting filter 24f1987 is described below commit 24f1987d71df1c51f9e1fca5885a2bfa4fca501d Author: Ma,Gang AuthorDate: Wed Jan 30 15:40:11 2019 +0800 KYLIN-3797 Too many or filters may break Kylin server when flatting filter --- .../org/apache/kylin/common/KylinConfigBase.java | 4 ++ .../apache/kylin/metadata/filter/TupleFilter.java | 30 -- .../kylin/metadata/filter/TupleFilterTest.java | 64 ++ 3 files changed, 92 insertions(+), 6 deletions(-) diff --git a/core-common/src/main/java/org/apache/kylin/common/KylinConfigBase.java b/core-common/src/main/java/org/apache/kylin/common/KylinConfigBase.java index ab6d1a9..ecd663e 100644 --- a/core-common/src/main/java/org/apache/kylin/common/KylinConfigBase.java +++ b/core-common/src/main/java/org/apache/kylin/common/KylinConfigBase.java @@ -1673,6 +1673,10 @@ abstract public class KylinConfigBase implements Serializable { return Boolean.parseBoolean(this.getOptional("kylin.query.cache-signature-enabled", FALSE)); } +public int getFlatFilterMaxChildrenSize() { +return Integer.parseInt(this.getOptional("kylin.query.flat-filter-max-children", "50")); +} + // // SERVER // diff --git a/core-metadata/src/main/java/org/apache/kylin/metadata/filter/TupleFilter.java b/core-metadata/src/main/java/org/apache/kylin/metadata/filter/TupleFilter.java index 672aba0..019960e 100644 --- a/core-metadata/src/main/java/org/apache/kylin/metadata/filter/TupleFilter.java +++ b/core-metadata/src/main/java/org/apache/kylin/metadata/filter/TupleFilter.java @@ -26,6 +26,7 @@ import java.util.List; import java.util.Map; import java.util.Set; +import org.apache.kylin.common.KylinConfig; import org.apache.kylin.metadata.model.TblColRef; import org.apache.kylin.metadata.tuple.IEvaluatableTuple; import org.slf4j.Logger; @@ -215,10 +216,19 @@ public abstract class TupleFilter { * @return */ public TupleFilter flatFilter() { -return flattenInternal(this); +return flatFilter(KylinConfig.getInstanceFromEnv().getFlatFilterMaxChildrenSize()); } -private TupleFilter flattenInternal(TupleFilter filter) { +/** + * throws IllegalStateException when the flat children exceed the maxFlatChildrenSize + * @param maxFlatChildrenSize + * @return + */ +public TupleFilter flatFilter(int maxFlatChildrenSize) { +return flattenInternal(this, maxFlatChildrenSize); +} + +private TupleFilter flattenInternal(TupleFilter filter, int maxFlatChildrenSize) { TupleFilter flatFilter = null; if (!(filter instanceof LogicalTupleFilter)) { flatFilter = new LogicalTupleFilter(FilterOperatorEnum.AND); @@ -231,7 +241,7 @@ public abstract class TupleFilter { List andChildren = new LinkedList(); List orChildren = new LinkedList(); for (TupleFilter child : filter.getChildren()) { -TupleFilter flatChild = flattenInternal(child); +TupleFilter flatChild = flattenInternal(child, maxFlatChildrenSize); FilterOperatorEnum childOp = flatChild.getOperator(); if (childOp == FilterOperatorEnum.AND) { andChildren.add(flatChild); @@ -249,7 +259,7 @@ public abstract class TupleFilter { flatFilter.addChildren(andChild.getChildren()); } if (!orChildren.isEmpty()) { -List fullAndFilters = cartesianProduct(orChildren, flatFilter); +List fullAndFilters = cartesianProduct(orChildren, flatFilter, maxFlatChildrenSize); flatFilter = new LogicalTupleFilter(FilterOperatorEnum.OR); flatFilter.addChildren(fullAndFilters); } @@ -262,14 +272,18 @@ public abstract class TupleFilter { } else if (op == FilterOperatorEnum.NOT) { assert (filter.children.size() == 1); TupleFilter reverse = filter.children.get(0).reverse(); -flatFilter = flattenInternal(reverse); +flatFilter = flattenInternal(reverse, maxFlatChildrenSize); } else { throw new IllegalStateException("Filter is " + filter); } +if (flatFilter.getChildren() != null && flatFilter.getChildren().size() > maxFlatChildrenSize) { +throw new IllegalStateException("the filter is too large after do the flat, size=" ++ flatFilter.getChildren().size()); +}
[kylin] branch master updated: KYLIN-3799 Fix wrong hive-exec jar may be found by find-hive-dependency.sh on CDH
This is an automated email from the ASF dual-hosted git repository. shaofengshi pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/kylin.git The following commit(s) were added to refs/heads/master by this push: new bcf1b52 KYLIN-3799 Fix wrong hive-exec jar may be found by find-hive-dependency.sh on CDH bcf1b52 is described below commit bcf1b5237bf25116cbcb393bb8e12f42c8306600 Author: nichunen AuthorDate: Wed Jan 30 14:58:39 2019 +0800 KYLIN-3799 Fix wrong hive-exec jar may be found by find-hive-dependency.sh on CDH --- build/bin/find-hive-dependency.sh | 8 +++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/build/bin/find-hive-dependency.sh b/build/bin/find-hive-dependency.sh index 558c9b5..17258a0 100755 --- a/build/bin/find-hive-dependency.sh +++ b/build/bin/find-hive-dependency.sh @@ -61,7 +61,7 @@ fi for data in ${arr[@]} do -result=`echo $data | grep -e 'hive-exec[a-z0-9A-Z\.-]*.jar'` +result=`echo $data | grep -e 'hive-exec[a-z0-9A-Z\.-]*.jar' | grep -v 'auxlib'` # In some cases there are more than one lib dirs, only the first one will be applied. if [ $result ] && [ -z "$hive_exec_path" ] then @@ -189,6 +189,12 @@ then quit "HIVE_LIB not found, please check hive installation or export HIVE_LIB='YOUR_LOCAL_HIVE_LIB'." fi else +if [[ $HIVE_LIB =~ ^\/.*hive.*\/lib[\/]* ]] +then +verbose "HIVE_LIB is set to ${HIVE_LIB}" +else +echo "WARNING: HIVE_LIB is set to ${HIVE_LIB}, it's advised to set it to the lib dir under hive's installation directory" +fi hive_lib_dir="$HIVE_LIB" fi hive_lib=`find -L ${hive_lib_dir} -name '*.jar' ! -name '*druid*' ! -name '*slf4j*' ! -name '*avatica*' ! -name '*calcite*' ! -name '*jackson-datatype-joda*' ! -name '*derby*' -printf '%p:' | sed 's/:$//'`
[kylin] branch master updated: KYLIN-3794 fix mergeToInClause not working properly in some edge cases
This is an automated email from the ASF dual-hosted git repository. nju_yaho pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/kylin.git The following commit(s) were added to refs/heads/master by this push: new b1f1b7b KYLIN-3794 fix mergeToInClause not working properly in some edge cases b1f1b7b is described below commit b1f1b7bdf04a00fd9fd96e35e700f4ee7aeb455e Author: kyotoYaho AuthorDate: Wed Jan 30 10:07:35 2019 +0800 KYLIN-3794 fix mergeToInClause not working properly in some edge cases --- .../query/relnode/visitor/TupleFilterVisitor.java | 78 .../relnode/visitor/TupleFilterVisitorTest.java| 86 ++ 2 files changed, 132 insertions(+), 32 deletions(-) diff --git a/query/src/main/java/org/apache/kylin/query/relnode/visitor/TupleFilterVisitor.java b/query/src/main/java/org/apache/kylin/query/relnode/visitor/TupleFilterVisitor.java index faa9988..7634023 100644 --- a/query/src/main/java/org/apache/kylin/query/relnode/visitor/TupleFilterVisitor.java +++ b/query/src/main/java/org/apache/kylin/query/relnode/visitor/TupleFilterVisitor.java @@ -18,13 +18,12 @@ package org.apache.kylin.query.relnode.visitor; -import java.math.BigDecimal; -import java.util.GregorianCalendar; -import java.util.HashMap; -import java.util.LinkedList; -import java.util.List; -import java.util.Map; - +import com.google.common.annotations.VisibleForTesting; +import com.google.common.base.Preconditions; +import com.google.common.collect.ImmutableList; +import com.google.common.collect.Lists; +import com.google.common.collect.Maps; +import com.google.common.collect.Sets; import org.apache.calcite.avatica.util.TimeUnitRange; import org.apache.calcite.rel.type.RelDataType; import org.apache.calcite.rex.RexCall; @@ -39,6 +38,7 @@ import org.apache.calcite.sql.SqlOperator; import org.apache.calcite.sql.type.SqlTypeFamily; import org.apache.calcite.util.NlsString; import org.apache.kylin.common.util.DateFormat; +import org.apache.kylin.common.util.Pair; import org.apache.kylin.metadata.filter.CaseTupleFilter; import org.apache.kylin.metadata.filter.ColumnTupleFilter; import org.apache.kylin.metadata.filter.CompareTupleFilter; @@ -52,9 +52,11 @@ import org.apache.kylin.metadata.filter.function.Functions; import org.apache.kylin.metadata.model.TblColRef; import org.apache.kylin.query.relnode.ColumnRowType; -import com.google.common.base.Preconditions; -import com.google.common.collect.ImmutableList; -import com.google.common.collect.Lists; +import java.math.BigDecimal; +import java.util.GregorianCalendar; +import java.util.List; +import java.util.Map; +import java.util.Set; public class TupleFilterVisitor extends RexVisitorImpl { @@ -146,10 +148,7 @@ public class TupleFilterVisitor extends RexVisitorImpl { } if (op.getKind() == SqlKind.OR) { -CompareTupleFilter inFilter = mergeToInClause(filter); -if (inFilter != null) { -filter = inFilter; -} +filter = mergeToInClause(filter); } else if (op.getKind() == SqlKind.NOT) { assert (filter.getChildren().size() == 1); filter = filter.getChildren().get(0).reverse(); @@ -221,36 +220,51 @@ public class TupleFilterVisitor extends RexVisitorImpl { return constFilter; } -private CompareTupleFilter mergeToInClause(TupleFilter filter) { +@VisibleForTesting +static TupleFilter mergeToInClause(TupleFilter filter) { List children = filter.getChildren(); -TblColRef inColumn = null; -List inValues = new LinkedList(); -Map dynamicVariables = new HashMap<>(); +if (children.isEmpty()) { +return filter; +} +// key: inColumn +// Value: first: inValues +// Value: second: dynamicVariables +Map, Map>> inColumnMap = Maps.newHashMap(); +List extraFilters = Lists.newLinkedList(); for (TupleFilter child : children) { if (child.getOperator() == TupleFilter.FilterOperatorEnum.EQ) { CompareTupleFilter compFilter = (CompareTupleFilter) child; TblColRef column = compFilter.getColumn(); -if (inColumn == null) { -inColumn = column; -} +if (column != null) { +Pair, Map> tmpValue = inColumnMap.get(column); +if (tmpValue == null) { +Set inValues = Sets.newHashSet(); +Map dynamicVariables = Maps.newHashMap(); +tmpValue = new Pair<>(inValues, dynamicVariables); +inColumnMap.put(column, tmpValue); +} -if (column == null || !column.equals(inColumn)) { -return null; +tmpValue.getFirst().addAll(compFilter.getValues()); +