Author: lidong Date: Mon Sep 30 09:56:18 2019 New Revision: 1867762 URL: http://svn.apache.org/viewvc?rev=1867762&view=rev Log: modify the style of subtitle and indent
Added: kylin/site/assets/images/icon_index_streaming.png (with props) Modified: kylin/site/assets/css/styles.css kylin/site/blog/2019/09/22/kylin-tableau/index.html kylin/site/cn/index.html kylin/site/feed.xml kylin/site/index.html Modified: kylin/site/assets/css/styles.css URL: http://svn.apache.org/viewvc/kylin/site/assets/css/styles.css?rev=1867762&r1=1867761&r2=1867762&view=diff ============================================================================== --- kylin/site/assets/css/styles.css (original) +++ kylin/site/assets/css/styles.css Mon Sep 30 09:56:18 2019 @@ -77,7 +77,7 @@ blockquote p { } .card-s { height: 240px; - padding: 25px; + padding: 10px; } .card-m { height: 500px; @@ -747,7 +747,7 @@ a.section-menu-title:hover { bottom: 0; } .card-s .indent { - margin-top: 25px; + margin-top: 15px; } .card-l ul{ margin: 45px 0 0 20px; Added: kylin/site/assets/images/icon_index_streaming.png URL: http://svn.apache.org/viewvc/kylin/site/assets/images/icon_index_streaming.png?rev=1867762&view=auto ============================================================================== Binary file - no diff available. Propchange: kylin/site/assets/images/icon_index_streaming.png ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Modified: kylin/site/blog/2019/09/22/kylin-tableau/index.html URL: http://svn.apache.org/viewvc/kylin/site/blog/2019/09/22/kylin-tableau/index.html?rev=1867762&r1=1867761&r2=1867762&view=diff ============================================================================== --- kylin/site/blog/2019/09/22/kylin-tableau/index.html (original) +++ kylin/site/blog/2019/09/22/kylin-tableau/index.html Mon Sep 30 09:56:18 2019 @@ -41,7 +41,7 @@ <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Apache Kylin | Connecting Tableau Desktop and Tableau Server with Apache Kylin</title> - <meta name="description" content="BackgroundThis document describes how to connect Tableau to Apache Kylin OLAP server, particularly (but not only) in live mode to use both reporting and anal..."> + <meta name="description" content="Background"> <meta name="author" content="Apache Kylin"> <link rel="shortcut icon" href="fav.png" type="image/png"> @@ -6388,73 +6388,62 @@ var _hmt = _hmt || []; <article class="post-content" > <h2 id="background">Background</h2> + <p>This document describes how to connect Tableau to Apache Kylin OLAP server, particularly (but not only) in live mode to use both reporting and analytics features of Tableau together with Apache Kylinâs fast query processing engine. The configuration is platform independent - it works for both Windows and Linux installations of Tableau Server.</p> <p>For the time of writing this guide we tested that it works with Kylin 3.0.0 and Tableau Server 2019.1.</p> <h2 id="prerequisites">Prerequisites</h2> -<p>### Apache Kylin JDBC Driver<br /> -First we need to get Apache Kylin JDBC Driver - kylin-jdbc-X.Y.Z.jar file. You can either get it from the compiled package available on the download page http://kylin.apache.org/download/ from <code class="highlighter-rouge">lib</code> folder or compile it on your own using instructions below.</p> -<p><em>Note</em>: To make JDBC driver work properly, there has been a fix recently https://github.com/apache/kylin/pull/739 that upgraded one of the libraries used by the driver. The fix was applied for version 3, so if for some reason you need a jar for earlier version, you have to apply the fix on the lower versionâs codebase and compile yourself.<br /> -#### Compiling Apache Kylin JDBC Driver<br /> -<code class="highlighter-rouge"> -git clone https://github.com/apache/kylin.git +<h3 id="apache-kylin-jdbc-driver">Apache Kylin JDBC Driver</h3> + +<p>First we need to get Apache Kylin JDBC Driver - kylin-jdbc-X.Y.Z.jar file. You can either get it from the compiled package available on the download page http://kylin.apache.org/download/ from <code class="highlighter-rouge">lib</code> folder or compile it on your own using instructions below.</p> + +<p><em>Note</em>: To make JDBC driver work properly, there has been a fix recently https://github.com/apache/kylin/pull/739 that upgraded one of the libraries used by the driver. The fix was applied for version 3, so if for some reason you need a jar for earlier version, you have to apply the fix on the lower versionâs codebase and compile yourself.</p> + +<h4 id="compiling-apache-kylin-jdbc-driver">Compiling Apache Kylin JDBC Driver</h4> + +<div class="highlighter-rouge"><pre class="highlight"><code>git clone https://github.com/apache/kylin.git cd kylin mvn clean package -DskipTests -am -pl jdbc -</code></p> +</code></pre> +</div> <p>The compiled jar is located in the following location: <code class="highlighter-rouge">jdbc/target/kylin-jdbc-X.Y.Z.jar</code></p> <h3 id="tableau-server-on-linux">Tableau Server on Linux</h3> + <p>If you have installed Tableau Server in a Linux box, e.g. CentOS, copy the driverâs jar file to the following location: <code class="highlighter-rouge">/opt/tableau/tableau_driver/jdbc/</code> and restart Tableau Server. <br /> The server is now ready to create and refresh data from Apache Kylin.</p> <h3 id="tableau-server-and-tableau-desktop-on-windows">Tableau Server and Tableau Desktop on Windows</h3> + <p>For either Tableau Server or Tableau Desktop that is installed on a Windows machine, copy the driverâs jar file to the following location <code class="highlighter-rouge">C:\Program Files\Tableau\Drivers</code> and restart Tableau Server or reopen Tableau Desktop.</p> <p>Some more details regarding jdbc connection from Tableau are well described in Tableauâs documentation: https://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_otherdatabases_jdbc.htm.</p> <h2 id="creating-report-in-tableau-desktop---connecting-to-apache-kylin">Creating report in Tableau Desktop - connecting to Apache Kylin</h2> + <p>To create report follow the steps:<br /> 1. Open Tableau Desktop<br /> -2. Use âOther Databases (JDBC)â to create connection for the data source</p> - -<p><img src="/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg" alt="Other Databases (JDBC)" /></p> - -<ol> - <li>Configure the connection in the following way: - <ul> - <li>URL: <code class="highlighter-rouge">jdbc:kylin://<kylin-server-name>:<kylin-port>/<project></code></li> - <li>Dialect: <code class="highlighter-rouge">SQL92</code></li> - </ul> - </li> -</ol> - -<p><img src="/images/blog/kylin-tableau/tableau_kylin_connection.jpg" alt="Datasource connection" /></p> - -<ol> - <li>Configure data source as follows: - <ul> - <li>Database: <code class="highlighter-rouge">defaultCatalog</code></li> - <li>Schema: <code class="highlighter-rouge">DEFAULT</code></li> - </ul> - </li> -</ol> - -<p>You should be able to see the tables/cubes in the Apache Kylinâs project</p> - -<p><img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg" alt="Data source" /></p> - -<p><strong>Important</strong>: Decide if you want the data source be in <code class="highlighter-rouge">live</code> or <code class="highlighter-rouge">extract</code> mode. Some of the functions might not work in <code class="highlighter-rouge">live</code> mode as for the other data sources - itâs just how Tableau works. Recommendation is to start with <code class="highlighter-rouge">live</code> mode to utilize performance of Apache Kylin. If youâre forced to switch to <code class="highlighter-rouge">extract</code> mode - consider creating a custom query against Apache Kylinâs cubes to retrieve as small amount of data as possible as it will help the report to perform well.</p> - -<ol> - <li>Finish designing your data source and then switch to worksheets, dashboards</li> -</ol> +2. Use âOther Databases (JDBC)â to create connection for the data source<br /> +<img src="/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg" alt="Other Databases (JDBC)" /><br /> +3. Configure the connection in the following way:<br /> +- URL: <code class="highlighter-rouge">jdbc:kylin://<kylin-server-name>:<kylin-port>/<project></code><br /> +- Dialect: <code class="highlighter-rouge">SQL92</code><br /> +<img src="/images/blog/kylin-tableau/tableau_kylin_connection.jpg" alt="Datasource connection" /><br /> +4. Configure data source as follows:<br /> +- Database: <code class="highlighter-rouge">defaultCatalog</code><br /> +- Schema: <code class="highlighter-rouge">DEFAULT</code><br /> +You should be able to see the tables/cubes in the Apache Kylinâs project<br /> +<img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg" alt="Data source" /><br /> +<strong>Important</strong>: Decide if you want the data source be in <code class="highlighter-rouge">live</code> or <code class="highlighter-rouge">extract</code> mode. Some of the functions might not work in <code class="highlighter-rouge">live</code> mode as for the other data sources - itâs just how Tableau works. Recommendation is to start with <code class="highlighter-rouge">live</code> mode to utilize performance of Apache Kylin. If youâre forced to switch to <code class="highlighter-rouge">extract</code> mode - consider creating a custom query against Apache Kylinâs cubes to retrieve as small amount of data as possible as it will help the report to perform well.<br /> +5. Finish designing your data source and then switch to worksheets, dashboards</p> <p><img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_working_sheet.jpg" alt="Tableau Desktop" /></p> <h2 id="publishing-reports-from-tableau-desktop-to-tableau-server">Publishing reports from Tableau Desktop to Tableau Server</h2> + <p>To publish the data source and the report follow these steps:<br /> 1. In Tableau Desktop from top menu select Server -> Publish<br /> 2. Choose the settings for publishing like Project, select sheets<br /> Modified: kylin/site/cn/index.html URL: http://svn.apache.org/viewvc/kylin/site/cn/index.html?rev=1867762&r1=1867761&r2=1867762&view=diff ============================================================================== --- kylin/site/cn/index.html (original) +++ kylin/site/cn/index.html Mon Sep 30 09:56:18 2019 @@ -42,7 +42,7 @@ <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> - <title>Apache Kylin | é¦é¡µ</title> + <title>Apache Kylin | 大æ°æ®ä¸çOLAPå¼æ</title> <meta name="description" content="Apache Kylin Home"> <meta name="author" content="Apache Kylin"> <link rel="shortcut icon" href="fav.png" type="image/png"> @@ -186,6 +186,24 @@ var _hmt = _hmt || []; <div class="row" style="margin-top:-20px;"> <div class="col-sm-12 col-md-12"> <p class="title_text"> Apache Kylinâ¢æ¯ä¸ä¸ªå¼æºçåå¸å¼åæå¼æï¼æä¾Hadoop/Sparkä¹ä¸çSQLæ¥è¯¢æ¥å£åå¤ç»´åæï¼OLAPï¼è½å以æ¯æè¶ å¤§è§æ¨¡æ°æ®ï¼æåç±eBay Inc. å¼å并贡ç®è³å¼æºç¤¾åºãå®è½å¨äºç§å æ¥è¯¢å·¨å¤§çHive表ã</p> + <p class="title_text"> Apache Kylinâ¢ä»¤ä½¿ç¨è ä» éä¸æ¥ï¼å³å¯å®ç°è¶ 大æ°æ®éä¸çäºç§çº§æ¥è¯¢ã</p> + <div align="left"> + <ol class="none-icon"> + <li> + <span class="li-circle">1</span> + å®ä¹æ°æ®éä¸çä¸ä¸ªæå½¢æéªè±å½¢æ¨¡å + </li> + <li> + <span class="li-circle">2</span> + å¨å®ä¹çæ°æ®è¡¨ä¸æ建cube + </li> + <li> + <span class="li-circle">3</span> + 使ç¨æ åSQLéè¿ODBCãJDBCæRESTFUL APIè¿è¡æ¥è¯¢ï¼ä» éäºç§çº§ååºæ¶é´å³å¯è·å¾æ¥è¯¢ç»æ + </li> + </ol> + </div> + <p class="title_text">Kylinæä¾ä¸å¤ç§æ°æ®å¯è§åå·¥å ·çæ´åè½åï¼å¦Tableauï¼PowerBIçï¼ä»¤ç¨æ·å¯ä»¥ä½¿ç¨BIå·¥å ·å¯¹Hadoopæ°æ®è¿è¡åæã</p> <img id="diagram" src="/assets/images/kylin_diagram.png" /> </div> </div> </div> @@ -208,7 +226,7 @@ var _hmt = _hmt || []; <div class="home-pic"> <img width="30" src="/assets/images/icon_index_olap.png" /> </div> - <b>å¯æ©å±è¶ å¿«OLAPå¼æ: </b><br /> + <b>å¯æ©å±è¶ å¿«çåºäºå¤§æ°æ®çOLAPå¼æ: </b><br /> <div class="indent" style="margin-top: 25px">Kylinæ¯ä¸ºåå°å¨Hadoop/Sparkä¸ç¾äº¿è§æ¨¡æ°æ®æ¥è¯¢å»¶è¿è设计</div> </div> </div> @@ -218,7 +236,7 @@ var _hmt = _hmt || []; <img width="30" src="/assets/images/icon_index_hadoop.png" /> </div> <b>Hadoop ANSI SQL æ¥å£: </b><br /> - <div class="indent" style="margin-top: 25px">Kylin为Hadoopæä¾æ åSQLæ¯æ大é¨åæ¥è¯¢åè½</div> + <div class="indent" style="margin-top: 25px">ä½ä¸ºä¸ä¸ªOLAPå¼æï¼Kylin为Hadoopæä¾æ åSQLæ¯æ大é¨åæ¥è¯¢åè½</div> </div> </div> <div class="col-sm-6 col-md-6"> @@ -239,7 +257,16 @@ var _hmt = _hmt || []; <div class="indent" style="margin-top: 25px">ç¨æ·è½å¤å¨Kyliné为ç¾äº¿ä»¥ä¸æ°æ®éå®ä¹æ°æ®æ¨¡å并æ建ç«æ¹ä½</div> </div> </div> - <div class="col-sm-12 col-md-12"> + <div class="col-sm-6 col-md-6"> + <div class="card-s"> + <div class="home-pic"> + <img width="30" src="/assets/images/icon_index_streaming.png" /> + </div> + <b>å®æ¶ OLAPï¼</b><br /> + <div class="indent">Kylinå¯ä»¥å¨æ°æ®äº§çæ¶è¿è¡å®æ¶å¤çï¼ç¨æ·å¯ä»¥å¨ç§çº§å»¶è¿ä¸è¿è¡å®æ¶æ°æ®çå¤ç»´åæã </div> + </div> + </div> + <div class="col-sm-6 col-md-6"> <div class="card-s"> <div class="home-pic"> <img width="30" src="/assets/images/icon_index_shape.png" /> Modified: kylin/site/feed.xml URL: http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1867762&r1=1867761&r2=1867762&view=diff ============================================================================== --- kylin/site/feed.xml (original) +++ kylin/site/feed.xml Mon Sep 30 09:56:18 2019 @@ -19,80 +19,69 @@ <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>Fri, 27 Sep 2019 06:59:31 -0700</pubDate> - <lastBuildDate>Fri, 27 Sep 2019 06:59:31 -0700</lastBuildDate> + <pubDate>Mon, 30 Sep 2019 02:44:36 -0700</pubDate> + <lastBuildDate>Mon, 30 Sep 2019 02:44:36 -0700</lastBuildDate> <generator>Jekyll v2.5.3</generator> <item> <title>Connecting Tableau Desktop and Tableau Server with Apache Kylin</title> <description><h2 id="background">Background</h2> + <p>This document describes how to connect Tableau to Apache Kylin OLAP server, particularly (but not only) in live mode to use both reporting and analytics features of Tableau together with Apache Kylinâs fast query processing engine. The configuration is platform independent - it works for both Windows and Linux installations of Tableau Server.</p> <p>For the time of writing this guide we tested that it works with Kylin 3.0.0 and Tableau Server 2019.1.</p> <h2 id="prerequisites">Prerequisites</h2> -<p>### Apache Kylin JDBC Driver<br /> -First we need to get Apache Kylin JDBC Driver - kylin-jdbc-X.Y.Z.jar file. You can either get it from the compiled package available on the download page http://kylin.apache.org/download/ from <code class="highlighter-rouge">lib</code> folder or compile it on your own using instructions below.</p> -<p><em>Note</em>: To make JDBC driver work properly, there has been a fix recently https://github.com/apache/kylin/pull/739 that upgraded one of the libraries used by the driver. The fix was applied for version 3, so if for some reason you need a jar for earlier version, you have to apply the fix on the lower versionâs codebase and compile yourself.<br /> -#### Compiling Apache Kylin JDBC Driver<br /> -<code class="highlighter-rouge"> -git clone https://github.com/apache/kylin.git +<h3 id="apache-kylin-jdbc-driver">Apache Kylin JDBC Driver</h3> + +<p>First we need to get Apache Kylin JDBC Driver - kylin-jdbc-X.Y.Z.jar file. You can either get it from the compiled package available on the download page http://kylin.apache.org/download/ from <code class="highlighter-rouge">lib</code> folder or compile it on your own using instructions below.</p> + +<p><em>Note</em>: To make JDBC driver work properly, there has been a fix recently https://github.com/apache/kylin/pull/739 that upgraded one of the libraries used by the driver. The fix was applied for version 3, so if for some reason you need a jar for earlier version, you have to apply the fix on the lower versionâs codebase and compile yourself.</p> + +<h4 id="compiling-apache-kylin-jdbc-driver">Compiling Apache Kylin JDBC Driver</h4> + +<div class="highlighter-rouge"><pre class="highlight"><code>git clone https://github.com/apache/kylin.git cd kylin mvn clean package -DskipTests -am -pl jdbc -</code></p> +</code></pre> +</div> <p>The compiled jar is located in the following location: <code class="highlighter-rouge">jdbc/target/kylin-jdbc-X.Y.Z.jar</code></p> <h3 id="tableau-server-on-linux">Tableau Server on Linux</h3> + <p>If you have installed Tableau Server in a Linux box, e.g. CentOS, copy the driverâs jar file to the following location: <code class="highlighter-rouge">/opt/tableau/tableau_driver/jdbc/</code> and restart Tableau Server. <br /> The server is now ready to create and refresh data from Apache Kylin.</p> <h3 id="tableau-server-and-tableau-desktop-on-windows">Tableau Server and Tableau Desktop on Windows</h3> + <p>For either Tableau Server or Tableau Desktop that is installed on a Windows machine, copy the driverâs jar file to the following location <code class="highlighter-rouge">C:\Program Files\Tableau\Drivers</code> and restart Tableau Server or reopen Tableau Desktop.</p> <p>Some more details regarding jdbc connection from Tableau are well described in Tableauâs documentation: https://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_otherdatabases_jdbc.htm.</p> <h2 id="creating-report-in-tableau-desktop---connecting-to-apache-kylin">Creating report in Tableau Desktop - connecting to Apache Kylin</h2> + <p>To create report follow the steps:<br /> 1. Open Tableau Desktop<br /> -2. Use âOther Databases (JDBC)â to create connection for the data source</p> - -<p><img src="/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg" alt="Other Databases (JDBC)" /></p> - -<ol> - <li>Configure the connection in the following way: - <ul> - <li>URL: <code class="highlighter-rouge">jdbc:kylin://&lt;kylin-server-name&gt;:&lt;kylin-port&gt;/&lt;project&gt;</code></li> - <li>Dialect: <code class="highlighter-rouge">SQL92</code></li> - </ul> - </li> -</ol> - -<p><img src="/images/blog/kylin-tableau/tableau_kylin_connection.jpg" alt="Datasource connection" /></p> - -<ol> - <li>Configure data source as follows: - <ul> - <li>Database: <code class="highlighter-rouge">defaultCatalog</code></li> - <li>Schema: <code class="highlighter-rouge">DEFAULT</code></li> - </ul> - </li> -</ol> - -<p>You should be able to see the tables/cubes in the Apache Kylinâs project</p> - -<p><img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg" alt="Data source" /></p> - -<p><strong>Important</strong>: Decide if you want the data source be in <code class="highlighter-rouge">live</code> or <code class="highlighter-rouge">extract</code> mode. Some of the functions might not work in <code class="highlighter-rouge">live</code> mode as for the other data sources - itâs just how Tableau works. Recommendation is to start with <code class="highlighter-rouge">live</code> mode to utilize performance of Apache Kylin. If youâre forced to switch to <code class="highlighter-rouge">extract</code> mode - consider creating a custom query against Apache Kylinâs cubes to retrieve as small amount of data as possible as it will help the report to perform well.</p> - -<ol> - <li>Finish designing your data source and then switch to worksheets, dashboards</li> -</ol> +2. Use âOther Databases (JDBC)â to create connection for the data source<br /> +<img src="/images/blog/kylin-tableau/tableau_other_databases_jdbc.jpg" alt="Other Databases (JDBC)" /><br /> +3. Configure the connection in the following way:<br /> +- URL: <code class="highlighter-rouge">jdbc:kylin://&lt;kylin-server-name&gt;:&lt;kylin-port&gt;/&lt;project&gt;</code><br /> +- Dialect: <code class="highlighter-rouge">SQL92</code><br /> +<img src="/images/blog/kylin-tableau/tableau_kylin_connection.jpg" alt="Datasource connection" /><br /> +4. Configure data source as follows:<br /> +- Database: <code class="highlighter-rouge">defaultCatalog</code><br /> +- Schema: <code class="highlighter-rouge">DEFAULT</code><br /> +You should be able to see the tables/cubes in the Apache Kylinâs project<br /> +<img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_working.jpg" alt="Data source" /><br /> +<strong>Important</strong>: Decide if you want the data source be in <code class="highlighter-rouge">live</code> or <code class="highlighter-rouge">extract</code> mode. Some of the functions might not work in <code class="highlighter-rouge">live</code> mode as for the other data sources - itâs just how Tableau works. Recommendation is to start with <code class="highlighter-rouge">live</code> mode to utilize performance of Apache Kylin. If youâre forced to switch to <code class="highlighter-rouge">extract</code> mode - consider creating a custom query against Apache Kylinâs cubes to retrieve as small amount of data as possible as it will help the report to perform well.<br /> +5. Finish designing your data source and then switch to worksheets, dashboards</p> <p><img src="/images/blog/kylin-tableau/kylin_jdbc_tableau_working_sheet.jpg" alt="Tableau Desktop" /></p> <h2 id="publishing-reports-from-tableau-desktop-to-tableau-server">Publishing reports from Tableau Desktop to Tableau Server</h2> + <p>To publish the data source and the report follow these steps:<br /> 1. In Tableau Desktop from top menu select Server -&gt; Publish<br /> 2. Choose the settings for publishing like Project, select sheets<br /> Modified: kylin/site/index.html URL: http://svn.apache.org/viewvc/kylin/site/index.html?rev=1867762&r1=1867761&r2=1867762&view=diff ============================================================================== --- kylin/site/index.html (original) +++ kylin/site/index.html Mon Sep 30 09:56:18 2019 @@ -42,7 +42,7 @@ <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> - <title>Apache Kylin | Home</title> + <title>Apache Kylin | OLAP engine for big data</title> <meta name="description" content="Apache Kylin Home"> <meta name="author" content="Apache Kylin"> <link rel="shortcut icon" href="fav.png" type="image/png"> @@ -6363,7 +6363,7 @@ var _hmt = _hmt || []; <div class="row" style="margin-top:-20px;"> <div class="col-sm-12 col-md-12"> <p class="title_text">Apache Kylin⢠is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop/Spark supporting extremely large datasets, original contributed from eBay Inc.</p> - <p class="title_text">Apache Kylin⢠lets you query massive data set at sub-second latency in 3 steps.</p> + <p class="title_text">Apache Kylin⢠lets you query massively big data set at sub-second latency in 3 steps.</p> <div align="left"> <ol class="none-icon"> <li> @@ -6379,7 +6379,8 @@ var _hmt = _hmt || []; Query with ANSI-SQL and get results in sub-second, via ODBC, JDBC or RESTful API. </li> </ol> - </div> + </div> + <p class="title_text">Kylin offers integration capability with data visualization softwares like Tableau, PowerBI, etc., which enables data analysis with BI tools on Hadoop.</p> <img id="diagram" src="assets/images/kylin_diagram.png" /> </div> </div> @@ -6403,17 +6404,26 @@ var _hmt = _hmt || []; <div class="home-pic"> <img width="30" src="assets/images/icon_index_olap.png" /> </div> - <b>Extremely Fast OLAP Engine at Scale: </b><br /> + <h6><b>Extremely Fast OLAP Engine for Big Data at Scale: </b></h6> <div class="indent" style="margin-top: 25px">Kylin is designed to reduce query latency on Hadoop/Spark for 10+ billions of rows of data</div> </div> </div> <div class="col-sm-6 col-md-6"> <div class="card-s"> <div class="home-pic"> + <img width="30" src="assets/images/icon_index_shape.png" /> + </div> + <h6><b>Seamless Integration with BI Tools:</b></h6> + <div class="indent">Kylin currently offers integration capability with BI Tools like Tableau, PowerBI/Excel, MSTR, QlikSense, Hue and SuperSet</div> + </div> + </div> + <div class="col-sm-6 col-md-6"> + <div class="card-s"> + <div class="home-pic"> <img width="30" src="assets/images/icon_index_hadoop.png" /> </div> - <b>ANSI SQL Interface on Hadoop: </b><br /> - <div class="indent" style="margin-top: 25px">Kylin offers ANSI SQL on Hadoop/Spark and supports most ANSI SQL query functions</div> + <h6><b>ANSI SQL Interface for Big Data on Hadoop: </b></h6> + <div class="indent" style="margin-top: 25px">As an OLAP engine, Kylin offers ANSI SQL on Hadoop/Spark and supports most ANSI SQL query functions</div> </div> </div> <div class="col-sm-6 col-md-6"> @@ -6421,31 +6431,31 @@ var _hmt = _hmt || []; <div class="home-pic"> <img width="30" src="assets/images/icon_index_query.png" /> </div> - <b>Interactive Query Capability: </b><br /> + <h6><b>Interactive Query with Low Latency and High Performance: </b></h6> <div class="indent" style="margin-top: 25px">Users can interact with Hadoop data via Kylin at sub-second latency, better than Hive queries for the same dataset</div> </div> </div> - <div class="col-sm-6 col-md-6"> + <div class="col-sm-6 col-md-6"> <div class="card-s"> <div class="home-pic"> - <img width="30" src="assets/images/icon_index_cube.png" /> + <img width="30" src="assets/images/icon_index_streaming.png" /> </div> - <b>MOLAP Cube:</b><br /> - <div class="indent" style="margin-top: 25px">User can define a data model and pre-build in Kylin with more than 10+ billions of raw data records</div> + <h6><b>Real-time OLAP for Streaming Big Data:</b></h6> + <div class="indent">Kylin is able to compute streaming data once it is generated, user is capable of doing real-time data analysis with latencey on second level</div> </div> </div> - <div class="col-sm-12 col-md-12"> + <div class="col-sm-6 col-md-6"> <div class="card-s"> <div class="home-pic"> - <img width="30" src="assets/images/icon_index_shape.png" /> + <img width="30" src="assets/images/icon_index_cube.png" /> </div> - <b>Seamless Integration with BI Tools:</b><br /> - <div class="indent">Kylin currently offers integration capability with BI Tools like Tableau, PowerBI/Excel, MSTR, QlikSense, Hue and SuperSet. </div> + <h6><b>MOLAP Cube:</b></h6> + <div class="indent" style="margin-top: 25px">User can define a data model and pre-build in Kylin with more than 10+ billions of raw data records</div> </div> </div> </div> <div class="col-sm-4 col-md-4 card-l"> - <b>Other Highlights:</b> <br /> + <b>Other Highlights: </b> <br /> <ul class="indent"> <li>Job Management and Monitoring </li> <li>Compression and Encoding Support </li>