Author: lidong Date: Thu Feb 22 14:02:15 2018 New Revision: 1825064 URL: http://svn.apache.org/viewvc?rev=1825064&view=rev Log: Update document
Modified: kylin/site/cn/docs21/tutorial/kylin_client_tool.html kylin/site/cn/docs23/tutorial/kylin_client_tool.html kylin/site/development/dev_env.html kylin/site/docs21/tutorial/hue.html kylin/site/docs21/tutorial/kylin_client_tool.html kylin/site/docs23/tutorial/hue.html kylin/site/docs23/tutorial/kylin_client_tool.html kylin/site/feed.xml Modified: kylin/site/cn/docs21/tutorial/kylin_client_tool.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs21/tutorial/kylin_client_tool.html?rev=1825064&r1=1825063&r2=1825064&view=diff ============================================================================== --- kylin/site/cn/docs21/tutorial/kylin_client_tool.html (original) +++ kylin/site/cn/docs21/tutorial/kylin_client_tool.html Thu Feb 22 14:02:15 2018 @@ -1834,15 +1834,14 @@ Usage: kylinpy [OPTIONS] COMMAND [ARGS]... Options: - -h, --host TEXT kylin/kap host name [required] - -P, --port INTEGER kylin/kap port, default: 7070 - -u, --username TEXT kylin/kap username [required] - -p, --password TEXT kylin/kap password [required] - --project TEXT kylin/kap project [required] - --prefix TEXT kylin/kap RESTful prefix of url, default: /kylin/api + -h, --host TEXT Kylin host name [required] + -P, --port INTEGER Kylin port, default: 7070 + -u, --username TEXT Kylin username [required] + -p, --password TEXT Kylin password [required] + --project TEXT Kylin project [required] + --prefix TEXT Kylin RESTful prefix of url, default: /kylin/api --debug / --no-debug show debug infomation - --api2 / --api1 API version; default is api1; --api1 used by Apache KYLIN; - --api2 used by KAP + --api1 / --api2 API version; default is "api1"; "api1" éç¨äº Apache Kylin --help Show this message and exit. Commands: @@ -1850,13 +1849,11 @@ cube_columns list cube columns cube_desc show cube description cube_names list cube names - cube_sql get sample sql of cube. KAP only model_desc show model description projects list all projects query sql query table_columns list table columns table_names list all table names - users list all users. Need admin role. KAP only </code></pre> </div> @@ -1866,55 +1863,55 @@ <li> <p>访é®Apache Kylin<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug auth +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug auth </code></p> </li> <li> <p>访é®éå®cubeææç维度信æ¯<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_columns --name kylin_sales_cube +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_columns --name kylin_sales_cube </code></p> </li> <li> <p>访é®éå®çcubeæè¿°<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_desc --name kylin_sales_cube +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_desc --name kylin_sales_cube </code></p> </li> <li> <p>访é®ææcubeå称<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_names +kylinpy -h hostname -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_names </code></p> </li> <li> <p>访é®éå®cubeçSQLå®ä¹<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_sql --name kylin_sales_cube +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_sql --name kylin_sales_cube </code></p> </li> <li> <p>ååºKylinä¸ææ项ç®<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug projects +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug projects </code></p> </li> <li> <p>访é®éå®è¡¨ææç维度信æ¯<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug table_columns --name KYLIN_SALES +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug table_columns --name KYLIN_SALES </code></p> </li> <li> <p>访é®ææ表å<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -u ADMIN -p KYLIN --project learn_kylin --api1 table_names +kylinpy -h hostname -u ADMIN -p KYLIN --project learn_kylin --api1 table_names </code></p> </li> <li> <p>访é®æé模åä¿¡æ¯<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug model_desc --name kylin_sales_model +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug model_desc --name kylin_sales_model </code></p> </li> </ol> Modified: kylin/site/cn/docs23/tutorial/kylin_client_tool.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs23/tutorial/kylin_client_tool.html?rev=1825064&r1=1825063&r2=1825064&view=diff ============================================================================== --- kylin/site/cn/docs23/tutorial/kylin_client_tool.html (original) +++ kylin/site/cn/docs23/tutorial/kylin_client_tool.html Thu Feb 22 14:02:15 2018 @@ -1814,15 +1814,17 @@ <div id="pjax"> <h1 class="post-title">Kylin Python 客æ·ç«¯å·¥å ·åº</h1> <article class="post-content" > - <p>Apache Kylin Python 客æ·ç«¯å·¥å ·åºæ¯åºäºPythonå¯è®¿é®Kylinç客æ·ç«¯. æ¤å·¥å ·åºå å«ä¸¤ä¸ªå¯ä½¿ç¨å件. æ³è¦äºè§£æ´å¤å ³äºæ¤å·¥å ·åºä¿¡æ¯è¯·ç¹å»<a href="https://github.com/Kyligence/kylinpy">Githubä»åº</a>.</p> + <p>Apache Kylin Python 客æ·ç«¯å·¥å ·åºæ¯åºäºPythonå¯è®¿é®Kylinç客æ·ç«¯. æ¤å·¥å ·åºå å«ä¸¤ä¸ªå¯ä½¿ç¨ç»ä»¶.</p> <ul> <li>Apache Kylin å½ä»¤è¡å·¥å ·</li> <li>Apache Kylin SQLAchemyæ¹è¨</li> </ul> +<p>æ³è¦äºè§£æ´å¤å ³äºæ¤å·¥å ·åºä¿¡æ¯è¯·ç¹å»<a href="https://github.com/Kyligence/kylinpy">Githubä»åº</a>.</p> + <h2 id="section">å®è£ </h2> -<p>请确ä¿æ¨python解éå¨çæ¬å¨2.7+, æè 3.4+以ä¸. ææ¹ä¾¿å®è£ Apache Kylin python客æ·ç«¯å·¥å ·åºçæ¹æ³æ¯ä½¿ç¨pipå½ä»¤<br /> +<p>请确ä¿æ¨python解éå¨çæ¬å¨2.7+, æè 3.4+以ä¸. ææ¹ä¾¿å®è£ Apache Kylin Python客æ·ç«¯å·¥å ·åºçæ¹æ³æ¯ä½¿ç¨pipå½ä»¤<br /> <code class="highlighter-rouge"> pip install --upgrade kylinpy </code></p> @@ -1834,15 +1836,14 @@ Usage: kylinpy [OPTIONS] COMMAND [ARGS]... Options: - -h, --host TEXT kylin/kap host name [required] - -P, --port INTEGER kylin/kap port, default: 7070 - -u, --username TEXT kylin/kap username [required] - -p, --password TEXT kylin/kap password [required] - --project TEXT kylin/kap project [required] - --prefix TEXT kylin/kap RESTful prefix of url, default: /kylin/api + -h, --host TEXT Kylin host name [required] + -P, --port INTEGER Kylin port, default: 7070 + -u, --username TEXT Kylin username [required] + -p, --password TEXT Kylin password [required] + --project TEXT Kylin project [required] + --prefix TEXT Kylin RESTful prefix of url, default: /kylin/api --debug / --no-debug show debug infomation - --api2 / --api1 API version; default is api1; --api1 used by Apache KYLIN; - --api2 used by KAP + --api1 / --api2 API version; default is "api1"; "api1" éç¨äº Apache Kylin --help Show this message and exit. Commands: @@ -1850,13 +1851,11 @@ cube_columns list cube columns cube_desc show cube description cube_names list cube names - cube_sql get sample sql of cube. KAP only model_desc show model description projects list all projects query sql query table_columns list table columns table_names list all table names - users list all users. Need admin role. KAP only </code></pre> </div> @@ -1866,55 +1865,55 @@ <li> <p>访é®Apache Kylin<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug auth +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug auth </code></p> </li> <li> <p>访é®éå®cubeææç维度信æ¯<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_columns --name kylin_sales_cube +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_columns --name kylin_sales_cube </code></p> </li> <li> <p>访é®éå®çcubeæè¿°<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_desc --name kylin_sales_cube +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_desc --name kylin_sales_cube </code></p> </li> <li> <p>访é®ææcubeå称<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_names +kylinpy -h hostname -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_names </code></p> </li> <li> <p>访é®éå®cubeçSQLå®ä¹<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_sql --name kylin_sales_cube +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_sql --name kylin_sales_cube </code></p> </li> <li> <p>ååºKylinä¸ææ项ç®<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug projects +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug projects </code></p> </li> <li> <p>访é®éå®è¡¨ææç维度信æ¯<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug table_columns --name KYLIN_SALES +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug table_columns --name KYLIN_SALES </code></p> </li> <li> <p>访é®ææ表å<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -u ADMIN -p KYLIN --project learn_kylin --api1 table_names +kylinpy -h hostname -u ADMIN -p KYLIN --project learn_kylin --api1 table_names </code></p> </li> <li> <p>访é®æé模åä¿¡æ¯<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug model_desc --name kylin_sales_model +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug model_desc --name kylin_sales_model </code></p> </li> </ol> Modified: kylin/site/development/dev_env.html URL: http://svn.apache.org/viewvc/kylin/site/development/dev_env.html?rev=1825064&r1=1825063&r2=1825064&view=diff ============================================================================== --- kylin/site/development/dev_env.html (original) +++ kylin/site/development/dev_env.html Thu Feb 22 14:02:15 2018 @@ -563,13 +563,13 @@ <div id="pjax"> <h1 class="post-title">Setup Development Env</h1> <article class="post-content" > - <p>Developers want to run kylin test cases or applications at their development machine.</p> + <p>Developers want to run Kylin test cases or applications at their development machine.</p> -<p>By following this tutorial, you will be able to build kylin test cubes by running a specific test case, and you can further run other test cases against the cubes having been built.</p> +<p>By following this tutorial, you will be able to build Kylin test cubes by running a specific test case, and you can further run other test cases against the cubes having been built.</p> <h2 id="environment-on-the-hadoop-cli">Environment on the Hadoop CLI</h2> -<p>Off-Hadoop-CLI installation requires you having a hadoop CLI machine (or a hadoop sandbox) as well as your local develop machine. To make things easier we strongly recommend you starting with running Kylin on a hadoop sandbox, like <a href="http://hortonworks.com/products/hortonworks-sandbox/">http://hortonworks.com/products/hortonworks-sandbox/</a>. In the following tutorial weâll go with <strong>Hortonworks Sandbox 2.4.0.0-169</strong>. It is recommended that you provide enough memory to your sandbox, 8G or more is preferred.</p> +<p>Off-Hadoop-CLI installation requires you having a hadoop CLI machine (or a hadoop sandbox) as well as your local develop machine. To make things easier we strongly recommend you starting with running Kylin on a hadoop sandbox. In the following tutorial weâll go with <strong>Hortonworks® Sandbox 2.4.0.0-169</strong>, you can download it from <a href="https://hortonworks.com/downloads/#sandbox">Hortonworks download page</a>, expand the âHortonworks Sandbox Archiveâ link, and then search âHDP® 2.4 on Hortonworks Sandboxâ to download. It is recommended that you provide enough memory to your sandbox vm, 8G or more is preferred.</p> <h3 id="start-hadoop">Start Hadoop</h3> @@ -578,7 +578,7 @@ <div class="highlight"><pre><code class="language-groff" data-lang="groff">ambari-agent start ambari-server start</code></pre></div> -<p>With both command successfully run you can go to ambari home page at <a href="http://yoursandboxip:8080">http://yoursandboxip:8080</a> (user:admin,password:admin) to check everythingâs status. By default ambari disables HBase, youâll need manually start the <code class="highlighter-rouge">HBase</code> service.<br /> +<p>With both command successfully run you can go to ambari home page at <a href="http://yoursandboxip:8080">http://yoursandboxip:8080</a> to check everythingâs status. By default ambari disables HBase, you need to manually start the <code class="highlighter-rouge">HBase</code> service.<br /> <img src="https://raw.githubusercontent.com/KylinOLAP/kylinolap.github.io/master/docs/installation/starthbase.png" alt="start hbase in ambari" /></p> <p>For other hadoop distribution, basically start the hadoop cluster, make sure HDFS, YARN, Hive, HBase are running.</p> Modified: kylin/site/docs21/tutorial/hue.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/hue.html?rev=1825064&r1=1825063&r2=1825064&view=diff ============================================================================== --- kylin/site/docs21/tutorial/hue.html (original) +++ kylin/site/docs21/tutorial/hue.html Thu Feb 22 14:02:15 2018 @@ -4039,12 +4039,12 @@ <article class="post-content" > <h3 id="introduction">Introduction</h3> -<p>In <a href="https://issues.cloudera.org/browse/HUE-2745">Hue-2745</a> v3.10, add jdbc support like Phoenix, Kylin, Redshift, Solr Parallel SQL, â¦</p> +<p>In <a href="https://issues.cloudera.org/browse/HUE-2745">Hue-2745</a> v3.10, add JDBC support like Phoenix, Kylin, Redshift, Solr Parallel SQL, â¦</p> -<p>However, there isnât any manual to use with Kylin :(</p> +<p>However, there isnât any manual to use with Kylin.</p> <h3 id="pre-requisites">Pre-requisites</h3> -<p>Build a cube sample of Kylin with: <a href="http://kylin.apache.org/docs15/tutorial/kylin_sample.html">Quick Start with Sample Cube</a>, will be enough</p> +<p>Build a cube sample of Kylin with: <a href="http://kylin.apache.org/docs23/tutorial/kylin_sample.html">Quick Start with Sample Cube</a>, will be enough.</p> <p>You can check:</p> @@ -4057,13 +4057,13 @@ </ul> <h3 id="install-hue">Install Hue</h3> -<p>If you have Hue installed, you can skip this step</p> +<p>If you have Hue installed, you can skip this step.</p> <p>To install Hue on Ubuntu 16.04 LTS. The <a href="http://gethue.com/how-to-build-hue-on-ubuntu-14-04-trusty/">official Instructions</a> didnât work but <a href="https://github.com/cloudera/hue/blob/master/tools/docker/hue-base/Dockerfile">this</a> works fine:</p> -<p>There isnât any binary package thus <a href="https://github.com/cloudera/hue#development-prerequisites">pre-requisites</a> must be installed and compile with the command <em>make</em></p> +<p>There isnât any binary package thus <a href="https://github.com/cloudera/hue#development-prerequisites">pre-requisites</a> must be installed and compile with the command <em>make</em></p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">Sudo apt-get install --fix-missing -q -y \ +<div class="highlight"><pre><code class="language-groff" data-lang="groff">sudo apt-get install --fix-missing -q -y \ git \ ant \ gcc \ @@ -4234,7 +4234,7 @@ Choose <strong>Binary</strong> and the < <p>In Hue 3.10 with Kylin, I donât have any problem :)</p> -<h2 id="test-query-example">Test query Example</h2> +<h2 id="test-query-example">Test query example</h2> <p>Add Kylin JDBC as source in the Kylinâs notebook:</p> <p><img src="/images/tutorial/2.0/hue/15.png" alt="alt text" /> > <img src="/images/tutorial/2.0/hue/16.png" alt="alt text" /> > <img src="/images/tutorial/2.0/hue/17.png" alt="alt text" /> > <img src="/images/tutorial/2.0/hue/18.png" alt="alt text" /></p> @@ -4253,8 +4253,7 @@ Choose <strong>Binary</strong> and the < <p><img src="/images/tutorial/2.0/hue/21.png" alt="" /></p> -<p>There is a bug,not solved since 27 Aug 2016, nor in 3.10 and 3.11, <br /> -but the solution is very easy (Thanks to Shahab Tajik)</p> +<p>There is a bug, not solved since 27 Aug 2016, nor in 3.10 and 3.11, but the solution is very easy:</p> <p><a href="https://github.com/cloudera/hue/pull/369">Link</a>: <br /> You only need to change 3 lines in *<huepath>/desktop/libs/librdbms/src/librdbms/jdbc.py*</huepath></p> @@ -4262,32 +4261,20 @@ You only need to change 3 lines in *<hu <h2 id="limits">Limits</h2> <p>In Hue 3.10 and 3.11<br /> * Auto-complete doesnât work on JDBC interfaces<br /> -* Max 1.000 records. There is a limitation on JDBC interfaces, because Hue does not support result pagination <a href="https://issues.cloudera.org/browse/HUE-3419">Hue 3419</a><br /> -* Obviously: Itâs read-only</p> +* Max 1000 records. There is a limitation on JDBC interfaces, because Hue does not support result pagination <a href="https://issues.cloudera.org/browse/HUE-3419">Hue 3419</a>.</p> <h3 id="future-work">Future Work</h3> <p><strong>Dashboards</strong><br /> -There is an amazing feature of Hue: <a href="http://gethue.com/search-dashboards/">Search Dasboards</a> / <a href="http://gethue.com/hadoop-search-dynamic-search-dashboards-with-solr/">Dynamic Dashboards</a>. You can âplayâ with this <a href="http://demo.gethue.com/search/admin/collections">Demo On-line</a> ⦠<strong>But this only works with SolR</strong></p> +There is an amazing feature of Hue: <a href="http://gethue.com/search-dashboards/">Search Dasboards</a> / <a href="http://gethue.com/hadoop-search-dynamic-search-dashboards-with-solr/">Dynamic Dashboards</a>. You can âplayâ with this <a href="http://demo.gethue.com/search/admin/collections">Demo On-line</a>. But this only works with SolR.</p> -<p>There is a Jira to solve this: <a href="https://issues.cloudera.org/browse/HUE-3228">Hue 3228</a>, is in RoadMap for 4.1. Check Hue MailList<a href="https://groups.google.com/a/cloudera.org/forum/#!topic/hue-user/B6FWBeoqK7I">MailList</a> and add Dashboards to JDBC connections</p> +<p>There is a JIRA to solve this: <a href="https://issues.cloudera.org/browse/HUE-3228">Hue 3228</a>, is in roadmap for 4.1. Check Hue MailList<a href="https://groups.google.com/a/cloudera.org/forum/#!topic/hue-user/B6FWBeoqK7I">MailList</a> and add Dashboards to JDBC connections.</p> <p><strong>Chart & Dynamic Filter</strong><br /> -Nowadays, It isnât compatible, you only can work with Grid</p> - -<p>I think the problem is that Hue doesnât know how to read Kylin Metadata <a href="https://issues.cloudera.org/browse/HUE-4011">Hue 4011</a></p> - -<p><img src="/images/tutorial/2.0/hue/22.png" alt="" /></p> +Nowadays, it isnât compatible, you only can work with Grid.</p> <p><strong>DB Query</strong><br /> - <img src="/images/tutorial/2.0/hue/23.png" alt="alt text" /> > <img src="/images/tutorial/2.0/hue/24.png" alt="alt text" /> , is not yet supported with JDBC</p> - -<p>Now it only supports <a href="https://docs.djangoproject.com/en/1.9/topics/install/#database-installation">Django Databases</a></p> - -<p><strong>For any suggestions, feel free to contact me</strong></p> - -<p><strong>Thanks, Alberto</strong></p> - + DB Query does not yet support JDBC.</p> </article> </div> Modified: kylin/site/docs21/tutorial/kylin_client_tool.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/kylin_client_tool.html?rev=1825064&r1=1825063&r2=1825064&view=diff ============================================================================== --- kylin/site/docs21/tutorial/kylin_client_tool.html (original) +++ kylin/site/docs21/tutorial/kylin_client_tool.html Thu Feb 22 14:02:15 2018 @@ -4038,15 +4038,17 @@ <article class="post-content" > - <p>Apache Kylin Python Client Library is a python-based Apache Kylin client. There are two components in Apache Kylin Python Client Library. You can get more detail from <a href="https://github.com/Kyligence/kylinpy">Github Repo</a>.</p> + <p>Apache Kylin Python Client Library is a python-based Apache Kylin client. There are two components in Apache Kylin Python Client Library:</p> <ul> <li>Apache Kylin command line tools</li> <li>Apache Kylin dialect for SQLAlchemy</li> </ul> +<p>You can get more detail from this <a href="https://github.com/Kyligence/kylinpy">Github Repository</a>.</p> + <h2 id="installation">Installation</h2> -<p>Make sure python version above 2.7+, 3.4+ installed. The easiest way to install Apache Kylin Python Client Library is to use pip</p> +<p>Make sure python version is 2.7+ or 3.4+. The easiest way to install Apache Kylin Python Client Library is to use âpipâ:</p> <div class="highlighter-rouge"><pre class="highlight"><code> pip install --upgrade kylinpy </code></pre> @@ -4059,15 +4061,14 @@ Usage: kylinpy [OPTIONS] COMMAND [ARGS]... Options: - -h, --host TEXT kylin/kap host name [required] - -P, --port INTEGER kylin/kap port, default: 7070 - -u, --username TEXT kylin/kap username [required] - -p, --password TEXT kylin/kap password [required] - --project TEXT kylin/kap project [required] - --prefix TEXT kylin/kap RESTful prefix of url, default: /kylin/api + -h, --host TEXT Kylin host name [required] + -P, --port INTEGER Kylin port, default: 7070 + -u, --username TEXT Kylin username [required] + -p, --password TEXT Kylin password [required] + --project TEXT Kylin project [required] + --prefix TEXT Kylin RESTful prefix of url, default: "/kylin/api" --debug / --no-debug show debug infomation - --api2 / --api1 API version; default is api1; --api1 used by Apache KYLIN; - --api2 used by KAP + --api2 / --api1 API version; default is "api1"; "api1" is for Apache Kylin; --help Show this message and exit. Commands: @@ -4075,13 +4076,11 @@ cube_columns list cube columns cube_desc show cube description cube_names list cube names - cube_sql get sample sql of cube. KAP only model_desc show model description projects list all projects query sql query table_columns list table columns table_names list all table names - users list all users. Need admin role. KAP only </code></pre> </div> @@ -4091,72 +4090,72 @@ <li> <p>To get all user info from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug auth +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug auth </code></p> </li> <li> <p>To get all cube columns from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_columns --name kylin_sales_cube +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_columns --name kylin_sales_cube </code></p> </li> <li> <p>To get cube description of selected cube from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_desc --name kylin_sales_cube +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_desc --name kylin_sales_cube </code></p> </li> <li> <p>To get all cube names from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_names +kylinpy -h hostname -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_names </code></p> </li> <li> <p>To get cube SQL of selected cube from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_sql --name kylin_sales_cube +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_sql --name kylin_sales_cube </code></p> </li> <li> <p>To list all projects from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug projects +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug projects </code></p> </li> <li> <p>To list all tables column of selected cube from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug table_columns --name KYLIN_SALES +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug table_columns --name KYLIN_SALES </code></p> </li> <li> <p>To get all table names from kylin<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -u ADMIN -p KYLIN --project learn_kylin --api1 table_names +kylinpy -h hostname -u ADMIN -p KYLIN --project learn_kylin --api1 table_names </code></p> </li> <li> <p>To get the model description of the selected model from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug model_desc --name kylin_sales_model +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug model_desc --name kylin_sales_model </code></p> </li> </ol> <h2 id="kylin-dialect-for-sqlalchemy">Kylin dialect for SQLAlchemy</h2> -<p>Any application that uses SQLAlchemy can now query Apache Kylin with this Apache Kylin dialect installed. It is part of the Apache Kylin Python Client Library, so if you already installed this library in the previous step, you are ready to use. You may use below template to build DSN to connect Apache Kylin</p> +<p>Any application that uses SQLAlchemy can now query Apache Kylin with this Apache Kylin dialect installed. It is part of the Apache Kylin Python Client Library, so if you already installed this library in the previous step, you are ready to use. You may use below template to build DSN to connect Apache Kylin.</p> -<div class="highlighter-rouge"><pre class="highlight"><code>kylin://<username>:<password>@<hostname>:<port>/<project>?version=<v1|v2>&prefix=</kylin/api> +<div class="highlighter-rouge"><pre class="highlight"><code>kylin://<username>:<password>@<hostname>:<port>/<project>?version=v1>&prefix=</kylin/api> </code></pre> </div> <h2 id="examples-for-sqlalchemy">Examples for SQLAlchemy</h2> -<p>Test connection with Apache Kylin<br /> -<code class="highlighter-rouge"> - $ python +<p>Test connection with Apache Kylin</p> + +<div class="highlight"><pre><code class="language-groff" data-lang="groff">$ python >>> import sqlalchemy as sa >>> kylin_engine = sa.create_engine('kylin://username:password@hostname:7070/learn_kylin?version=v1') >>> results = kylin_engine.execute('SELECT count(*) FROM KYLIN_SALES') @@ -4168,8 +4167,8 @@ kylinpy -h kap.kapdemo.com -P 7070 -u AD u'KYLIN_CATEGORY_GROUPINGS', u'KYLIN_COUNTRY', u'KYLIN_SALES', - u'KYLIN_STREAMING_TABLE'] -</code></p> + u'KYLIN_STREAMING_TABLE']</code></pre></div> + </article> </div> Modified: kylin/site/docs23/tutorial/hue.html URL: http://svn.apache.org/viewvc/kylin/site/docs23/tutorial/hue.html?rev=1825064&r1=1825063&r2=1825064&view=diff ============================================================================== --- kylin/site/docs23/tutorial/hue.html (original) +++ kylin/site/docs23/tutorial/hue.html Thu Feb 22 14:02:15 2018 @@ -4219,12 +4219,12 @@ <article class="post-content" > <h3 id="introduction">Introduction</h3> -<p>In <a href="https://issues.cloudera.org/browse/HUE-2745">Hue-2745</a> v3.10, add jdbc support like Phoenix, Kylin, Redshift, Solr Parallel SQL, â¦</p> +<p>In <a href="https://issues.cloudera.org/browse/HUE-2745">Hue-2745</a> v3.10, add JDBC support like Phoenix, Kylin, Redshift, Solr Parallel SQL, â¦</p> -<p>However, there isnât any manual to use with Kylin :(</p> +<p>However, there isnât any manual to use with Kylin.</p> <h3 id="pre-requisites">Pre-requisites</h3> -<p>Build a cube sample of Kylin with: <a href="http://kylin.apache.org/docs15/tutorial/kylin_sample.html">Quick Start with Sample Cube</a>, will be enough</p> +<p>Build a cube sample of Kylin with: <a href="http://kylin.apache.org/docs23/tutorial/kylin_sample.html">Quick Start with Sample Cube</a>, will be enough.</p> <p>You can check:</p> @@ -4237,13 +4237,13 @@ </ul> <h3 id="install-hue">Install Hue</h3> -<p>If you have Hue installed, you can skip this step</p> +<p>If you have Hue installed, you can skip this step.</p> <p>To install Hue on Ubuntu 16.04 LTS. The <a href="http://gethue.com/how-to-build-hue-on-ubuntu-14-04-trusty/">official Instructions</a> didnât work but <a href="https://github.com/cloudera/hue/blob/master/tools/docker/hue-base/Dockerfile">this</a> works fine:</p> -<p>There isnât any binary package thus <a href="https://github.com/cloudera/hue#development-prerequisites">pre-requisites</a> must be installed and compile with the command <em>make</em></p> +<p>There isnât any binary package thus <a href="https://github.com/cloudera/hue#development-prerequisites">pre-requisites</a> must be installed and compile with the command <em>make</em></p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">Sudo apt-get install --fix-missing -q -y \ +<div class="highlight"><pre><code class="language-groff" data-lang="groff">sudo apt-get install --fix-missing -q -y \ git \ ant \ gcc \ @@ -4414,7 +4414,7 @@ Choose <strong>Binary</strong> and the < <p>In Hue 3.10 with Kylin, I donât have any problem :)</p> -<h2 id="test-query-example">Test query Example</h2> +<h2 id="test-query-example">Test query example</h2> <p>Add Kylin JDBC as source in the Kylinâs notebook:</p> <p><img src="/images/tutorial/2.0/hue/15.png" alt="alt text" /> > <img src="/images/tutorial/2.0/hue/16.png" alt="alt text" /> > <img src="/images/tutorial/2.0/hue/17.png" alt="alt text" /> > <img src="/images/tutorial/2.0/hue/18.png" alt="alt text" /></p> @@ -4433,8 +4433,7 @@ Choose <strong>Binary</strong> and the < <p><img src="/images/tutorial/2.0/hue/21.png" alt="" /></p> -<p>There is a bug,not solved since 27 Aug 2016, nor in 3.10 and 3.11, <br /> -but the solution is very easy (Thanks to Shahab Tajik)</p> +<p>There is a bug, not solved since 27 Aug 2016, nor in 3.10 and 3.11, but the solution is very easy:</p> <p><a href="https://github.com/cloudera/hue/pull/369">Link</a>: <br /> You only need to change 3 lines in *<huepath>/desktop/libs/librdbms/src/librdbms/jdbc.py*</huepath></p> @@ -4442,32 +4441,20 @@ You only need to change 3 lines in *<hu <h2 id="limits">Limits</h2> <p>In Hue 3.10 and 3.11<br /> * Auto-complete doesnât work on JDBC interfaces<br /> -* Max 1.000 records. There is a limitation on JDBC interfaces, because Hue does not support result pagination <a href="https://issues.cloudera.org/browse/HUE-3419">Hue 3419</a><br /> -* Obviously: Itâs read-only</p> +* Max 1000 records. There is a limitation on JDBC interfaces, because Hue does not support result pagination <a href="https://issues.cloudera.org/browse/HUE-3419">Hue 3419</a>.</p> <h3 id="future-work">Future Work</h3> <p><strong>Dashboards</strong><br /> -There is an amazing feature of Hue: <a href="http://gethue.com/search-dashboards/">Search Dasboards</a> / <a href="http://gethue.com/hadoop-search-dynamic-search-dashboards-with-solr/">Dynamic Dashboards</a>. You can âplayâ with this <a href="http://demo.gethue.com/search/admin/collections">Demo On-line</a> ⦠<strong>But this only works with SolR</strong></p> +There is an amazing feature of Hue: <a href="http://gethue.com/search-dashboards/">Search Dasboards</a> / <a href="http://gethue.com/hadoop-search-dynamic-search-dashboards-with-solr/">Dynamic Dashboards</a>. You can âplayâ with this <a href="http://demo.gethue.com/search/admin/collections">Demo On-line</a>. But this only works with SolR.</p> -<p>There is a Jira to solve this: <a href="https://issues.cloudera.org/browse/HUE-3228">Hue 3228</a>, is in RoadMap for 4.1. Check Hue MailList<a href="https://groups.google.com/a/cloudera.org/forum/#!topic/hue-user/B6FWBeoqK7I">MailList</a> and add Dashboards to JDBC connections</p> +<p>There is a JIRA to solve this: <a href="https://issues.cloudera.org/browse/HUE-3228">Hue 3228</a>, is in roadmap for 4.1. Check Hue MailList<a href="https://groups.google.com/a/cloudera.org/forum/#!topic/hue-user/B6FWBeoqK7I">MailList</a> and add Dashboards to JDBC connections.</p> <p><strong>Chart & Dynamic Filter</strong><br /> -Nowadays, It isnât compatible, you only can work with Grid</p> - -<p>I think the problem is that Hue doesnât know how to read Kylin Metadata <a href="https://issues.cloudera.org/browse/HUE-4011">Hue 4011</a></p> - -<p><img src="/images/tutorial/2.0/hue/22.png" alt="" /></p> +Nowadays, it isnât compatible, you only can work with Grid.</p> <p><strong>DB Query</strong><br /> - <img src="/images/tutorial/2.0/hue/23.png" alt="alt text" /> > <img src="/images/tutorial/2.0/hue/24.png" alt="alt text" /> , is not yet supported with JDBC</p> - -<p>Now it only supports <a href="https://docs.djangoproject.com/en/1.9/topics/install/#database-installation">Django Databases</a></p> - -<p><strong>For any suggestions, feel free to contact me</strong></p> - -<p><strong>Thanks, Alberto</strong></p> - + DB Query does not yet support JDBC.</p> </article> </div> Modified: kylin/site/docs23/tutorial/kylin_client_tool.html URL: http://svn.apache.org/viewvc/kylin/site/docs23/tutorial/kylin_client_tool.html?rev=1825064&r1=1825063&r2=1825064&view=diff ============================================================================== --- kylin/site/docs23/tutorial/kylin_client_tool.html (original) +++ kylin/site/docs23/tutorial/kylin_client_tool.html Thu Feb 22 14:02:15 2018 @@ -4218,36 +4218,37 @@ <article class="post-content" > - <p>Apache Kylin Python Client Library is a python-based Apache Kylin client. There are two components in Apache Kylin Python Client Library. You can get more detail from <a href="https://github.com/Kyligence/kylinpy">Github Repo</a>.</p> + <p>Apache Kylin Python Client Library is a python-based Apache Kylin client. There are two components in Apache Kylin Python Client Library:</p> <ul> <li>Apache Kylin command line tools</li> <li>Apache Kylin dialect for SQLAlchemy</li> </ul> +<p>You can get more detail from this <a href="https://github.com/Kyligence/kylinpy">Github Repository</a>.</p> + <h2 id="installation">Installation</h2> -<p>Make sure python version above 2.7+, 3.4+ installed. The easiest way to install Apache Kylin Python Client Library is to use pip</p> +<p>Make sure python version is 2.7+ or 3.4+. The easiest way to install Apache Kylin Python Client Library is to use âpipâ:</p> <div class="highlighter-rouge"><pre class="highlight"><code> pip install --upgrade kylinpy </code></pre> </div> <h2 id="kylinpy-cli">Kylinpy CLI</h2> -<p>After installing Apache Kylin Python Client Library you may run kylinpy in terminal</p> +<p>After installing Apache Kylin Python Client Library you may run kylinpy in terminal.</p> <div class="highlighter-rouge"><pre class="highlight"><code> $ kylinpy Usage: kylinpy [OPTIONS] COMMAND [ARGS]... Options: - -h, --host TEXT kylin/kap host name [required] - -P, --port INTEGER kylin/kap port, default: 7070 - -u, --username TEXT kylin/kap username [required] - -p, --password TEXT kylin/kap password [required] - --project TEXT kylin/kap project [required] - --prefix TEXT kylin/kap RESTful prefix of url, default: /kylin/api + -h, --host TEXT Kylin host name [required] + -P, --port INTEGER Kylin port, default: 7070 + -u, --username TEXT Kylin username [required] + -p, --password TEXT Kylin password [required] + --project TEXT Kylin project [required] + --prefix TEXT Kylin RESTful prefix of url, default: "/kylin/api" --debug / --no-debug show debug infomation - --api2 / --api1 API version; default is api1; --api1 used by Apache KYLIN; - --api2 used by KAP + --api2 / --api1 API version; default is "api1"; "api1" is for Apache Kylin; --help Show this message and exit. Commands: @@ -4255,13 +4256,11 @@ cube_columns list cube columns cube_desc show cube description cube_names list cube names - cube_sql get sample sql of cube. KAP only model_desc show model description projects list all projects query sql query table_columns list table columns table_names list all table names - users list all users. Need admin role. KAP only </code></pre> </div> @@ -4271,62 +4270,62 @@ <li> <p>To get all user info from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug auth +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug auth </code></p> </li> <li> <p>To get all cube columns from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_columns --name kylin_sales_cube +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_columns --name kylin_sales_cube </code></p> </li> <li> <p>To get cube description of selected cube from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_desc --name kylin_sales_cube +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_desc --name kylin_sales_cube </code></p> </li> <li> <p>To get all cube names from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_names +kylinpy -h hostname -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_names </code></p> </li> <li> <p>To get cube SQL of selected cube from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_sql --name kylin_sales_cube +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug cube_sql --name kylin_sales_cube </code></p> </li> <li> <p>To list all projects from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug projects +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug projects </code></p> </li> <li> <p>To list all tables column of selected cube from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug table_columns --name KYLIN_SALES +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug table_columns --name KYLIN_SALES </code></p> </li> <li> <p>To get all table names from kylin<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -u ADMIN -p KYLIN --project learn_kylin --api1 table_names +kylinpy -h hostname -u ADMIN -p KYLIN --project learn_kylin --api1 table_names </code></p> </li> <li> <p>To get the model description of the selected model from Apache Kylin with debug mode<br /> <code class="highlighter-rouge"> -kylinpy -h kap.kapdemo.com -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug model_desc --name kylin_sales_model +kylinpy -h hostname -P 7070 -u ADMIN -p KYLIN --project learn_kylin --api1 --debug model_desc --name kylin_sales_model </code></p> </li> </ol> <h2 id="kylin-dialect-for-sqlalchemy">Kylin dialect for SQLAlchemy</h2> -<p>Any application that uses SQLAlchemy can now query Apache Kylin with this Apache Kylin dialect installed. It is part of the Apache Kylin Python Client Library, so if you already installed this library in the previous step, you are ready to use. You may use below template to build DSN to connect Apache Kylin</p> +<p>Any application that uses SQLAlchemy can now query Apache Kylin with this Apache Kylin dialect installed. It is part of the Apache Kylin Python Client Library, so if you already installed this library in the previous step, you are ready to use. You may use below template to build DSN to connect Apache Kylin.</p> <div class="highlighter-rouge"><pre class="highlight"><code>kylin://<username>:<password>@<hostname>:<port>/<project>?version=<v1|v2>&prefix=</kylin/api> </code></pre> Modified: kylin/site/feed.xml URL: http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1825064&r1=1825063&r2=1825064&view=diff ============================================================================== --- kylin/site/feed.xml (original) +++ kylin/site/feed.xml Thu Feb 22 14:02:15 2018 @@ -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>Thu, 15 Feb 2018 18:43:55 -0800</pubDate> - <lastBuildDate>Thu, 15 Feb 2018 18:43:55 -0800</lastBuildDate> + <pubDate>Thu, 22 Feb 2018 05:59:16 -0800</pubDate> + <lastBuildDate>Thu, 22 Feb 2018 05:59:16 -0800</lastBuildDate> <generator>Jekyll v2.5.3</generator> <item>