svn commit: r1878662 - in /kylin/site: ./ cn/docs31/howto/ cn/docs31/tutorial/ docs31/howto/ docs31/tutorial/ images/tutorial/Kylin-Web-Tutorial/

lidong Tue, 09 Jun 2020 07:16:10 -0700

Author: lidong
Date: Tue Jun  9 14:15:21 2020
New Revision: 1878662

URL: http://svn.apache.org/viewvc?rev=1878662&view=rev
Log:
Update document for KYLIN-3361 KYLIN-4312


Added:
    kylin/site/images/tutorial/Kylin-Web-Tutorial/
    kylin/site/images/tutorial/Kylin-Web-Tutorial/insight-query-part.png   
(with props)
Modified:
    kylin/site/cn/docs31/howto/howto_use_restapi.html
    kylin/site/cn/docs31/tutorial/query_pushdown.html
    kylin/site/cn/docs31/tutorial/sql_reference.html
    kylin/site/cn/docs31/tutorial/web.html
    kylin/site/docs31/howto/howto_use_restapi.html
    kylin/site/docs31/tutorial/query_pushdown.html
    kylin/site/docs31/tutorial/sql_reference.html
    kylin/site/docs31/tutorial/web.html
    kylin/site/feed.xml

Modified: kylin/site/cn/docs31/howto/howto_use_restapi.html
URL: 
http://svn.apache.org/viewvc/kylin/site/cn/docs31/howto/howto_use_restapi.html?rev=1878662&r1=1878661&r2=1878662&view=diff
==============================================================================
--- kylin/site/cn/docs31/howto/howto_use_restapi.html (original)
+++ kylin/site/cn/docs31/howto/howto_use_restapi.html Tue Jun  9 14:15:21 2020
@@ -319,6 +319,7 @@ python -c "import base64; print base64.s
   <li>limit - <code class="highlighter-rouge">optional</code> <code 
class="highlighter-rouge">int</code> Query limit. If limit is set in sql, 
perPage will be ignored.</li>
   <li>acceptPartial - <code class="highlighter-rouge">optional</code> <code 
class="highlighter-rouge">bool</code> Whether accept a partial result or not, 
default be âfalseâ. Set to âfalseâ for production use.</li>
   <li>project - <code class="highlighter-rouge">optional</code> <code 
class="highlighter-rouge">string</code> Project to perform query. Default value 
is âDEFAULTâ.</li>
+  <li>backdoorToggles - <code class="highlighter-rouge">optional</code> <code 
class="highlighter-rouge">map</code> You can set a key/value pair (<code 
class="highlighter-rouge">"DEBUG_TOGGLE_HIT_CUBE":"SimpleCube_01"</code>) to 
specific cube for your query. Default is empty map.</li>
 </ul>
 
 <h4 id="request-sample">Request Sample</h4>

Modified: kylin/site/cn/docs31/tutorial/query_pushdown.html
URL: 
http://svn.apache.org/viewvc/kylin/site/cn/docs31/tutorial/query_pushdown.html?rev=1878662&r1=1878661&r2=1878662&view=diff
==============================================================================
--- kylin/site/cn/docs31/tutorial/query_pushdown.html (original)
+++ kylin/site/cn/docs31/tutorial/query_pushdown.html Tue Jun  9 14:15:21 2020
@@ -264,6 +264,19 @@ kylin.query.pushdown.id1.jdbc.pool-min-i
 
 <p><img src="/images/tutorial/2.1/push_down/push_down_2.png" alt="" /></p>
 
+<h3 id="pushdown-to-presto">Pushdown to Presto</h3>
+
+<p>å¦æä½ å¸ææ¥è¯¢ä¸åå°Prestoï¼ä½ å¯ä»¥å¨ Project çº§å«é
ç½®ä»¥ä¸åæ°ä»¥å¯ç¨ Presto æ¥è¯¢ä¸å (éè¿ KYLIN-4491 å¼å¥)ã</p>
+
+<div class="highlight"><pre><code class="language-groff" 
data-lang="groff">kylin.query.pushdown.runner-class-name=org.apache.kylin.query.pushdown.PushdownRunnerSDKImpl
+kylin.source.jdbc.dialect=presto
+kylin.source.jdbc.adaptor=org.apache.kylin.sdk.datasource.adaptor.PrestoAdaptor
+kylin.query.pushdown.jdbc.url={YOUR_URL}
+kylin.query.pushdown.jdbc.driver=com.facebook.presto.jdbc.PrestoDriver
+kylin.query.pushdown.jdbc.username={USER_NAME}
+kylin.query.pushdown.jdbc.password={PASSWORD}</code></pre></div>
+
+
                                                        </article>
                                                </div>
                                        </div>

Modified: kylin/site/cn/docs31/tutorial/sql_reference.html
URL: 
http://svn.apache.org/viewvc/kylin/site/cn/docs31/tutorial/sql_reference.html?rev=1878662&r1=1878661&r2=1878662&view=diff
==============================================================================
--- kylin/site/cn/docs31/tutorial/sql_reference.html (original)
+++ kylin/site/cn/docs31/tutorial/sql_reference.html Tue Jun  9 14:15:21 2020
@@ -218,7 +218,8 @@ var _hmt = _hmt || [];
 ã<a href="#CAST">CAST</a></p>
 
 <p><a href="#SUBSTRING">SUSTRING</a><br />
-<a href="#COALESCE">COALESCE</a></p>
+<a href="#COALESCE">COALESCE</a><br />
+<a href="#STDDEV_SUM">STDDEV_SUM</a></p>
 
 <h2 id="section-2">æ°æ®ç±»å</h2>
 <p><a href="#datatype">æ°æ®ç±»å</a></p>
@@ -514,6 +515,21 @@ kylin_sales.part_dt, kylin_sales.seller_
 
 <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="stddevsumstddevsum"><a href="#STDDEV_SUM">STDDEV_SUM</a></h2>
+<p>ä¾å: ç¬¬ä¸ä¸ªæ¥è¯¢åç¬¬äºä¸ªæ¥è¯¢æ¯å¯¹ççï¼<code 
class="highlighter-rouge">stddev_sum</code> æ¯ä¸ä¸ªå¨ KYLIN-3361 å¼å¥ç 
UDAFã</p>
+
+<div class="highlight"><pre><code class="language-groff" 
data-lang="groff">select A, stddev_sum(sampling_dim, m)
+from T
+group by A</code></pre></div>
+
+<div class="highlight"><pre><code class="language-groff" 
data-lang="groff">select A, stddev(SUM_M)
+from (
+      select A, sampling_dim, sum(m) as SUM_M
+      from T
+      group by A, sampling_dim
+) a
+group by A</code></pre></div>
+
 <h2 id="datatype">æ°æ®ç±»å</h2>
 
 <table>

Modified: kylin/site/cn/docs31/tutorial/web.html
URL: 
http://svn.apache.org/viewvc/kylin/site/cn/docs31/tutorial/web.html?rev=1878662&r1=1878661&r2=1878662&view=diff
==============================================================================
--- kylin/site/cn/docs31/tutorial/web.html (original)
+++ kylin/site/cn/docs31/tutorial/web.html Tue Jun  9 14:15:21 2020
@@ -234,9 +234,9 @@ var _hmt = _hmt || [];
   </ol>
 </blockquote>
 
-<p>ç±èåæ è¿å¥ âInsightâ é¡µé¢ï¼</p>
+<p>ç±èåæ è¿å¥ âInsightâ é¡µé¢ï¼ä½ å¯ä»¥å¨ 
<strong>Cube</strong> ä¸ææ¡éæ©ä½ å¸ææ¥è¯¢å»ä¸ç Cubeã</p>
 
-<p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/8 query.png" alt="" /></p>
+<p><img src="/images/tutorial/Kylin-Web-Tutorial/insight-query-part.png" 
alt="" /></p>
 
 <ul>
   <li>

Modified: kylin/site/docs31/howto/howto_use_restapi.html
URL: 
http://svn.apache.org/viewvc/kylin/site/docs31/howto/howto_use_restapi.html?rev=1878662&r1=1878661&r2=1878662&view=diff
==============================================================================
--- kylin/site/docs31/howto/howto_use_restapi.html (original)
+++ kylin/site/docs31/howto/howto_use_restapi.html Tue Jun  9 14:15:21 2020
@@ -7859,6 +7859,7 @@ python -c "import base64; print base64.s
   <li>limit - <code class="highlighter-rouge">optional</code> <code 
class="highlighter-rouge">int</code> Query limit. If limit is set in sql, 
perPage will be ignored.</li>
   <li>acceptPartial - <code class="highlighter-rouge">optional</code> <code 
class="highlighter-rouge">bool</code> Whether accept a partial result or not, 
default be âfalseâ. Set to âfalseâ for production use.</li>
   <li>project - <code class="highlighter-rouge">optional</code> <code 
class="highlighter-rouge">string</code> Project to perform query. Default value 
is âDEFAULTâ.</li>
+  <li>backdoorToggles - <code class="highlighter-rouge">optional</code> <code 
class="highlighter-rouge">map</code> You can set a key value pair (<code 
class="highlighter-rouge">"DEBUG_TOGGLE_HIT_CUBE":"SimpleCube_01"</code>) to 
specific cube for your query. Default is empty map.</li>
 </ul>
 
 <h4 id="request-sample">Request Sample</h4>

Modified: kylin/site/docs31/tutorial/query_pushdown.html
URL: 
http://svn.apache.org/viewvc/kylin/site/docs31/tutorial/query_pushdown.html?rev=1878662&r1=1878661&r2=1878662&view=diff
==============================================================================
--- kylin/site/docs31/tutorial/query_pushdown.html (original)
+++ kylin/site/docs31/tutorial/query_pushdown.html Tue Jun  9 14:15:21 2020
@@ -7807,8 +7807,20 @@ kylin.query.pushdown.id1.jdbc.pool-min-i
 
 <p>If query is answered by backup engine, <code class="highlighter-rouge">Is 
Query Push-Down</code> is set to <code class="highlighter-rouge">true</code> in 
the log.</p>
 
-<p><img src="/images/tutorial/2.1/push_down/push_down_2.png" alt="" /><br />
-#</p>
+<p><img src="/images/tutorial/2.1/push_down/push_down_2.png" alt="" /></p>
+
+<h3 id="pushdown-to-presto">Pushdown to Presto</h3>
+
+<p>If you want your query be push down to Presto, you can set following 
configuration in Project level properties (Introduced in KYLIN-4491).</p>
+
+<div class="highlight"><pre><code class="language-groff" 
data-lang="groff">kylin.query.pushdown.runner-class-name=org.apache.kylin.query.pushdown.PushdownRunnerSDKImpl
+kylin.source.jdbc.dialect=presto
+kylin.source.jdbc.adaptor=org.apache.kylin.sdk.datasource.adaptor.PrestoAdaptor
+kylin.query.pushdown.jdbc.url={YOUR_URL}
+kylin.query.pushdown.jdbc.driver=com.facebook.presto.jdbc.PrestoDriver
+kylin.query.pushdown.jdbc.username={USER_NAME}
+kylin.query.pushdown.jdbc.password={PASSWORD}</code></pre></div>
+
 
                                                        </article>
                                                </div>

Modified: kylin/site/docs31/tutorial/sql_reference.html
URL: 
http://svn.apache.org/viewvc/kylin/site/docs31/tutorial/sql_reference.html?rev=1878662&r1=1878661&r2=1878662&view=diff
==============================================================================
--- kylin/site/docs31/tutorial/sql_reference.html (original)
+++ kylin/site/docs31/tutorial/sql_reference.html Tue Jun  9 14:15:21 2020
@@ -7757,7 +7757,8 @@ var _hmt = _hmt || [];
 ã<a href="#CASEWHEN">CASE WHEN</a><br />
 ã<a href="#CAST">CAST</a><br />
 <a href="#SUBSTRING">SUSTRING</a><br />
-<a href="#COALESCE">COALESCE</a></p>
+<a href="#COALESCE">COALESCE</a><br />
+<a href="#STDDEV_SUM">STDDEV_SUM</a></p>
 
 <h2 id="data-type">Data Type</h2>
 
@@ -8056,6 +8057,21 @@ Example:</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="stddevsumstddevsum"><a href="#STDDEV_SUM">STDDEV_SUM</a></h2>
+<p>Example: The first query is shortcut of the second query. <code 
class="highlighter-rouge">stddev_sum</code> is a UDAF which introduced in 
KYLIN-3361.</p>
+
+<div class="highlight"><pre><code class="language-groff" 
data-lang="groff">select A, stddev_sum(sampling_dim, m)
+from T
+group by A</code></pre></div>
+
+<div class="highlight"><pre><code class="language-groff" 
data-lang="groff">select A, stddev(SUM_M)
+from (
+      select A, sampling_dim, sum(m) as SUM_M
+      from T
+      group by A, sampling_dim
+) a
+group by A</code></pre></div>
+
 <h2 id="DATATYPE">DATA TYPE</h2>
 
 <table>

Modified: kylin/site/docs31/tutorial/web.html
URL: 
http://svn.apache.org/viewvc/kylin/site/docs31/tutorial/web.html?rev=1878662&r1=1878661&r2=1878662&view=diff
==============================================================================
--- kylin/site/docs31/tutorial/web.html (original)
+++ kylin/site/docs31/tutorial/web.html Tue Jun  9 14:15:21 2020
@@ -7772,9 +7772,9 @@ Login with passwordï¼KYLIN</p>
   </ol>
 </blockquote>
 
-<p>Go to âInsightâ menu.</p>
+<p>Go to âInsightâ menu. You can specific cube for your query in 
<strong>Cube</strong> DropDownList .</p>
 
-<p><img src="/images/tutorial/1.5/Kylin-Web-Tutorial/8 query.png" alt="" /></p>
+<p><img src="/images/tutorial/Kylin-Web-Tutorial/insight-query-part.png" 
alt="" /></p>
 
 <ul>
   <li>

Modified: kylin/site/feed.xml
URL: 
http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1878662&r1=1878661&r2=1878662&view=diff
==============================================================================
--- kylin/site/feed.xml (original)
+++ kylin/site/feed.xml Tue Jun  9 14:15:21 2020
@@ -19,8 +19,8 @@
     <description>Apache Kylin Home</description>
     <link>http://kylin.apache.org/</link>
     <atom:link href="http://kylin.apache.org/feed.xml"; rel="self" 
type="application/rss+xml"/>
-    <pubDate>Mon, 25 May 2020 06:59:14 -0700</pubDate>
-    <lastBuildDate>Mon, 25 May 2020 06:59:14 -0700</lastBuildDate>
+    <pubDate>Tue, 09 Jun 2020 06:59:12 -0700</pubDate>
+    <lastBuildDate>Tue, 09 Jun 2020 06:59:12 -0700</lastBuildDate>
     <generator>Jekyll v2.5.3</generator>
     
       <item>

Added: kylin/site/images/tutorial/Kylin-Web-Tutorial/insight-query-part.png
URL: 
http://svn.apache.org/viewvc/kylin/site/images/tutorial/Kylin-Web-Tutorial/insight-query-part.png?rev=1878662&view=auto
==============================================================================
Binary file - no diff available.

Propchange: kylin/site/images/tutorial/Kylin-Web-Tutorial/insight-query-part.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

svn commit: r1878662 - in /kylin/site: ./ cn/docs31/howto/ cn/docs31/tutorial/ docs31/howto/ docs31/tutorial/ images/tutorial/Kylin-Web-Tutorial/

Reply via email to