You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by li...@apache.org on 2018/07/02 06:08:51 UTC
svn commit: r1834820 [14/48] - in /kylin/site: ./ about/ 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/08/15/fast-cubing/
blog/2015/09/06/release-v1.0-incubating/ blog...
Modified: kylin/site/cn/docs23/tutorial/create_cube.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs23/tutorial/create_cube.html?rev=1834820&r1=1834819&r2=1834820&view=diff
==============================================================================
--- kylin/site/cn/docs23/tutorial/create_cube.html (original)
+++ kylin/site/cn/docs23/tutorial/create_cube.html Mon Jul 2 06:08:48 2018
@@ -160,7 +160,294 @@ var _hmt = _hmt || [];
<div class="container">
- <div class="row">
+ <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">Cube å建</h1>
+ <article class="post-content" >
+ <h3 id="i-">I. æ°å»ºé¡¹ç®</h3>
+<ol>
+ <li>
+ <p>ç±é¡¶é¨èåæ è¿å
¥ <code class="highlighter-rouge">Model</code> 页é¢ï¼ç¶åç¹å» <code class="highlighter-rouge">Manage Projects</code>ã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/1 manage-prject.png" alt="" /></p>
+ </li>
+ <li>
+ <p>ç¹å» <code class="highlighter-rouge">+ Project</code> æé®æ·»å ä¸ä¸ªæ°ç项ç®ã</p>
+
+ <p><img src="/images/Kylin-Cube-Creation-Tutorial/2 %2Bproject.png" alt="" /></p>
+ </li>
+ <li>
+ <p>å¡«åä¸å表å并ç¹å» <code class="highlighter-rouge">submit</code> æé®æ交请æ±ã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/3 new-project.png" alt="" /></p>
+ </li>
+ <li>
+ <p>æååï¼åºé¨ä¼æ¾ç¤ºéç¥ã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/3.1 pj-created.png" alt="" /></p>
+ </li>
+</ol>
+
+<h3 id="ii-hive">II. åæ¥Hive表</h3>
+<ol>
+ <li>
+ <p>å¨é¡¶é¨èåæ ç¹å» <code class="highlighter-rouge">Model</code>ï¼ç¶åç¹å»å·¦è¾¹ç <code class="highlighter-rouge">Data Source</code> æ ç¾ï¼å®ä¼ååºææå è½½è¿ Kylin ç表ï¼ç¹å» <code class="highlighter-rouge">Load Table</code> æé®ã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/4 +table.png" alt="" /></p>
+ </li>
+ <li>
+ <p>è¾å
¥è¡¨å并ç¹å» <code class="highlighter-rouge">Sync</code> æé®æ交请æ±ã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table.png" alt="" /></p>
+ </li>
+ <li>
+ <p>ãå¯éãå¦æä½ æ³è¦æµè§ hive æ°æ®åºæ¥éæ©è¡¨ï¼ç¹å» <code class="highlighter-rouge">Load Table From Tree</code> æé®ã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/4 +table-tree.png" alt="" /></p>
+ </li>
+ <li>
+ <p>ãå¯éãå±å¼æ°æ®åºèç¹ï¼ç¹å»éæ©è¦å è½½ç表ï¼ç¶åç¹å» <code class="highlighter-rouge">Sync</code> æé®ã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table-tree.png" alt="" /></p>
+ </li>
+ <li>
+ <p>æåçæ¶æ¯å°ä¼å¼¹åºï¼å¨å·¦è¾¹ç <code class="highlighter-rouge">Tables</code> é¨åï¼æ°å è½½ç表已ç»è¢«æ·»å è¿æ¥ãç¹å»è¡¨å°ä¼å±å¼åã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table-info.png" alt="" /></p>
+ </li>
+ <li>
+ <p>å¨åå°ï¼Kylin å°ä¼æ§è¡ MapReduce ä»»å¡è®¡ç®æ°åæ¥è¡¨çåºæ°ï¼cardinalityï¼ï¼ä»»å¡å®æåï¼å·æ°é¡µé¢å¹¶ç¹å»è¡¨åï¼åºæ°å¼å°ä¼æ¾ç¤ºå¨è¡¨ä¿¡æ¯ä¸ã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table-cardinality.png" alt="" /></p>
+ </li>
+</ol>
+
+<h3 id="iii--data-model">III. æ°å»º Data Model</h3>
+<p>å建 cube åï¼éå®ä¹ä¸ä¸ªæ°æ®æ¨¡åãæ°æ®æ¨¡åå®ä¹äºä¸ä¸ªæåï¼star schemaï¼æéªè±ï¼snowflake schemaï¼æ¨¡åãä¸ä¸ªæ¨¡åå¯ä»¥è¢«å¤ä¸ª cube 使ç¨ã</p>
+
+<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 +model.png" alt="" /></p>
+
+<ol>
+ <li>
+ <p>ç¹å»é¡¶é¨ç <code class="highlighter-rouge">Model</code> ï¼ç¶åç¹å» <code class="highlighter-rouge">Models</code> æ ç¾ãç¹å» <code class="highlighter-rouge">+New</code> æé®ï¼å¨ä¸ææ¡ä¸éæ© <code class="highlighter-rouge">New Model</code>ã</p>
+ </li>
+ <li>
+ <p>è¾å
¥ model çåååå¯éçæè¿°ã</p>
+ </li>
+</ol>
+
+<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-name.png" alt="" /></p>
+
+<ol>
+ <li>
+ <p>å¨ <code class="highlighter-rouge">Fact Table</code> ä¸ï¼ä¸ºæ¨¡åéæ©äºå®è¡¨ã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-fact-table.png" alt="" /></p>
+ </li>
+ <li>
+ <p>ãå¯éãç¹å» <code class="highlighter-rouge">Add Lookup Table</code> æé®æ·»å ä¸ä¸ª lookup 表ãéæ©è¡¨ååå
³èç±»åï¼å
è¿æ¥æå·¦è¿æ¥ï¼</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-lookup-table.png" alt="" /></p>
+ </li>
+ <li>
+ <p>ç¹å» <code class="highlighter-rouge">New Join Condition</code> æé®ï¼å·¦è¾¹éæ©äºå®è¡¨çå¤é®ï¼å³è¾¹éæ© lookup 表ç主é®ãå¦ææå¤äºä¸ä¸ª join åéå¤æ§è¡ã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-join-condition.png" alt="" /></p>
+ </li>
+ <li>
+ <p>ç¹å» âOKâï¼éå¤4ï¼5æ¥æ¥æ·»å æ´å¤ç lookup 表ãå®æåï¼ç¹å» âNextâã</p>
+ </li>
+ <li>
+ <p><code class="highlighter-rouge">Dimensions</code> 页é¢å
许éæ©å¨å cube ä¸ç¨ä½ç»´åº¦çåï¼ç¶åç¹å» <code class="highlighter-rouge">Columns</code> åï¼å¨ä¸ææ¡ä¸éæ©éè¦çåã<br />
+ <img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-dimensions.png" alt="" /></p>
+ </li>
+ <li>
+ <p>ç¹å» âNextâ å°è¾¾ âMeasuresâ 页é¢ï¼éæ©ä½ä¸º measure çåï¼å
¶åªè½ä»äºå®è¡¨ä¸éæ©ã</p>
+ </li>
+</ol>
+
+<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-measures.png" alt="" /></p>
+
+<ol>
+ <li>
+ <p>ç¹å» âNextâ å°è¾¾ âSettingsâ 页é¢ï¼å¦æäºå®è¡¨ä¸çæ°æ®æ¯æ¥å¢é¿ï¼éæ© <code class="highlighter-rouge">Partition Date Column</code> ä¸ç¸åºç æ¥æå以åæ¥ææ ¼å¼ï¼å¦åå°±å°å
¶çç½ã</p>
+ </li>
+ <li>
+ <p>ãå¯éãéæ©æ¯å¦éè¦ âtime of the dayâ åï¼é»è®¤æ
åµä¸ä¸º <code class="highlighter-rouge">No</code>ãå¦æéæ© <code class="highlighter-rouge">Yes</code>, éæ© <code class="highlighter-rouge">Partition Time Column</code> ä¸ç¸åºç time å以å time æ ¼å¼</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-partition-column.png" alt="" /></p>
+ </li>
+ <li>
+ <p>ãå¯éãå¦æå¨ä» hive æ½åæ°æ®æ¶åæ³åä¸äºçéï¼å¯ä»¥å¨ <code class="highlighter-rouge">Filter</code> ä¸è¾å
¥çéæ¡ä»¶ã</p>
+ </li>
+ <li>
+ <p>ç¹å» <code class="highlighter-rouge">Save</code> ç¶åéæ© <code class="highlighter-rouge">Yes</code> æ¥ä¿å data modelãå建å®æï¼data model å°±ä¼åå¨å·¦è¾¹ <code class="highlighter-rouge">Models</code> å表ä¸ã<br />
+ <img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-created.png" alt="" /></p>
+ </li>
+</ol>
+
+<h3 id="iv--cube">IV. æ°å»º Cube</h3>
+
+<p>åå»ºå® data modelï¼å¯ä»¥å¼å§å建 cubeã<br />
+ç¹å»é¡¶é¨ <code class="highlighter-rouge">Model</code>ï¼ç¶åç¹å» <code class="highlighter-rouge">Models</code> æ ç¾ãç¹å» <code class="highlighter-rouge">+New</code> æé®ï¼å¨ä¸ææ¡ä¸éæ© <code class="highlighter-rouge">New Cube</code>ã<br />
+ <img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/7 new-cube.png" alt="" /></p>
+
+<p><strong>æ¥éª¤1. Cube ä¿¡æ¯</strong></p>
+
+<ol>
+ <li>éæ© data modelï¼è¾å
¥ cube ååï¼ç¹å» <code class="highlighter-rouge">Next</code> è¿è¡ä¸ä¸æ¥ã</li>
+</ol>
+
+<p>cube ååå¯ä»¥ä½¿ç¨åæ¯ï¼æ°ååä¸å线ï¼ç©ºæ ¼ä¸å
许ï¼ã<code class="highlighter-rouge">Notification Email List</code> æ¯è¿ç¨æ¥éç¥jobæ§è¡æåæ失败æ
åµçé®ç®±å表ã<code class="highlighter-rouge">Notification Events</code> æ¯è§¦åäºä»¶çç¶æã</p>
+
+<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/7 cube-info.png" alt="" /></p>
+
+<p><strong>æ¥éª¤2. 维度</strong></p>
+
+<ol>
+ <li>
+ <p>ç¹å» <code class="highlighter-rouge">Add Dimension</code>ï¼å¨å¼¹çªä¸æ¾ç¤ºçäºå®è¡¨å lookup 表éå¾éè¾å
¥éè¦çåãLookup 表çåæ2个é项ï¼âNormalâ å âDerivedâï¼é»è®¤ï¼ãâNormalâ æ·»å ä¸ä¸ªæ®éç¬ç«ç维度åï¼âDerivedâ æ·»å ä¸ä¸ª derived 维度ï¼derived 维度ä¸ä¼è®¡ç®å
¥ cubeï¼å°ç±äºå®è¡¨çå¤é®æ¨ç®åºãé
读æ´å¤ãå¦ä½ä¼å cubeãï¼/docs15/howto/howto_optimize_cubes.htmlï¼ã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/7 cube-dimension-batch.png" alt="" /></p>
+ </li>
+ <li>
+ <p>éæ©ææ维度åç¹å» âNextâã</p>
+ </li>
+</ol>
+
+<p><strong>æ¥éª¤3. 度é</strong></p>
+
+<ol>
+ <li>
+ <p>ç¹å» <code class="highlighter-rouge">+Measure</code> æé®æ·»å ä¸ä¸ªæ°ç度éã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 meas-+meas.png" alt="" /></p>
+ </li>
+ <li>
+ <p>æ ¹æ®å®ç表达å¼å
±æ8ç§ä¸åç±»åç度éï¼<code class="highlighter-rouge">SUM</code>ã<code class="highlighter-rouge">MAX</code>ã<code class="highlighter-rouge">MIN</code>ã<code class="highlighter-rouge">COUNT</code>ã<code class="highlighter-rouge">COUNT_DISTINCT</code> <code class="highlighter-rouge">TOP_N</code>, <code class="highlighter-rouge">EXTENDED_COLUMN</code> å <code class="highlighter-rouge">PERCENTILE</code>ã请åçéæ© <code class="highlighter-rouge">COUNT_DISTINCT</code> å <code class="highlighter-rouge">TOP_N</code> è¿åç±»åï¼å®ä¸ cube ç大å°ç¸å
³ã</p>
+ <ul>
+ <li>
+ <p>SUM</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-sum.png" alt="" /></p>
+ </li>
+ <li>
+ <p>MIN</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-min.png" alt="" /></p>
+ </li>
+ <li>
+ <p>MAX</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-max.png" alt="" /></p>
+ </li>
+ <li>
+ <p>COUNT</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-count.png" alt="" /></p>
+ </li>
+ <li>
+ <p>DISTINCT_COUNT<br />
+è¿ä¸ªåº¦éæ两个å®ç°ï¼<br />
+1ï¼è¿ä¼¼å®ç° HyperLogLogï¼éæ©å¯æ¥åçé误çï¼ä½é误çéè¦æ´å¤åå¨ï¼<br />
+2ï¼ç²¾ç¡®å®ç° bitmapï¼å
·ä½éå¶è¯·ç https://issues.apache.org/jira/browse/KYLIN-1186ï¼</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-distinct.png" alt="" /></p>
+ </li>
+ </ul>
+
+ <p>注æï¼distinct æ¯ä¸ç§é常éçæ°æ®ç±»åï¼åå
¶ä»åº¦éç¸æ¯æ建åæ¥è¯¢ä¼æ´æ
¢ã</p>
+
+ <ul>
+ <li>TOP_N<br />
+TopN 度éå¨æ¯ä¸ªç»´åº¦ç»åæ¶é¢è®¡ç®ï¼å®æ¯æªé¢è®¡ç®çå¨æ¥è¯¢æ¶é´ä¸æ§è½æ´å¥½ï¼éè¦ä¸¤ä¸ªåæ°ï¼ä¸æ¯è¢«ç¨æ¥ä½ä¸º Top è®°å½ç度éåï¼Kylin å°è®¡ç®å®ç SUM å¼å¹¶åååºæåï¼äºæ¯ literal IDï¼ä»£è¡¨æ Top çè®°å½ï¼ä¾å¦ seller_idï¼</li>
+ </ul>
+
+ <p>åççéæ©è¿åç±»åï¼å°å³å®å¤å° top è®°å½è¢«çå¯ï¼top 10, top 100, top 500, top 1000, top 5000 or top 10000ã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-topn.png" alt="" /></p>
+
+ <ul>
+ <li>
+ <p>EXTENDED_COLUMN<br />
+Extended_Column ä½ä¸ºåº¦éæ¯ä½ä¸ºç»´åº¦æ´èç空é´ãä¸ååé¶ä¸åå¯ä»¥çææ°çåã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-extended_column.PNG" alt="" /></p>
+ </li>
+ <li>
+ <p>PERCENTILE<br />
+Percentile 代表äºç¾åæ¯ãå¼è¶å¤§ï¼é误就è¶å°ã100为æåéçå¼ã</p>
+
+ <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-percentile.PNG" alt="" /></p>
+ </li>
+ </ul>
+ </li>
+</ol>
+
+<p><strong>æ¥éª¤4. æ´æ°è®¾ç½®</strong></p>
+
+<p>è¿ä¸æ¥éª¤æ¯ä¸ºå¢éæ建 cube è设计çã</p>
+
+<p><code class="highlighter-rouge">Auto Merge Thresholds</code>: èªå¨å并å°ç segments å°ä¸ççè³æ´å¤§ç segmentãå¦æä¸æ³èªå¨å并ï¼å é¤é»è®¤2个é项ã</p>
+
+<p><code class="highlighter-rouge">Volatile Range</code>: é»è®¤ä¸º0ï¼ä¼èªå¨å并ææå¯è½ç cube segmentsï¼æè
ç¨ âAuto Mergeâ å°ä¸ä¼å并ææ°ç [Volatile Range] 天ç cube segmentsã</p>
+
+<p><code class="highlighter-rouge">Retention Threshold</code>: åªä¼ä¿å cube è¿å»å 天ç segmentï¼æ§ç segment å°ä¼èªå¨ä»å¤´é¨å é¤ï¼0表示ä¸å¯ç¨è¿ä¸ªåè½ã</p>
+
+<p><code class="highlighter-rouge">Partition Start Date</code>: cube çå¼å§æ¥æ.</p>
+
+<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/9 refresh-setting1.png" alt="" /></p>
+
+<p><strong>æ¥éª¤5. é«çº§è®¾ç½®</strong></p>
+
+<p><code class="highlighter-rouge">Aggregation Groups</code>: Cube ä¸ç维度å¯ä»¥ååå°å¤ä¸ªèåç»ä¸ãé»è®¤ kylin ä¼æææ维度æ¾å¨ä¸ä¸ªèåç»ï¼å½ç»´åº¦è¾å¤æ¶ï¼äº§ççç»åæ°å¯è½æ¯å·¨å¤§çï¼ä¼é æ Cube çç¸ï¼å¦æä½ å¾å¥½çäºè§£ä½ çæ¥è¯¢æ¨¡å¼ï¼é£ä¹ä½ å¯ä»¥å建å¤ä¸ªèåç»ãå¨æ¯ä¸ªèåç»å
ï¼ä½¿ç¨ âMandatory Dimensionsâ, âHierarchy Dimensionsâ å âJoint Dimensionsâ æ¥è¿ä¸æ¥ä¼å维度ç»åã</p>
+
+<p><code class="highlighter-rouge">Mandatory Dimensions</code>: å¿
è¦ç»´åº¦ï¼ç¨äºæ»æ¯åºç°ç维度ãä¾å¦ï¼å¦æä½ çæ¥è¯¢ä¸æ»æ¯ä¼å¸¦æ âORDER_DATEâ å为 group by æ è¿æ»¤æ¡ä»¶, é£ä¹å®å¯ä»¥è¢«å£°æ为å¿
è¦ç»´åº¦ãè¿æ ·ä¸æ¥ï¼ææä¸å«æ¤ç»´åº¦ç cuboid å°±å¯ä»¥è¢«è·³è¿è®¡ç®ã</p>
+
+<p><code class="highlighter-rouge">Hierarchy Dimensions</code>: å±çº§ç»´åº¦ï¼ä¾å¦ âå½å®¶â -> âçâ -> âå¸â æ¯ä¸ä¸ªå±çº§ï¼ä¸ç¬¦åæ¤å±çº§å
³ç³»ç cuboid å¯ä»¥è¢«è·³è¿è®¡ç®ï¼ä¾å¦ [âçâ], [âå¸â]. å®ä¹å±çº§ç»´åº¦æ¶ï¼å°ç¶çº§å«ç»´åº¦æ¾å¨å维度ç左边ã</p>
+
+<p><code class="highlighter-rouge">Joint Dimensions</code>:èå维度ï¼æäºç»´åº¦å¾å¾ä¸èµ·åºç°ï¼æè
å®ä»¬çåºæ°é常æ¥è¿ï¼æ1:1æ å°å
³ç³»ï¼ãä¾å¦ âuser_idâ å âemailâãæå¤ä¸ªç»´åº¦å®ä¹ä¸ºç»åå
³ç³»åï¼ææä¸ç¬¦åæ¤å
³ç³»ç cuboids ä¼è¢«è·³è¿è®¡ç®ã</p>
+
+<p>å
³äºæ´å¤ç»´åº¦ä¼åï¼è¯·é
读è¿ä¸ªå客: <a href="/blog/2016/02/18/new-aggregation-group/">æ°çèåç»</a></p>
+
+<p><code class="highlighter-rouge">Rowkeys</code>: æ¯ç±ç»´åº¦ç¼ç å¼ç»æãâDictionaryâ ï¼åå
¸ï¼æ¯é»è®¤çç¼ç æ¹å¼; åå
¸åªè½å¤çä¸ä½åºæ°ï¼å°äºä¸åä¸ï¼ç维度ï¼å¦æ维度åºæ°å¾é«ï¼å¦å¤§äº1åä¸), éæ© âfalseâ ç¶å为维度è¾å
¥åéçé¿åº¦ï¼é常æ¯é£åçæ大é¿åº¦å¼; å¦æè¶
è¿æ大å¼ï¼ä¼è¢«æªæã请注æï¼å¦æ没æåå
¸ç¼ç ï¼cube ç大å°å¯è½ä¼é常大ã</p>
+
+<p>ä½ å¯ä»¥ææ½ç»´åº¦åå»è°æ´å
¶å¨ rowkey ä¸ä½ç½®; ä½äºrowkeyåé¢çåï¼å°å¯ä»¥ç¨æ¥å¤§å¹
缩å°æ¥è¯¢çèå´ãéå¸¸å»ºè®®å° mandantory 维度æ¾å¨å¼å¤´, ç¶åæ¯å¨è¿æ»¤ ( where æ¡ä»¶)ä¸èµ·å°å¾å¤§ä½ç¨ç维度ï¼å¦æå¤ä¸ªåé½ä¼è¢«ç¨äºè¿æ»¤ï¼å°é«åºæ°ç维度ï¼å¦ user_idï¼æ¾å¨ä½åºæ°ç维度ï¼å¦ ageï¼çåé¢ã</p>
+
+<p><code class="highlighter-rouge">Mandatory Cuboids</code>: 维度ç»åç½ååãç¡®ä¿ä½ æ³è¦æ建ç cuboid è½è¢«æ建ã</p>
+
+<p><code class="highlighter-rouge">Cube Engine</code>: cube æ建å¼æãæ两ç§ï¼MapReduce å Sparkãå¦æä½ ç cube åªæç®å度éï¼SUM, MIN, MAX)ï¼å»ºè®®ä½¿ç¨ Sparkãå¦æ cube ä¸æå¤æç±»å度éï¼COUNT DISTINCT, TOP_Nï¼ï¼å»ºè®®ä½¿ç¨ MapReduceã</p>
+
+<p><code class="highlighter-rouge">Advanced Dictionaries</code>: âGlobal Dictionaryâ æ¯ç¨äºç²¾ç¡®è®¡ç® COUNT DISTINCT çåå
¸, å®ä¼å°ä¸ä¸ªé integerçå¼è½¬æ integerï¼ä»¥ä¾¿äº bitmap è¿è¡å»éãå¦æä½ è¦è®¡ç® COUNT DISTINCT çåæ¬èº«å·²ç»æ¯ integer ç±»åï¼é£ä¹ä¸éè¦å®ä¹ Global Dictionaryã Global Dictionary ä¼è¢«ææ segment å
±äº«ï¼å æ¤æ¯æå¨è·¨ segments ä¹é´åä¸å·å»éæä½ã请注æï¼Global Dictionary éçæ°æ®çå è½½ï¼å¯è½ä¼ä¸æå大ã</p>
+
+<p>âSegment Dictionaryâ æ¯å¦ä¸ä¸ªç¨äºç²¾ç¡®è®¡ç® COUNT DISTINCT çåå
¸ï¼ä¸ Global Dictionary ä¸åçæ¯ï¼å®æ¯åºäºä¸ä¸ª segment çå¼æ建çï¼å æ¤ä¸æ¯æè·¨ segments çæ±æ»è®¡ç®ãå¦æä½ ç cube ä¸æ¯ååºçæè
è½ä¿è¯ä½ çææ SQL æç
§ partition_column è¿è¡ group by, é£ä¹ä½ åºè¯¥ä½¿ç¨ âSegment Dictionaryâ èä¸æ¯ âGlobal Dictionaryâï¼è¿æ ·å¯ä»¥é¿å
å个åå
¸è¿å¤§çé®é¢ã</p>
+
+<p>请注æï¼âGlobal Dictionaryâ å âSegment Dictionaryâ é½æ¯ååç¼ç çåå
¸ï¼ä»
ç¨äº COUNT DISTINCT 计ç®(å°é integer ç±»å转æ integer ç¨äº bitmap计ç®)ï¼ä»ä»¬ä¸æ¯æ解ç ï¼å æ¤ä¸è½ä¸ºæ®é维度ç¼ç ã</p>
+
+<p><code class="highlighter-rouge">Advanced Snapshot Table</code>: 为å
¨å± lookup 表è设计ï¼æä¾ä¸åçåå¨ç±»åã</p>
+
+<p><code class="highlighter-rouge">Advanced ColumnFamily</code>: å¦ææè¶
è¿ä¸ä¸ªçCOUNT DISTINCT æ TopN 度é, ä½ å¯ä»¥å°å®ä»¬æ¾å¨æ´å¤åç°ä¸ï¼ä»¥ä¼åä¸HBase çI/Oã</p>
+
+<p><strong>æ¥éª¤6. éåé
ç½®</strong></p>
+
+<p>Kylin å
è®¸å¨ Cube 级å«è¦çé¨å kylin.properties ä¸çé
ç½®ï¼ä½ å¯ä»¥å¨è¿éå®ä¹è¦ççå±æ§ãå¦æä½ æ²¡æè¦é
ç½®çï¼ç¹å» <code class="highlighter-rouge">Next</code> æé®ã</p>
+
+<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/10 configuration.PNG" alt="" /></p>
+
+<p><strong>æ¥éª¤7. æ¦è§ & ä¿å</strong></p>
+
+<p>ä½ å¯ä»¥æ¦è§ä½ ç cube 并è¿åä¹åçæ¥éª¤è¿è¡ä¿®æ¹ãç¹å» <code class="highlighter-rouge">Save</code> æé®å®æ cube å建ã</p>
+
+<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/11 overview.PNG" alt="" /></p>
+
+<p>æåï¼cube å建好äºï¼ä½ å¯ä»¥å»æ建åç©å®äºã</p>
+
+ </article>
+ </div>
+ </div>
+ </div>
<!--
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
@@ -179,17 +466,2253 @@ var _hmt = _hmt || [];
* 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">
+<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" class="navtitle">å¼å§</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/index.html" class="list-group-item-lay pjaxlink ">æ¦è¿°</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </div>
+</div>
+
+ <li><a href="#titleå®è£
" data-toggle="collapse" class="navtitle">å®è£
</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/install/index.html" class="list-group-item-lay pjaxlink ">å®è£
æå</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/install/kylin_cluster.html" class="list-group-item-lay pjaxlink ">Cluster 模å¼ä¸é¨ç½²</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/install/configuration.html" class="list-group-item-lay pjaxlink ">Kylin é
ç½®</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/install/advance_settings.html" class="list-group-item-lay pjaxlink ">é«çº§è®¾ç½®</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/install/kylin_aws_emr.html" class="list-group-item-lay pjaxlink ">å¨ AWS EMR ä¸ å®è£
Kylin</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/install/kylin_docker.html" class="list-group-item-lay pjaxlink ">ç¨ Docker è¿è¡ Kylin</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </div>
+</div>
+
+ <li><a href="#titleæç¨" data-toggle="collapse" class="navtitle">æç¨</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink ">æ ·ä¾ Cube å¿«éå
¥é¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink ">Web çé¢</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink ">Cube å建</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink ">Cube æ建å Job çæ§</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink ">Project Level ACL</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink ">ç¨ Spark æ建 Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_streaming.html" class="list-group-item-lay pjaxlink ">ä» Kafka æµæ建 Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink ">ä¼å Cube æ建</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink ">Python 客æ·ç«¯</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
- <li><a href="#titleå¼å§" data-toggle="collapse" class="navtitle">å¼å§</a></li>
- <div class="collapse in">
- <div class="list-group" id="list1">
- <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink ">建ç«ç³»ç» Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink ">ä½¿ç¨ Cube Planner</a>
+ </li>
+
+
@@ -252,39 +2775,26 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/index.html" class="list-group-item-lay pjaxlink ">æ¦è¿°</a>
- </li>
-
-
-
-
-
-
-
-
- <ul>
- </div>
-</div>
+
+
+
+
+
+
+
+
+
+
+
- <li><a href="#titleå®è£
" data-toggle="collapse" class="navtitle">å®è£
</a></li>
- <div class="collapse in">
- <div class="list-group" id="list1">
- <ul>
+
-
-
-
-
-
-
+
-
-
-
+
@@ -357,39 +2867,18 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/install/manual_install_guide.html" class="list-group-item-lay pjaxlink ">æå¨å®è£
æå</a>
- </li>
-
-
-
-
-
-
-
-
- <ul>
- </div>
-</div>
+
- <li><a href="#titleæç¨" data-toggle="collapse" class="navtitle">æç¨</a></li>
- <div class="collapse in">
- <div class="list-group" id="list1">
- <ul>
+
-
-
-
-
-
-
+
-
-
-
+
+
+
@@ -414,9 +2903,22 @@ var _hmt = _hmt || [];
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink ">ä½¿ç¨ Dashboard</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
@@ -474,21 +2976,12 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink ">Cube å建</a>
- </li>
-
-
-
-
-
+
-
-
-
+
@@ -578,12 +3071,30 @@ var _hmt = _hmt || [];
<li class="navlist">
- <a href="/cn/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink ">Cube æ建å Job çæ§</a>
+ <a href="/cn/docs23/tutorial/setup_jdbc_datasource.html" class="list-group-item-lay pjaxlink ">å»ºç« JDBC æ°æ®æº</a>
</li>
+
+
+
+
+ <ul>
+ </div>
+</div>
+
+ <li><a href="#titleå·¥å
·éæ" data-toggle="collapse" class="navtitle">å·¥å
·éæ</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul>
+
+
+
+
+
+
@@ -728,9 +3239,22 @@ var _hmt = _hmt || [];
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink ">ODBC 驱å¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
@@ -743,17 +3267,13 @@ var _hmt = _hmt || [];
-
-
-
+
-
+
-
-
-
+
@@ -856,9 +3376,22 @@ var _hmt = _hmt || [];
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/jdbc.html" class="list-group-item-lay pjaxlink ">JDBC 驱å¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
@@ -902,21 +3435,24 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink ">Web çé¢</a>
- </li>
-
-
-
-
-
+
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -1024,7 +3560,7 @@ var _hmt = _hmt || [];
<li class="navlist">
- <a href="/cn/docs23/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink ">Python 客æ·ç«¯å·¥å
ጼ</a>
+ <a href="/cn/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink ">Tableau 8</a>
</li>
@@ -1174,8 +3710,44 @@ var _hmt = _hmt || [];
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
<li class="navlist">
- <a href="/cn/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink ">Tableau</a>
+ <a href="/cn/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink ">Tableau 9</a>
</li>
@@ -1330,7 +3902,7 @@ var _hmt = _hmt || [];
<li class="navlist">
- <a href="/cn/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink ">Tableau 9</a>
+ <a href="/cn/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink ">Excel å Power BI æç¨</a>
</li>
@@ -1462,22 +4034,9 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink ">MS ExcelåPower BIæç¨</a>
- </li>
-
-
-
-
-
-
-
-
-
-
@@ -1544,13 +4103,17 @@ var _hmt = _hmt || [];
-
+
+
+
-
+
-
+
+
+
@@ -1591,21 +4154,10 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink ">ODBC 驱å¨ç¨åº</a>
- </li>
-
-
-
-
-
-
-
-
-
+
@@ -1682,39 +4234,16 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/tutorial/Qlik.html" class="list-group-item-lay pjaxlink ">Qlik Sense éæ</a>
- </li>
-
-
-
-
-
-
-
-
- <ul>
- </div>
-</div>
+
- <li><a href="#title帮å©" data-toggle="collapse" class="navtitle">帮å©</a></li>
- <div class="collapse in">
- <div class="list-group" id="list1">
- <ul>
+
-
-
-
-
-
-
+
-
-
-
+
@@ -1727,21 +4256,12 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink ">å¤ä»½å
æ°æ®</a>
- </li>
-
-
-
-
-
+
-
-
-
+
@@ -1759,7 +4279,7 @@ var _hmt = _hmt || [];
<li class="navlist">
- <a href="/cn/docs23/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink ">ç¨ API æ建 Cube</a>
+ <a href="/cn/docs23/tutorial/squirrel.html" class="list-group-item-lay pjaxlink ">SQuirreL</a>
</li>
@@ -1793,22 +4313,9 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink ">æ¸
çåå¨</a>
- </li>
-
-
-
-
-
-
-
-
-
-
@@ -1836,21 +4343,12 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink ">Kylin JDBC Driver</a>
- </li>
-
-
-
-
-
+
-
-
-
+
@@ -1886,7 +4384,7 @@ var _hmt = _hmt || [];
<li class="navlist">
- <a href="/cn/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink ">ä¼å Cube æ建</a>
+ <a href="/cn/docs23/tutorial/Qlik.html" class="list-group-item-lay pjaxlink ">Qlik Sense éæ</a>
</li>
@@ -1900,296 +4398,287 @@ var _hmt = _hmt || [];
</div>
</div>
+ <li><a href="#title帮å©" data-toggle="collapse" class="navtitle">帮å©</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul>
+
- </ul>
-</div>
- <div class="col-md-8 col-lg-8 col-xs-12 col-sm-12 aside2">
- <div id="container" class="docs">
- <div id="pjax">
- <h1 class="post-title">Cube å建</h1>
- <article class="post-content" >
- <h3 id="i-">I. æ°å»ºé¡¹ç®</h3>
-<ol>
- <li>
- <p>ç±é¡¶é¨èåæ è¿å
¥ <code class="highlighter-rouge">Model</code> 页é¢ï¼ç¶åç¹å» <code class="highlighter-rouge">Manage Projects</code>ã</p>
-
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/1 manage-prject.png" alt="" /></p>
- </li>
- <li>
- <p>ç¹å» <code class="highlighter-rouge">+ Project</code> æé®æ·»å ä¸ä¸ªæ°ç项ç®ã</p>
-
- <p><img src="/images/Kylin-Cube-Creation-Tutorial/2 %2Bproject.png" alt="" /></p>
- </li>
- <li>
- <p>å¡«åä¸å表å并ç¹å» <code class="highlighter-rouge">submit</code> æé®æ交请æ±ã</p>
-
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/3 new-project.png" alt="" /></p>
- </li>
- <li>
- <p>æååï¼åºé¨ä¼æ¾ç¤ºéç¥ã</p>
-
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/3.1 pj-created.png" alt="" /></p>
- </li>
-</ol>
-
-<h3 id="ii-hive">II. åæ¥Hive表</h3>
-<ol>
- <li>
- <p>å¨é¡¶é¨èåæ ç¹å» <code class="highlighter-rouge">Model</code>ï¼ç¶åç¹å»å·¦è¾¹ç <code class="highlighter-rouge">Data Source</code> æ ç¾ï¼å®ä¼ååºææå è½½è¿ Kylin ç表ï¼ç¹å» <code class="highlighter-rouge">Load Table</code> æé®ã</p>
-
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/4 +table.png" alt="" /></p>
- </li>
- <li>
- <p>è¾å
¥è¡¨å并ç¹å» <code class="highlighter-rouge">Sync</code> æé®æ交请æ±ã</p>
-
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table.png" alt="" /></p>
- </li>
- <li>
- <p>ãå¯éãå¦æä½ æ³è¦æµè§ hive æ°æ®åºæ¥éæ©è¡¨ï¼ç¹å» <code class="highlighter-rouge">Load Table From Tree</code> æé®ã</p>
-
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/4 +table-tree.png" alt="" /></p>
- </li>
- <li>
- <p>ãå¯éãå±å¼æ°æ®åºèç¹ï¼ç¹å»éæ©è¦å è½½ç表ï¼ç¶åç¹å» <code class="highlighter-rouge">Sync</code> æé®ã</p>
-
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table-tree.png" alt="" /></p>
- </li>
- <li>
- <p>æåçæ¶æ¯å°ä¼å¼¹åºï¼å¨å·¦è¾¹ç <code class="highlighter-rouge">Tables</code> é¨åï¼æ°å è½½ç表已ç»è¢«æ·»å è¿æ¥ãç¹å»è¡¨å°ä¼å±å¼åã</p>
-
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table-info.png" alt="" /></p>
- </li>
- <li>
- <p>å¨åå°ï¼Kylin å°ä¼æ§è¡ MapReduce ä»»å¡è®¡ç®æ°åæ¥è¡¨çåºæ°ï¼cardinalityï¼ï¼ä»»å¡å®æåï¼å·æ°é¡µé¢å¹¶ç¹å»è¡¨åï¼åºæ°å¼å°ä¼æ¾ç¤ºå¨è¡¨ä¿¡æ¯ä¸ã</p>
-
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/5 hive-table-cardinality.png" alt="" /></p>
- </li>
-</ol>
-
-<h3 id="iii--data-model">III. æ°å»º Data Model</h3>
-<p>å建 cube åï¼éå®ä¹ä¸ä¸ªæ°æ®æ¨¡åãæ°æ®æ¨¡åå®ä¹äºä¸ä¸ªæåï¼star schemaï¼æéªè±ï¼snowflake schemaï¼æ¨¡åãä¸ä¸ªæ¨¡åå¯ä»¥è¢«å¤ä¸ª cube 使ç¨ã</p>
-
-<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 +model.png" alt="" /></p>
-
-<ol>
- <li>
- <p>ç¹å»é¡¶é¨ç <code class="highlighter-rouge">Model</code> ï¼ç¶åç¹å» <code class="highlighter-rouge">Models</code> æ ç¾ãç¹å» <code class="highlighter-rouge">+New</code> æé®ï¼å¨ä¸ææ¡ä¸éæ© <code class="highlighter-rouge">New Model</code>ã</p>
- </li>
- <li>
- <p>è¾å
¥ model çåååå¯éçæè¿°ã</p>
- </li>
-</ol>
-
-<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-name.png" alt="" /></p>
-
-<ol>
- <li>
- <p>å¨ <code class="highlighter-rouge">Fact Table</code> ä¸ï¼ä¸ºæ¨¡åéæ©äºå®è¡¨ã</p>
-
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-fact-table.png" alt="" /></p>
- </li>
- <li>
- <p>ãå¯éãç¹å» <code class="highlighter-rouge">Add Lookup Table</code> æé®æ·»å ä¸ä¸ª lookup 表ãéæ©è¡¨ååå
³èç±»åï¼å
è¿æ¥æå·¦è¿æ¥ï¼</p>
-
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-lookup-table.png" alt="" /></p>
- </li>
- <li>
- <p>ç¹å» <code class="highlighter-rouge">New Join Condition</code> æé®ï¼å·¦è¾¹éæ©äºå®è¡¨çå¤é®ï¼å³è¾¹éæ© lookup 表ç主é®ãå¦ææå¤äºä¸ä¸ª join åéå¤æ§è¡ã</p>
-
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-join-condition.png" alt="" /></p>
- </li>
- <li>
- <p>ç¹å» âOKâï¼éå¤4ï¼5æ¥æ¥æ·»å æ´å¤ç lookup 表ãå®æåï¼ç¹å» âNextâã</p>
- </li>
- <li>
- <p><code class="highlighter-rouge">Dimensions</code> 页é¢å
许éæ©å¨å cube ä¸ç¨ä½ç»´åº¦çåï¼ç¶åç¹å» <code class="highlighter-rouge">Columns</code> åï¼å¨ä¸ææ¡ä¸éæ©éè¦çåã<br />
- <img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-dimensions.png" alt="" /></p>
- </li>
- <li>
- <p>ç¹å» âNextâ å°è¾¾ âMeasuresâ 页é¢ï¼éæ©ä½ä¸º measure çåï¼å
¶åªè½ä»äºå®è¡¨ä¸éæ©ã</p>
- </li>
-</ol>
-
-<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-measures.png" alt="" /></p>
-
-<ol>
- <li>
- <p>ç¹å» âNextâ å°è¾¾ âSettingsâ 页é¢ï¼å¦æäºå®è¡¨ä¸çæ°æ®æ¯æ¥å¢é¿ï¼éæ© <code class="highlighter-rouge">Partition Date Column</code> ä¸ç¸åºç æ¥æå以åæ¥ææ ¼å¼ï¼å¦åå°±å°å
¶çç½ã</p>
- </li>
- <li>
- <p>ãå¯éãéæ©æ¯å¦éè¦ âtime of the dayâ åï¼é»è®¤æ
åµä¸ä¸º <code class="highlighter-rouge">No</code>ãå¦æéæ© <code class="highlighter-rouge">Yes</code>, éæ© <code class="highlighter-rouge">Partition Time Column</code> ä¸ç¸åºç time å以å time æ ¼å¼</p>
-
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-partition-column.png" alt="" /></p>
- </li>
- <li>
- <p>ãå¯éãå¦æå¨ä» hive æ½åæ°æ®æ¶åæ³åä¸äºçéï¼å¯ä»¥å¨ <code class="highlighter-rouge">Filter</code> ä¸è¾å
¥çéæ¡ä»¶ã</p>
- </li>
- <li>
- <p>ç¹å» <code class="highlighter-rouge">Save</code> ç¶åéæ© <code class="highlighter-rouge">Yes</code> æ¥ä¿å data modelãå建å®æï¼data model å°±ä¼åå¨å·¦è¾¹ <code class="highlighter-rouge">Models</code> å表ä¸ã<br />
- <img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/6 model-created.png" alt="" /></p>
- </li>
-</ol>
-
-<h3 id="iii--cube">III. æ°å»º Cube</h3>
-
-<p>åå»ºå® data modelï¼å¯ä»¥å¼å§å建 cubeã<br />
-ç¹å»é¡¶é¨ <code class="highlighter-rouge">Model</code>ï¼ç¶åç¹å» <code class="highlighter-rouge">Models</code> æ ç¾ãç¹å» <code class="highlighter-rouge">+New</code> æé®ï¼å¨ä¸ææ¡ä¸éæ© <code class="highlighter-rouge">New Cube</code>ã<br />
- <img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/7 new-cube.png" alt="" /></p>
-
-<p><strong>æ¥éª¤1. Cube ä¿¡æ¯</strong></p>
-<ol>
- <li>éæ© data modelï¼è¾å
¥ cube ååï¼ç¹å» <code class="highlighter-rouge">Next</code> è¿è¡ä¸ä¸æ¥ã</li>
-</ol>
-<p>cube ååå¯ä»¥ä½¿ç¨åæ¯ï¼æ°ååä¸å线ï¼ç©ºæ ¼ä¸å
许ï¼ã<code class="highlighter-rouge">Notification Email List</code> æ¯è¿ç¨æ¥éç¥jobæ§è¡æåæ失败æ
åµçé®ç®±å表ã<code class="highlighter-rouge">Notification Events</code> æ¯è§¦åäºä»¶çç¶æã</p>
-<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/7 cube-info.png" alt="" /></p>
-<p><strong>æ¥éª¤2. 维度</strong></p>
+
-<ol>
- <li>
- <p>ç¹å» <code class="highlighter-rouge">Add Dimension</code>ï¼å¨å¼¹çªä¸æ¾ç¤ºçäºå®è¡¨å lookup 表éå¾éè¾å
¥éè¦çåãLookup 表çåæ2个é项ï¼âNormalâ å âDerivedâï¼é»è®¤ï¼ãâNormalâ æ·»å ä¸ä¸ªæ®éç¬ç«ç维度åï¼âDerivedâ æ·»å ä¸ä¸ª derived 维度ï¼derived 维度ä¸ä¼è®¡ç®å
¥ cubeï¼å°ç±äºå®è¡¨çå¤é®æ¨ç®åºãé
读æ´å¤ãå¦ä½ä¼å cubeãï¼/docs15/howto/howto_optimize_cubes.htmlï¼ã</p>
+
+
+
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/7 cube-dimension-batch.png" alt="" /></p>
- </li>
- <li>
- <p>éæ©ææ维度åç¹å» âNextâã</p>
- </li>
-</ol>
-<p><strong>æ¥éª¤3. 度é</strong></p>
-<ol>
- <li>
- <p>ç¹å» <code class="highlighter-rouge">+Measure</code> æé®æ·»å ä¸ä¸ªæ°ç度éã</p>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink ">Use RESTful API</a>
+ </li>
+
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 meas-+meas.png" alt="" /></p>
- </li>
- <li>
- <p>æ ¹æ®å®ç表达å¼å
±æ8ç§ä¸åç±»åç度éï¼<code class="highlighter-rouge">SUM</code>ã<code class="highlighter-rouge">MAX</code>ã<code class="highlighter-rouge">MIN</code>ã<code class="highlighter-rouge">COUNT</code>ã<code class="highlighter-rouge">COUNT_DISTINCT</code> <code class="highlighter-rouge">TOP_N</code>, <code class="highlighter-rouge">EXTENDED_COLUMN</code> å <code class="highlighter-rouge">PERCENTILE</code>ã请åçéæ© <code class="highlighter-rouge">COUNT_DISTINCT</code> å <code class="highlighter-rouge">TOP_N</code> è¿åç±»åï¼å®ä¸ cube ç大å°ç¸å
³ã</p>
- <ul>
- <li>
- <p>SUM</p>
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-sum.png" alt="" /></p>
- </li>
- <li>
- <p>MIN</p>
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-min.png" alt="" /></p>
- </li>
- <li>
- <p>MAX</p>
+
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-max.png" alt="" /></p>
- </li>
- <li>
- <p>COUNT</p>
+
+
+
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-count.png" alt="" /></p>
- </li>
- <li>
- <p>DISTINCT_COUNT<br />
-è¿ä¸ªåº¦éæ两个å®ç°ï¼<br />
-1ï¼è¿ä¼¼å®ç° HyperLogLogï¼éæ©å¯æ¥åçé误çï¼ä½é误çéè¦æ´å¤åå¨ï¼<br />
-2ï¼ç²¾ç¡®å®ç° bitmapï¼å
·ä½éå¶è¯·ç https://issues.apache.org/jira/browse/KYLIN-1186ï¼</p>
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-distinct.png" alt="" /></p>
- </li>
- </ul>
- <p>注æï¼distinct æ¯ä¸ç§é常éçæ°æ®ç±»åï¼åå
¶ä»åº¦éç¸æ¯æ建åæ¥è¯¢ä¼æ´æ
¢ã</p>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink ">ç¨ API æ建 Cube</a>
+ </li>
+
- <ul>
- <li>TOP_N<br />
-TopN 度éå¨æ¯ä¸ªç»´åº¦ç»åæ¶é¢è®¡ç®ï¼å®æ¯æªé¢è®¡ç®çå¨æ¥è¯¢æ¶é´ä¸æ§è½æ´å¥½ï¼éè¦ä¸¤ä¸ªåæ°ï¼ä¸æ¯è¢«ç¨æ¥ä½ä¸º Top è®°å½ç度éåï¼Kylin å°è®¡ç®å®ç SUM å¼å¹¶åååºæåï¼äºæ¯ literal IDï¼ä»£è¡¨æ Top çè®°å½ï¼ä¾å¦ seller_idï¼</li>
- </ul>
- <p>åççéæ©è¿åç±»åï¼å°å³å®å¤å° top è®°å½è¢«çå¯ï¼top 10, top 100, top 500, top 1000, top 5000 or top 10000ã</p>
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-topn.png" alt="" /></p>
+
- <ul>
- <li>
- <p>EXTENDED_COLUMN<br />
-Extended_Column ä½ä¸ºåº¦éæ¯ä½ä¸ºç»´åº¦æ´èç空é´ãä¸ååé¶ä¸åå¯ä»¥çææ°çåã</p>
+
+
+
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-extended_column.png" alt="" /></p>
- </li>
- <li>
- <p>PERCENTILE<br />
-Percentile 代表äºç¾åæ¯ãå¼è¶å¤§ï¼é误就è¶å°ã100为æåéçå¼ã</p>
- <p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/8 measure-percentile.png" alt="" /></p>
- </li>
- </ul>
- </li>
-</ol>
-<p><strong>æ¥éª¤4. æ´æ°è®¾ç½®</strong></p>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink ">ä¼å Cube 设计</a>
+ </li>
+
-<p>è¿ä¸æ¥éª¤æ¯ä¸ºå¢éæ建 cube è设计çã</p>
-<p><code class="highlighter-rouge">Auto Merge Thresholds</code>: èªå¨å并å°ç segments å°ä¸ççè³æ´å¤§ç segmentãå¦æä¸æ³èªå¨å并ï¼å é¤é»è®¤2个é项ã</p>
-<p><code class="highlighter-rouge">Volatile Range</code>: é»è®¤ä¸º0ï¼ä¼èªå¨å并ææå¯è½ç cube segmentsï¼æè
ç¨ âAuto Mergeâ å°ä¸ä¼å并ææ°ç [Volatile Range] 天ç cube segmentsã</p>
+
-<p><code class="highlighter-rouge">Retention Threshold</code>: åªä¼ä¿å cube è¿å»å 天ç segmentï¼æ§ç segment å°ä¼èªå¨ä»å¤´é¨å é¤ï¼0表示ä¸å¯ç¨è¿ä¸ªåè½ã</p>
+
+
+
-<p><code class="highlighter-rouge">Partition Start Date</code>: cube çå¼å§æ¥æ.</p>
-<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/9 refresh-setting1.png" alt="" /></p>
-<p><strong>æ¥éª¤5. é«çº§è®¾ç½®</strong></p>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink ">ä¼å Cube æ建</a>
+ </li>
+
-<p><code class="highlighter-rouge">Aggregation Groups</code>: Cube ä¸ç维度å¯ä»¥ååå°å¤ä¸ªèåç»ä¸ãé»è®¤ kylin ä¼æææ维度æ¾å¨ä¸ä¸ªèåç»ï¼å½ç»´åº¦è¾å¤æ¶ï¼äº§ççç»åæ°å¯è½æ¯å·¨å¤§çï¼ä¼é æ Cube çç¸ï¼å¦æä½ å¾å¥½çäºè§£ä½ çæ¥è¯¢æ¨¡å¼ï¼é£ä¹ä½ å¯ä»¥å建å¤ä¸ªèåç»ãå¨æ¯ä¸ªèåç»å
ï¼ä½¿ç¨ âMandatory Dimensionsâ, âHierarchy Dimensionsâ å âJoint Dimensionsâ æ¥è¿ä¸æ¥ä¼å维度ç»åã</p>
-<p><code class="highlighter-rouge">Mandatory Dimensions</code>: å¿
è¦ç»´åº¦ï¼ç¨äºæ»æ¯åºç°ç维度ãä¾å¦ï¼å¦æä½ çæ¥è¯¢ä¸æ»æ¯ä¼å¸¦æ âORDER_DATEâ å为 group by æ è¿æ»¤æ¡ä»¶, é£ä¹å®å¯ä»¥è¢«å£°æ为å¿
è¦ç»´åº¦ãè¿æ ·ä¸æ¥ï¼ææä¸å«æ¤ç»´åº¦ç cuboid å°±å¯ä»¥è¢«è·³è¿è®¡ç®ã</p>
-<p><code class="highlighter-rouge">Hierarchy Dimensions</code>: å±çº§ç»´åº¦ï¼ä¾å¦ âå½å®¶â -> âçâ -> âå¸â æ¯ä¸ä¸ªå±çº§ï¼ä¸ç¬¦åæ¤å±çº§å
³ç³»ç cuboid å¯ä»¥è¢«è·³è¿è®¡ç®ï¼ä¾å¦ [âçâ], [âå¸â]. å®ä¹å±çº§ç»´åº¦æ¶ï¼å°ç¶çº§å«ç»´åº¦æ¾å¨å维度ç左边ã</p>
+
-<p><code class="highlighter-rouge">Joint Dimensions</code>:èå维度ï¼æäºç»´åº¦å¾å¾ä¸èµ·åºç°ï¼æè
å®ä»¬çåºæ°é常æ¥è¿ï¼æ1:1æ å°å
³ç³»ï¼ãä¾å¦ âuser_idâ å âemailâãæå¤ä¸ªç»´åº¦å®ä¹ä¸ºç»åå
³ç³»åï¼ææä¸ç¬¦åæ¤å
³ç³»ç cuboids ä¼è¢«è·³è¿è®¡ç®ã</p>
+
+
+
-<p>å
³äºæ´å¤ç»´åº¦ä¼åï¼è¯·é
读è¿ä¸ªå客: <a href="/blog/2016/02/18/new-aggregation-group/">æ°çèåç»</a></p>
-<p><code class="highlighter-rouge">Rowkeys</code>: æ¯ç±ç»´åº¦ç¼ç å¼ç»æãâDictionaryâ ï¼åå
¸ï¼æ¯é»è®¤çç¼ç æ¹å¼; åå
¸åªè½å¤çä¸ä½åºæ°ï¼å°äºä¸åä¸ï¼ç维度ï¼å¦æ维度åºæ°å¾é«ï¼å¦å¤§äº1åä¸), éæ© âfalseâ ç¶å为维度è¾å
¥åéçé¿åº¦ï¼é常æ¯é£åçæ大é¿åº¦å¼; å¦æè¶
è¿æ大å¼ï¼ä¼è¢«æªæã请注æï¼å¦æ没æåå
¸ç¼ç ï¼cube ç大å°å¯è½ä¼é常大ã</p>
-<p>ä½ å¯ä»¥ææ½ç»´åº¦åå»è°æ´å
¶å¨ rowkey ä¸ä½ç½®; ä½äºrowkeyåé¢çåï¼å°å¯ä»¥ç¨æ¥å¤§å¹
缩å°æ¥è¯¢çèå´ãéå¸¸å»ºè®®å° mandantory 维度æ¾å¨å¼å¤´, ç¶åæ¯å¨è¿æ»¤ ( where æ¡ä»¶)ä¸èµ·å°å¾å¤§ä½ç¨ç维度ï¼å¦æå¤ä¸ªåé½ä¼è¢«ç¨äºè¿æ»¤ï¼å°é«åºæ°ç维度ï¼å¦ user_idï¼æ¾å¨ä½åºæ°ç维度ï¼å¦ ageï¼çåé¢ã</p>
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink ">å¤ä»½å
æ°æ®</a>
+ </li>
+
-<p><code class="highlighter-rouge">Mandatory Cuboids</code>: 维度ç»åç½ååãç¡®ä¿ä½ æ³è¦æ建ç cuboid è½è¢«æ建ã</p>
-<p><code class="highlighter-rouge">Cube Engine</code>: cube æ建å¼æãæ两ç§ï¼MapReduce å Sparkãå¦æä½ ç cube åªæç®å度éï¼SUM, MIN, MAX)ï¼å»ºè®®ä½¿ç¨ Sparkãå¦æ cube ä¸æå¤æç±»å度éï¼COUNT DISTINCT, TOP_Nï¼ï¼å»ºè®®ä½¿ç¨ MapReduceã</p>
-<p><code class="highlighter-rouge">Advanced Dictionaries</code>: âGlobal Dictionaryâ æ¯ç¨äºç²¾ç¡®è®¡ç® COUNT DISTINCT çåå
¸, å®ä¼å°ä¸ä¸ªé integerçå¼è½¬æ integerï¼ä»¥ä¾¿äº bitmap è¿è¡å»éãå¦æä½ è¦è®¡ç® COUNT DISTINCT çåæ¬èº«å·²ç»æ¯ integer ç±»åï¼é£ä¹ä¸éè¦å®ä¹ Global Dictionaryã Global Dictionary ä¼è¢«ææ segment å
±äº«ï¼å æ¤æ¯æå¨è·¨ segments ä¹é´åä¸å·å»éæä½ã请注æï¼Global Dictionary éçæ°æ®çå è½½ï¼å¯è½ä¼ä¸æå大ã</p>
+
-<p>âSegment Dictionaryâ æ¯å¦ä¸ä¸ªç¨äºç²¾ç¡®è®¡ç® COUNT DISTINCT çåå
¸ï¼ä¸ Global Dictionary ä¸åçæ¯ï¼å®æ¯åºäºä¸ä¸ª segment çå¼æ建çï¼å æ¤ä¸æ¯æè·¨ segments çæ±æ»è®¡ç®ãå¦æä½ ç cube ä¸æ¯ååºçæè
è½ä¿è¯ä½ çææ SQL æç
§ partition_column è¿è¡ group by, é£ä¹ä½ åºè¯¥ä½¿ç¨ âSegment Dictionaryâ èä¸æ¯ âGlobal Dictionaryâï¼è¿æ ·å¯ä»¥é¿å
å个åå
¸è¿å¤§çé®é¢ã</p>
+
+
+
-<p>请注æï¼âGlobal Dictionaryâ å âSegment Dictionaryâ é½æ¯ååç¼ç çåå
¸ï¼ä»
ç¨äº COUNT DISTINCT 计ç®(å°é integer ç±»å转æ integer ç¨äº bitmap计ç®)ï¼ä»ä»¬ä¸æ¯æ解ç ï¼å æ¤ä¸è½ä¸ºæ®é维度ç¼ç ã</p>
-<p><code class="highlighter-rouge">Advanced Snapshot Table</code>: 为å
¨å± lookup 表è设计ï¼æä¾ä¸åçåå¨ç±»åã</p>
-<p><code class="highlighter-rouge">Advanced ColumnFamily</code>: å¦ææè¶
è¿ä¸ä¸ªçCOUNT DISTINCT æ TopN 度é, ä½ å¯ä»¥å°å®ä»¬æ¾å¨æ´å¤åç°ä¸ï¼ä»¥ä¼åä¸HBase çI/Oã</p>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink ">æ¸
çåå¨</a>
+ </li>
+
-<p><strong>æ¥éª¤6. éåé
ç½®</strong></p>
-<p>Kylin å
è®¸å¨ Cube 级å«è¦çé¨å kylin.properties ä¸çé
ç½®ï¼ä½ å¯ä»¥å¨è¿éå®ä¹è¦ççå±æ§ãå¦æä½ æ²¡æè¦é
ç½®çï¼ç¹å» <code class="highlighter-rouge">Next</code> æé®ã</p>
-<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/10 configuration.png" alt="" /></p>
-<p><strong>æ¥éª¤7. æ¦è§ & ä¿å</strong></p>
-<p>ä½ å¯ä»¥æ¦è§ä½ ç cube 并è¿åä¹åçæ¥éª¤è¿è¡ä¿®æ¹ãç¹å» <code class="highlighter-rouge">Save</code> æé®å®æ cube å建ã</p>
-<p><img src="/images/tutorial/1.5/Kylin-Cube-Creation-Tutorial/11 overview.png" alt="" /></p>
-<p>æåï¼cube å建好äºï¼ä½ å¯ä»¥å»æ建åç©å®äºã</p>
+ <ul>
+ </div>
+</div>
+
- </article>
- </div>
- </div>
- </div>
+ </ul>
+</div>
</div>
</div>
<!--