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&view=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 @@ +<!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<!doctype html> +<html> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<head> + <meta charset="utf-8"> + <meta http-equiv="X-UA-Compatible" content="IE=edge"> + <meta name="viewport" content="width=device-width, initial-scale=1"> + + <title>Apache Kylin | SQL å¿«éåè</title> + <meta name="description" content="Apache Kylin Home"> + <meta name="author" content="Apache Kylin"> + <link rel="shortcut icon" href="fav.png" type="image/png"> + + + +<link rel="stylesheet" href="/assets/css/animate.css"> +<!-- Bootstrap --> +<link rel="stylesheet" href="/assets/css/bootstrap.min.css"> + +<!-- Fonts --> +<!-- <link rel="stylesheet" href="http://fonts.googleapis.com/css?family=Alice|Open+Sans:400,300,700"> --> + +<!-- Icons --> +<link rel="stylesheet" href="/assets/css/font-awesome.min.css"> + + <!-- Custom styles --> + <link rel="stylesheet" href="/assets/css/styles.css"> + <link rel="stylesheet" href="/assets/css/docs.css"> + + <link rel="canonical" href="http://kylin.apache.org/cn/docs/tutorial/sql_reference.html"> + <link rel="alternate" type="application/rss+xml" title="Apache Kylin" href="http://kylin.apache.org/feed.xml" /> + +<!--[if lt IE 9]> <script src="assets/js/html5shiv.js"></script> <![endif]--> +<!-- Global site tag (gtag.js) - Google Analytics --> +<script async src="https://www.googletagmanager.com/gtag/js?id=UA-120788561-1"></script> +<script> + window.dataLayer = window.dataLayer || []; + function gtag(){dataLayer.push(arguments);} + gtag('js', new Date()); + + gtag('config', 'UA-120788561-1'); +</script> +<script type="text/javascript" src="/assets/js/jquery-1.9.1.min.js"></script> +<script type="text/javascript" src="/assets/js/nside.js"></script> </script> +<script type="text/javascript" src="/assets/js/nnav.js"></script> </script> +<script> +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); +})(); +</script> +</head> + + <body> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<header id="header" > + <!-- Main Menu --> + <nav class="navbar navbar-default" role="navigation" id="nav-wrapper"> + <div class="container-fluid" id="nav"> + <!-- Brand and toggle get grouped for better mobile display --> + <div class="navbar-header"> + <img class="navbar-logo" width="46" src="/assets/images/kylin_logo.png "></img> + + <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1"> + <span class="sr-only">Toggle navigation</span> + <span class="icon-bar"></span> + <span class="icon-bar"></span> + <span class="icon-bar"></span> + </button> + <ul class="nav icon-navbar"> + <li><a href="https://twitter.com/apachekylin" target="_blank" class="fa fa-twitter fa-lg" title="Twitter: @ApacheKylin" ></a></li> + <li><a href="https://github.com/apache/kylin" target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/kylin" ></a></li> + <li><a href="https://www.facebook.com/kylinio" target="_blank" class="fa fa-facebook fa-lg" title="Facebook: kylin.io" ></a></li> + </ul> + </div> + + <!-- Collect the nav links, forms, and other content for toggling --> + <div class="navbar-collapse" id="bs-example-navbar-collapse-1"> + <ul class="nav navbar-nav"> + <li><a href="/cn">é¦é¡µ</a></li> + <li><a href="/cn/docs" >ææ¡£</a></li> + <li><a href="/cn/download">ä¸è½½</a></li> + <li><a href="/cn/community" >社åº</a></li> + <li><a href="/cn/development" >å¼å</a></li> + <li><a href="/blog">å客</a></li> + <li><a href="/" >English</a></li> + </ul> + + + </div><!-- /.navbar-collapse --> + </div><!-- /.container-fluid --> + </nav> + + <div id="head" class="parallax normal-header" > + <div class="text-center header-apache"> + <a href="http://apache.org/foundation/contributing.html" title="Support Apache" style="margin-left: 150px;"> + <div> + <img src="https://www.apache.org/images/SupportApache-small.png"> + </div> + </a> + </div> + </div> + + </header> + + + <div class="container"> + <div class="row" style="clear:both;"> + <div class="col-md-8 col-lg-8 col-xs-12 col-sm-12 aside2" style="float:right;"> + <div id="container" class="docs"> + <div id="pjax"> + <h1 class="post-title">SQL å¿«éåè</h1> + <article class="post-content" > + <p>Kylin æ¯ä½¿ç¨ Calcite è¿è¡æ¥è¯¢çï¼ååä¸ Kylin æ¯æææ Calcite è½å¤è¯å«çè¯å¥ã</p> + +<h2 id="section">è¯æ³</h2> +<p><a href="#QUERYSYNTAX">QUERY SYNTAX</a><br /> +<a href="#SELECT">SELECT</a><br /> +ã<a href="#STATEMENT">STATEMENT</a><br /> +ã<a href="#EXPRESSION">EXPRESSION</a><br /> +<a href="#SUBQUERY">SUBQUERY</a><br /> +<a href="#JOIN">JOIN</a><br /> +ã<a href="#INNERJOIN">INNER JOIN</a><br /> +ã<a href="#LEFTJOIN">LEFT JOIN</a><br /> +<a href="#UNION">UNION</a><br /> +<a href="#UNIONALL">UNION ALL</a></p> + +<h2 id="section-1">å½æ°</h2> + +<p><a href="#COUNT">COUNT</a><br /> +ã<a href="#COUNT_COLUMN">COUNT(COLUMN)</a><br /> +ã<a href="#COUNT_">COUNT(*)</a><br /> +<a href="#COUNT_DISTINCT">COUNT_DISTINCT</a><br /> +<a href="#MAX">MAX</a><br /> +<a href="#MIN">MIN</a><br /> +<a href="#PERCENTILE">PERCENTILE</a><br /> +<a href="#SUM">SUM</a><br /> +<a href="#TOP_N">TOP_N</a></p> + +<p><a href="#WINDOW">WINDOW</a><br /> +ã<a href="#ROW_NUMBER">ROW_NUMBER</a><br /> +ã<a href="#AVG">AVG</a><br /> +ã<a href="#RANK">RANK</a><br /> +ã<a href="#DENSE_RANK">DENSE_RANK</a><br /> +ã<a href="#FIRST_VALUE">FIRST_VALUE</a><br /> +ã<a href="#LAST_VALUE">LAST_VALUE</a><br /> +ã<a href="#LAG">LAG</a><br /> +ã<a href="#LEAD">LEAD</a><br /> +ã<a href="#NTILE">NTILE</a><br /> +ã<a href="#CASEWHEN">CASE WHEN</a><br /> +ã<a href="#CAST">CAST</a></p> + +<p><a href="#SUBSTRING">SUSTRING</a><br /> +<a href="#COALESCE">COALESCE</a></p> + +<h2 id="section-2">æ°æ®ç±»å</h2> +<p><a href="#datatype">æ°æ®ç±»å</a></p> + +<h2 id="QUERYSYNTAX">æ¥è¯¢è¯æ³</h2> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">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 [, expression ]* + +groupItem: + expression + | '('')' + | '('expression [, expression ]* ')' + | GROUPING SETS '(' groupItem [, groupItem ]* ')' + +windowRef: + windowName + | windowSpec + +windowSpec: + [windowName ] + '(' + [ ORDER BY orderItem [, orderItem ]* ] + [ PARTITION BY expression [, expression]* ] + [ + RANGE numericOrIntervalExpression { PRECEDING | FOLLOWING } + | ROWS numericExpression { PRECEDING | FOLLOWING } + ] + ')'</code></pre></div> + +<h2 id="SELECT">SELECT</h2> + +<h3 id="STATEMENT">STATEMENT</h3> +<p><code class="highlighter-rouge">SELECT</code> ç¨äºä»è¡¨ä¸éåæ°æ®ã<code class="highlighter-rouge">COUNT</code> ç¨äºç»è®¡æ°æ®ã<code class="highlighter-rouge">DISTINCT</code> è¿æ»¤æéå¤çç»æã<code class="highlighter-rouge">AS</code> ç¨äºç»è¡¨æåèµ·å«åã<code class="highlighter-rouge">FROM</code> æå®è¦æ¥è¯¢ç表ã<code class="highlighter-rouge">JOIN</code> ç¨äºè¿æ¥ä¸¤ä¸ªè¡¨ä»¥è·åæéçæ°æ®ã<code class="highlighter-rouge">WHERE</code> ç¨äºè§å®éæ©çæ åã<code class="highlighter-rouge">LIKE</code> ç¨äºå¨ <code class="highlighter-rouge">WHERE</code> åå¥ä¸æç´¢åä¸çæå®æ¨¡å¼ã<code class="highlighter-rouge">BETWEEN ... AND</code> éåä»� �ºä¸¤ä¸ªå¼ä¹é´çæ°æ®èå´ã<code class="highlighter-rouge">AND</code> å <code class="highlighter-rouge">OR</code> ç¨äºåºäºä¸ä¸ªä»¥ä¸çæ¡ä»¶å¯¹è®°å½è¿è¡è¿æ»¤ã<code class="highlighter-rouge">GROUP BY</code> æç»å®è¡¨è¾¾å¼å¯¹ç»æè¿è¡åç»ã<code class="highlighter-rouge">HAVING</code> ç¨äºåç»åè¿æ»¤è¡ã<code class="highlighter-rouge">ORDER BY</code> ç¨äºå¯¹ç»æéè¿è¡æåºï¼é常å <code class="highlighter-rouge">TOPN</code> ä¸èµ·ä½¿ç¨ã<code class="highlighter-rouge">LIMIT</code> ç¨æ¥éå¶æ¥è¯¢è¿åçè¡æ°ã</p> + +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT COUNT(*) FROM kylin_sales; + +SELECT COUNT(DISTINCT seller_id) FROM kylin_sales; + +SELECT seller_id, COUNT(1) FROM kylin_sales GROUP BY seller_id; + +SELECT lstg_format_name, SUM(price) AS gmv, COUNT(DISTINCT seller_id) AS dist_seller FROM kylin_sales WHERE lstg_format_name='FP-GTC' GROUP BY lstg_format_name HAVING COUNT(DISTINCT seller_id) > 50; + +SELECT lstg_format_name FROM kylin_sales INNER JOIN kylin_cal_dt AS kylin_cal_dt ON kylin_sales.part_dt = kylin_cal_dt.cal_dt WHERE NOT(lstg_format_name NOT LIKE '%ab%') GROUP BY lstg_format_name; + +SELECT kylin_cal_dt.cal_dt FROM kylin_sales INNER JOIN kylin_cal_dt AS kylin_cal_dt ON kylin_sales.part_dt = kylin_cal_dt.cal_dt WHERE kylin_cal_dt.cal_dt BETWEEN DATE '2013-01-01' AND DATE '2013-06-04'; + +SELECT kylin_sales.lstg_format_name, SUM(kylin_sales.price) AS gmv, COUNT(*) AS trans_cnt FROM kylin_sales WHERE kylin_sales.lstg_format_name IS NULL GROUP BY kylin_sales.lstg_format_name HAVING SUM(price)>5000 AND COUNT(*)>72; + +SELECT kylin_sales.lstg_format_name, SUM(kylin_sales.price) AS gmv, COUNT(*) AS trans_cnt FROM kylin_sales WHERE kylin_sales.lstg_format_name IS NOT NULL GROUP BY kylin_sales.lstg_format_name HAVING SUM(price)>5000 OR COUNT(*)>20; + +SELECT lstg_format_name, SUM(price) AS gmv, COUNT(1) AS trans_cnt FROM kylin_sales WHERE lstg_format_name='FP-GTC' GROUP BY lstg_format_name ORDER BY lstg_format_name LIMIT 10;</code></pre></div> + +<h3 id="EXPRESSION">EXPRESSION</h3> +<p>å¨ <code class="highlighter-rouge">SELECT</code> è¯å¥ä¸ç表达å¼ã å¯ä»¥ä½¿ç¨ * éæ©è¡¨ä¸çææåã<br /> +ä¾åï¼<br /> +1. *<br /> +2. å° ID ä½ä¸ºå¼<br /> +3. å¼ + 1</p> + +<h2 id="SUBQUERY">SUBQUERY</h2> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT cal_dt ,sum(price) AS sum_price FROM (SELECT kylin_cal_dt.cal_dt, kylin_sales.price FROM kylin_sales INNER JOIN kylin_cal_dt AS kylin_cal_dt ON kylin_sales.part_dt = kylin_cal_dt.cal_dt INNER JOIN kylin_category_groupings ON kylin_sales.leaf_categ_id = kylin_category_groupings.leaf_categ_id AND kylin_sales.lstg_site_id = kylin_category_groupings.site_id) t GROUP BY cal_dt;</code></pre></div> + +<h2 id="JOIN">JOIN</h2> + +<h3 id="INNERJOIN">INNER JOIN</h3> +<p>å¨è¡¨ä¸åå¨è³å°ä¸ä¸ªå¹é æ¶ï¼<code class="highlighter-rouge">INNER JOIN</code> å ³é®åè¿åè¡ã<br /> +ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT kylin_cal_dt.cal_dt, kylin_sales.price FROM kylin_sales INNER JOIN kylin_cal_dt AS kylin_cal_dt ON kylin_sales.part_dt**** = kylin_cal_dt.cal_dt;</code></pre></div> + +<h3 id="LEFTJOIN">LEFT JOIN</h3> +<p>ä½¿ç¨ <code class="highlighter-rouge">LEFT JOIN</code> å ³é®åä¼ä»å·¦è¡¨ (kylin_sales) é£éè¿åææçè¡ï¼å³ä½¿å¨å³è¡¨ (kylin_category_groupings) ä¸æ²¡æå¹é çè¡ã<br /> +ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT seller_id FROM kylin_sales LEFT JOIN kylin_category_groupings AS kylin_category_groupings ON kylin_sales.leaf_categ_id = kylin_category_groupings.leaf_categ_id AND kylin_sales.lstg_site_id = kylin_category_groupings.site_id WHERE lstg_format_name='FP-GTC' GROUP BY seller_id LIMIT 20;</code></pre></div> + +<h2 id="UNION">UNION</h2> +<p><code class="highlighter-rouge">UNION</code> æä½ç¬¦ç¨äºå并两个æå¤ä¸ª <code class="highlighter-rouge">SELECT</code> è¯å¥çç»æéã<br /> +<em>注æ</em> <code class="highlighter-rouge">UNION</code> å é¨ç <code class="highlighter-rouge">SELECT</code> è¯å¥å¿ é¡»æ¥æç¸åæ°éçåãåä¹å¿ é¡»æ¥æç¸ä¼¼çæ°æ®ç±»åãåæ¶ï¼æ¯æ¡ <code class="highlighter-rouge">SELECT</code> è¯å¥ä¸çåç顺åºå¿ é¡»ç¸åã<br /> +é»è®¤å°ï¼<code class="highlighter-rouge">UNION</code> æä½ç¬¦éåä¸åçå¼ãå¦æå 许éå¤çå¼ï¼è¯·ä½¿ç¨ <code class="highlighter-rouge">UNION ALL</code>ã</p> + +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT SUM(price) AS x, seller_id, COUNT(*) AS y FROM kylin_sales WHERE part_dt < DATE '2012-08-01' GROUP BY seller_id UNION (SELECT SUM(price) AS x, seller_id, COUNT(*) AS y FROM kylin_sales WHERE part_dt > DATE '2012-12-01' GROUP BY seller_id);</code></pre></div> + +<h2 id="UNIONALL">UNION ALL</h2> +<p><code class="highlighter-rouge">UNION ALL</code> å½ä»¤å <code class="highlighter-rouge">UNION</code> å½ä»¤å ä¹æ¯çæçï¼ä¸è¿ <code class="highlighter-rouge">UNION ALL</code> å½ä»¤ä¼ååºææçå¼ã</p> + +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT COUNT(trans_id) AS trans_id FROM kylin_sales AS test_a WHERE trans_id <> 1 UNION ALL SELECT COUNT(trans_id) AS trans_id FROM kylin_sales AS test_b;</code></pre></div> + +<h2 id="COUNT">COUNT</h2> +<p>ç¨äºè¿åä¸æå®æ¡ä»¶å¹é çè¡æ°ã</p> + +<h3 id="COUNT_COLUMN">COUNT(COLUMN)</h3> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT COUNT(seller_id) FROM kylin_sales;</code></pre></div> + +<h3 id="COUNT_">COUNT(*)</h3> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT COUNT(*) FROM kylin_sales;</code></pre></div> + +<h2 id="COUNT_DISTINCT">COUNT_DISTINCT</h2> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT COUNT(DISTINCT seller_id) AS DIST_SELLER FROM kylin_sales;</code></pre></div> + +<h2 id="MAX">MAX</h2> +<p>è¿åä¸åä¸çæ大å¼ãNULL å¼ä¸å æ¬å¨è®¡ç®ä¸ã<br /> +ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT MAX(lstg_site_id) FROM kylin_sales;</code></pre></div> + +<h2 id="MIN">MIN</h2> +<p>è¿åä¸åä¸çæå°å¼ãNULL å¼ä¸å æ¬å¨è®¡ç®ä¸ã<br /> +ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT MIN(lstg_site_id) FROM kylin_sales;</code></pre></div> + +<h2 id="PERCENTILE">PERCENTILE</h2> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT seller_id, PERCENTILE(price, 0.5) FROM kylin_sales GROUP BY seller_id; + +SELECT seller_id, PERCENTILE_APPROX(price, 0.5) FROM kylin_sales GROUP BY seller_id;</code></pre></div> + +<h2 id="SUM">SUM</h2> +<p>è¿åæ°å¼åçæ»æ°ã<br /> +ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT SUM(price) FROM kylin_sales;</code></pre></div> + +<h2 id="TOP_N">TOP_N</h2> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT SUM(price) AS gmv + FROM kylin_sales +INNER JOIN kylin_cal_dt AS kylin_cal_dt + ON kylin_sales.part_dt = kylin_cal_dt.cal_dt + INNER JOIN kylin_category_groupings + ON kylin_sales.leaf_categ_id = kylin_category_groupings.leaf_categ_id AND kylin_sales.lstg_site_id = kylin_category_groupings.site_id + WHERE kylin_cal_dt.cal_dt between DATE '2013-09-01' AND DATE '2013-10-01' AND (lstg_format_name='FP-GTC' OR 'a' = 'b') + GROUP BY kylin_cal_dt.cal_dt; + +SELECT kylin_sales.part_dt, seller_id +FROM kylin_sales +INNER JOIN kylin_cal_dt AS kylin_cal_dt +ON kylin_sales.part_dt = kylin_cal_dt.cal_dt +INNER JOIN kylin_category_groupings +ON kylin_sales.leaf_categ_id = kylin_category_groupings.leaf_categ_id +AND kylin_sales.lstg_site_id = kylin_category_groupings.site_id +GROUP BY +kylin_sales.part_dt, kylin_sales.seller_id ORDER BY SUM(kylin_sales.price) DESC LIMIT 20;</code></pre></div> + +<h2 id="WINDOW">WINDOW</h2> +<p><code class="highlighter-rouge">WINDOW</code> å½æ°å¨åå½åè¡ç¸å ³çä¸ç»è¡¨è¡ä¸æ§è¡è®¡ç®ã<br /> +<em>注æ</em>ï¼<code class="highlighter-rouge">WINDOW</code> å½æ°ä¸å¿ é¡»æ <code class="highlighter-rouge">OVER</code> åå¥</p> + +<h3 id="ROW_NUMBER">ROW_NUMBER</h3> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT lstg_format_name, SUM(price) AS gmv, ROW_NUMBER() OVER() FROM kylin_sales GROUP BY lstg_format_name;</code></pre></div> + +<h3 id="AVG">AVG</h3> +<p>è¿åæ°å¼åçå¹³åå¼ãNULL å¼ä¸å æ¬å¨è®¡ç®ä¸ã<br /> +ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT lstg_format_name, AVG(SUM(price)) OVER(PARTITION BY lstg_format_name) FROM kylin_sales GROUP BY part_dt, lstg_format_name;</code></pre></div> + +<h3 id="RANK">RANK</h3> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT part_dt, lstg_format_name, SUM(price), RANK() OVER(PARTITION BY lstg_format_name ORDER BY part_dt) AS "rank" FROM kylin_sales GROUP BY part_dt, lstg_format_name;</code></pre></div> + +<h3 id="DENSE_RANK">DENSE_RANK</h3> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT part_dt, lstg_format_name, SUM(price), DENSE_RANK() OVER(PARTITION BY lstg_format_name ORDER BY part_dt) AS "dense_rank" FROM kylin_sales GROUP BY part_dt, lstg_format_name;</code></pre></div> + +<h3 id="FIRST_VALUE">FIRST_VALUE</h3> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT part_dt, lstg_format_name, SUM(price) AS gmv, FIRST_VALUE(SUM(price)) OVER(PARTITION BY lstg_format_name ORDER BY part_dt) AS "first" FROM kylin_sales WHERE part_dt < '2012-02-01' GROUP BY part_dt, lstg_format_name;</code></pre></div> + +<h3 id="LAST_VALUE">LAST_VALUE</h3> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT part_dt, lstg_format_name, SUM(price) AS gmv, LAST_VALUE(SUM(price)) OVER(PARTITION BY lstg_format_name ORDER BY part_dt) AS "current" FROM kylin_sales WHERE part_dt < '2012-02-01' GROUP BY part_dt, lstg_format_name;</code></pre></div> + +<h3 id="LAG">LAG</h3> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT part_dt, lstg_format_name, SUM(price) AS gmv, LAG(SUM(price), 1, 0.0) OVER(PARTITION BY lstg_format_name ORDER BY part_dt) AS "prev" FROM kylin_sales WHERE part_dt < '2012-02-01' GROUP BY part_dt, lstg_format_name;</code></pre></div> + +<h3 id="LEAD">LEAD</h3> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT part_dt, lstg_format_name, SUM(price) AS gmv, LEAD(SUM(price), 1, 0.0) OVER(PARTITION BY lstg_format_name ORDER BY part_dt) AS "next" FROM kylin_sales WHERE part_dt < '2012-02-01' GROUP BY part_dt, lstg_format_name;</code></pre></div> + +<h3 id="NTILE">NTILE</h3> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT part_dt, lstg_format_name, SUM(price) AS gmv, NTILE(4) OVER (PARTITION BY lstg_format_name ORDER BY part_dt) AS "quarter" FROM kylin_sales WHERE part_dt < '2012-02-01' GROUP BY part_dt, lstg_format_name;</code></pre></div> + +<h3 id="CASEWHEN">CASE WHEN</h3> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT part_dt, lstg_format_name, SUM(price) AS gmv, (CASE LAG(SUM(price), 1, 0.0) OVER(PARTITION BY lstg_format_name ORDER BY part_dt) WHEN 0.0 THEN 0 ELSE SUM(price)/LAG(SUM(price), 1, 0.0) OVER(PARTITION BY lstg_format_name ORDER BY part_dt) END) AS "prev" FROM kylin_sales WHERE part_dt < '2012-02-01' GROUP BY part_dt, lstg_format_name;</code></pre></div> + +<h3 id="CAST">CAST</h3> +<p><code class="highlighter-rouge">RANGE</code>ï¼<code class="highlighter-rouge">INTERVAL</code> å ³é®åææäºèå´ã<code class="highlighter-rouge">PRECEDING</code> 表示åå 天ï¼ç§/å/æ¶/æ/å¹´ï¼ã<code class="highlighter-rouge">FOLLOWING</code> 表示åå 天ï¼ç§/å/æ¶/æ/å¹´ï¼ã<br /> +ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT part_dt, lstg_format_name, SUM(price) AS gmv, FIRST_VALUE(SUM(price)) OVER (PARTITION BY lstg_format_name ORDER BY CAST(part_dt AS timestamp) RANGE INTERVAL '3' DAY PRECEDING) AS "prev 3 days", LAST_VALUE(SUM(price)) OVER (PARTITION BY lstg_format_name ORDER BY CAST(part_dt AS timestamp) RANGE INTERVAL '3' DAY FOLLOWING) AS "next 3 days" FROM kylin_sales WHERE part_dt < '2012-02-01' GROUP BY part_dt, lstg_format_name;</code></pre></div> + +<h2 id="SUBSTRING">SUBSTRING</h2> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT SUBSTRING(lstg_format_name, 1) FROM kylin_sales;</code></pre></div> + +<h2 id="COALESCE">COALESCE</h2> +<p>ä¾åï¼</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">SELECT COALESCE(lstg_format_name, '888888888888') FROM kylin_sales;</code></pre></div> + +<h2 id="datatype">æ°æ®ç±»å</h2> + +<table> + <tbody> + <tr> + <td>ANY</td> + <td>CHAR</td> + <td>VARCHAR</td> + <td>STRING</td> + <td>BOOLEAN</td> + </tr> + <tr> + <td>BYTE</td> + <td>BINARY</td> + <td>INT</td> + <td>SHORT</td> + <td>LONG</td> + </tr> + <tr> + <td>INTEGER</td> + <td>TINYINT</td> + <td>SMALLINT</td> + <td>BIGINT</td> + <td>TIMESTAMP</td> + </tr> + <tr> + <td>FLOAT</td> + <td>REAL</td> + <td>DOUBLE</td> + <td>DECIMAL</td> + <td>DATETIME</td> + </tr> + <tr> + <td>NUMERIC</td> + <td>DATE</td> + <td>TIME</td> + <td> </td> + <td> </td> + </tr> + </tbody> +</table> + + </article> + </div> + </div> + </div> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<div class="col-md-4 col-lg-4 col-xs-12 col-sm-12 aside1 visible-sm visible-xs visible-md visible-lg" id="nside1" style="margin-top: 5em;float:right;"> + <ul class="nav nav-pills nav-stacked"> + + <li><a href="#titleå¼å§" data-toggle="collapse" id="navtitle">å¼å§</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/index.html" class="list-group-item-lay pjaxlink">æ¦è¿°</a> + </li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleå®è£ " data-toggle="collapse" id="navtitle">å®è£ </a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/install/index.html" class="list-group-item-lay pjaxlink">å®è£ æå</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/install/kylin_cluster.html" class="list-group-item-lay pjaxlink">é群模å¼é¨ç½²</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/install/configuration.html" class="list-group-item-lay pjaxlink">Kylin é ç½®</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/install/kylin_aws_emr.html" class="list-group-item-lay pjaxlink">å¨ AWS EMR ä¸å®è£ Kylin</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/install/kylin_docker.html" class="list-group-item-lay pjaxlink">ç¨ Docker è¿è¡ Kylin</a> + </li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleæç¨" data-toggle="collapse" id="navtitle">æç¨</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink">æ ·ä¾ Cube å¿«éå ¥é¨</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/create_cube.html" class="list-group-item-lay pjaxlink">Cube å建</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink">Cube æ建å Job çæ§</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink">Project Level ACL</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink">ç¨ Spark æ建 Cube</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/cube_streaming.html" class="list-group-item-lay pjaxlink">ä» Kafka æµæ建 Cube</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink">ä¼å Cube æ建</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink">Python 客æ·ç«¯</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">建ç«ç³»ç» Cube</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Cube Planner</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/setup_jdbc_datasource.html" class="list-group-item-lay pjaxlink">å»ºç« JDBC æ°æ®æº</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/hybrid.html" class="list-group-item-lay pjaxlink">Hybrid 模å</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/mysql_metastore.html" class="list-group-item-lay pjaxlink">åºäº MySQL ç Metastore é ç½®</a> + </li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleå·¥å ·éæ" data-toggle="collapse" id="navtitle">å·¥å ·éæ</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/odbc.html" class="list-group-item-lay pjaxlink">ODBC 驱å¨</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/jdbc.html" class="list-group-item-lay pjaxlink">JDBC 驱å¨</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/powerbi.html" class="list-group-item-lay pjaxlink">Excel å Power BI æç¨</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/Qlik.html" class="list-group-item-lay pjaxlink">Qlik Sense éæ</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a> + </li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#title帮å©" data-toggle="collapse" id="navtitle">帮å©</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink">RESTful API</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink">ç¨ API æ建 Cube</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink">ä¼å Cube 设计</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink">ä¼å Cube æ建</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink">å¤ä»½å æ°æ®</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink">æ¸ çåå¨</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/howto/howto_use_cli.html" class="list-group-item-lay pjaxlink">å®ç¨ CLI å·¥å ·</a> + </li> + + + + + + + + + <ul> + </div> +</div> + + + </ul> +</div> + </div> + </div> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<footer id="underfooter"> + <div> + <div class="row"> + <div class="col-md-12 widget"> + <div class="widget-body"> + <div class="footer-img"> + <a href="http://www.apache.org"> + <img id="asf-logo" height="78px" alt="Apache Software Foundation" src="/assets/images/apache_footer.png"> + </a> + </div> + <p style="padding-top: 11px;"> + The contents of this website are © 2015 Apache Software Foundation under the terms of the + <a href="http://www.apache.org/licenses/LICENSE-2.0"> Apache License v2 </a>. + </p> + <p style="margin-bottom: 11px;"> + Apache Kylin and its logo are trademarks of the Apache Software Foundation. + </div> + + </div> + </div> + </div> + <!-- /row of widgets --> + + </div> + <div></div> + +</footer> + + <script src="/assets/js/jquery-1.9.1.min.js"></script> + <script src="/assets/js/bootstrap.min.js"></script> + <script src="/assets/js/main.js"></script> + </body> +</html>
Modified: kylin/site/cn/docs/tutorial/squirrel.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/squirrel.html?rev=1852525&r1=1852524&r2=1852525&view=diff ============================================================================== --- kylin/site/cn/docs/tutorial/squirrel.html (original) +++ kylin/site/cn/docs/tutorial/squirrel.html Wed Jan 30 14:13:48 2019 @@ -1227,6 +1227,10 @@ order by part_dt + + + + <li class="navlist"> <a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a> </li> @@ -1624,6 +1628,193 @@ order by part_dt + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> <a href="/cn/docs/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink">Project Level ACL</a> </li> @@ -2526,6 +2717,10 @@ order by part_dt + + + + <li class="navlist"> <a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Cube Planner</a> </li> @@ -2733,6 +2928,10 @@ order by part_dt + + + + <li class="navlist"> <a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a> </li> @@ -3713,6 +3912,10 @@ order by part_dt + + + + <li class="navlist"> <a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> </li> @@ -3912,6 +4115,10 @@ order by part_dt + + + + <li class="navlist"> <a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> </li> @@ -4289,6 +4496,10 @@ order by part_dt + + + + @@ -4472,6 +4683,10 @@ order by part_dt + + + + <li class="navlist"> <a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> </li> @@ -4595,6 +4810,10 @@ order by part_dt + + + + Modified: kylin/site/cn/docs/tutorial/superset.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/superset.html?rev=1852525&r1=1852524&r2=1852525&view=diff ============================================================================== --- kylin/site/cn/docs/tutorial/superset.html (original) +++ kylin/site/cn/docs/tutorial/superset.html Wed Jan 30 14:13:48 2019 @@ -1154,6 +1154,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a> </li> @@ -1551,6 +1555,193 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> <a href="/cn/docs/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink">Project Level ACL</a> </li> @@ -2453,6 +2644,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Cube Planner</a> </li> @@ -2660,6 +2855,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a> </li> @@ -3640,6 +3839,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> </li> @@ -3839,6 +4042,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> </li> @@ -4216,6 +4423,10 @@ var _hmt = _hmt || []; + + + + @@ -4399,6 +4610,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> </li> @@ -4522,6 +4737,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/cn/docs/tutorial/tableau.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/tableau.html?rev=1852525&r1=1852524&r2=1852525&view=diff ============================================================================== --- kylin/site/cn/docs/tutorial/tableau.html (original) +++ kylin/site/cn/docs/tutorial/tableau.html Wed Jan 30 14:13:48 2019 @@ -1236,6 +1236,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a> </li> @@ -1633,6 +1637,193 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> <a href="/cn/docs/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink">Project Level ACL</a> </li> @@ -2535,6 +2726,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Cube Planner</a> </li> @@ -2742,6 +2937,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a> </li> @@ -3722,6 +3921,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> </li> @@ -3921,6 +4124,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> </li> @@ -4298,6 +4505,10 @@ var _hmt = _hmt || []; + + + + @@ -4481,6 +4692,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> </li> @@ -4604,6 +4819,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/cn/docs/tutorial/tableau_91.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/tableau_91.html?rev=1852525&r1=1852524&r2=1852525&view=diff ============================================================================== --- kylin/site/cn/docs/tutorial/tableau_91.html (original) +++ kylin/site/cn/docs/tutorial/tableau_91.html Wed Jan 30 14:13:48 2019 @@ -1160,6 +1160,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a> </li> @@ -1557,6 +1561,193 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> <a href="/cn/docs/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink">Project Level ACL</a> </li> @@ -2459,6 +2650,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Cube Planner</a> </li> @@ -2666,6 +2861,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a> </li> @@ -3646,6 +3845,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> </li> @@ -3845,6 +4048,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> </li> @@ -4222,6 +4429,10 @@ var _hmt = _hmt || []; + + + + @@ -4405,6 +4616,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> </li> @@ -4528,6 +4743,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/cn/docs/tutorial/use_cube_planner.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/use_cube_planner.html?rev=1852525&r1=1852524&r2=1852525&view=diff ============================================================================== --- kylin/site/cn/docs/tutorial/use_cube_planner.html (original) +++ kylin/site/cn/docs/tutorial/use_cube_planner.html Wed Jan 30 14:13:48 2019 @@ -1268,6 +1268,10 @@ kylin.metrics.monitor-enabled=true</code + + + + <li class="navlist"> <a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a> </li> @@ -1665,6 +1669,193 @@ kylin.metrics.monitor-enabled=true</code + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> <a href="/cn/docs/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink">Project Level ACL</a> </li> @@ -2567,6 +2758,10 @@ kylin.metrics.monitor-enabled=true</code + + + + <li class="navlist"> <a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Cube Planner</a> </li> @@ -2774,6 +2969,10 @@ kylin.metrics.monitor-enabled=true</code + + + + <li class="navlist"> <a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a> </li> @@ -3754,6 +3953,10 @@ kylin.metrics.monitor-enabled=true</code + + + + <li class="navlist"> <a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> </li> @@ -3953,6 +4156,10 @@ kylin.metrics.monitor-enabled=true</code + + + + <li class="navlist"> <a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> </li> @@ -4330,6 +4537,10 @@ kylin.metrics.monitor-enabled=true</code + + + + @@ -4513,6 +4724,10 @@ kylin.metrics.monitor-enabled=true</code + + + + <li class="navlist"> <a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> </li> @@ -4636,6 +4851,10 @@ kylin.metrics.monitor-enabled=true</code + + + + Modified: kylin/site/cn/docs/tutorial/use_dashboard.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/use_dashboard.html?rev=1852525&r1=1852524&r2=1852525&view=diff ============================================================================== --- kylin/site/cn/docs/tutorial/use_dashboard.html (original) +++ kylin/site/cn/docs/tutorial/use_dashboard.html Wed Jan 30 14:13:48 2019 @@ -1238,6 +1238,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a> </li> @@ -1635,6 +1639,193 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> <a href="/cn/docs/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink">Project Level ACL</a> </li> @@ -2537,6 +2728,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Cube Planner</a> </li> @@ -2744,6 +2939,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a> </li> @@ -3724,6 +3923,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> </li> @@ -3923,6 +4126,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> </li> @@ -4300,6 +4507,10 @@ var _hmt = _hmt || []; + + + + @@ -4483,6 +4694,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> </li> @@ -4606,6 +4821,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/cn/docs/tutorial/web.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/web.html?rev=1852525&r1=1852524&r2=1852525&view=diff ============================================================================== --- kylin/site/cn/docs/tutorial/web.html (original) +++ kylin/site/cn/docs/tutorial/web.html Wed Jan 30 14:13:48 2019 @@ -1251,6 +1251,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a> </li> @@ -1648,6 +1652,193 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> <a href="/cn/docs/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink">Project Level ACL</a> </li> @@ -2550,6 +2741,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Cube Planner</a> </li> @@ -2757,6 +2952,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a> </li> @@ -3737,6 +3936,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> </li> @@ -3936,6 +4139,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> </li> @@ -4313,6 +4520,10 @@ var _hmt = _hmt || []; + + + + @@ -4496,6 +4707,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> </li> @@ -4619,6 +4834,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/cn/docs20/install/index.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs20/install/index.html?rev=1852525&r1=1852524&r2=1852525&view=diff ============================================================================== --- kylin/site/cn/docs20/install/index.html (original) +++ kylin/site/cn/docs20/install/index.html Wed Jan 30 14:13:48 2019 @@ -1305,6 +1305,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web Interface</a> </li> @@ -1711,6 +1715,196 @@ var _hmt = _hmt || []; + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL Reference</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> <a href="/docs/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink">Project Level ACL</a> </li> @@ -2631,6 +2825,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a> </li> @@ -2841,6 +3039,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">Use Dashboard</a> </li> @@ -3836,6 +4038,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> </li> @@ -4038,6 +4244,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> </li> @@ -4548,6 +4758,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> </li> @@ -5131,6 +5345,10 @@ var _hmt = _hmt || []; + + + +