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 2019/01/28 14:09:40 UTC
svn commit: r1852366 - in /kylin/site: cn/development/datasource_sdk.html development/datasource_sdk.html feed.xml

Author: lidong
Date: Mon Jan 28 14:09:40 2019
New Revision: 1852366

URL: http://svn.apache.org/viewvc?rev=1852366&view=rev
Log:
minor add more detail for data source sdk

Modified:
    kylin/site/cn/development/datasource_sdk.html
    kylin/site/development/datasource_sdk.html
    kylin/site/feed.xml

Modified: kylin/site/cn/development/datasource_sdk.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/development/datasource_sdk.html?rev=1852366&r1=1852365&r2=1852366&view=diff
==============================================================================
--- kylin/site/cn/development/datasource_sdk.html (original)
+++ kylin/site/cn/development/datasource_sdk.html Mon Jan 28 14:09:40 2019
@@ -6042,10 +6042,81 @@ var _hmt = _hmt || [];
 <p>å¼åèä¸éè¦ç¼ç , åªéè¦ä¸ºæ°çæ°æ®æºæ°å»ºä¸ä¸ªéç½®æä»¶ <em>{dialect}.xml</em>,</p>
 
 <p>éç½®æä»¶ç»æ:<br />
-* æ ¹èç¹:  <br />
-&lt;DATASOURCE_DEF NAME=âkylinâ ID=âdefaultâ&gt;, IDçå¼ä¸ºæ¹è¨çåç§°.<br />
-* å±æ§èç¹:  <br />
-å®ä¹æ¹è¨çå±æ§ã</p>
+* æ ¹èç¹:</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>&lt;DATASOURCE_DEF NAME="kylin" ID="mysql" DIALECT="mysql"/&gt;
+</code></pre>
+</div>
+
+<p>IDçå¼éå¸¸åéç½®æä»¶çååç¸åã  <br />
+DIALECTçå¼çå®ä¹ä¸»è¦æ¯ä¸ºäºåºåä¸åæ°æ®åºå¯¹äºæ è¯ç¬¦çå¼ç¨ã  <br />
+ä¸¾ä¸ªä¾å Mysql ä½¿ç¨ ``, Microsoft sql server ä½¿ç¨ [].   <br />
+Kylin éå®ä¹çDIALECT å Apache Calcite éå®ä¹DIALECT çå¯¹åºå³ç³»:</p>
+<table>
+  <tbody align="left">  
+  <tr>
+    <td align="center"> Kylin éå®ä¹çæ¹è¨ </td>
+    <td align="center"> Apache Calcite éå®ä¹çæ¹è¨ </td>
+  </tr>
+  <tr>
+    <td> default </td>
+    <td> SqlDialect.CALCITE </td>
+  </tr>
+  <tr>
+    <td> calcite </td>
+    <td> SqlDialect.CALCITE </td>
+  </tr>
+  <tr>
+    <td> greenplum </td>
+    <td> SqlDialect.DatabaseProduct.POSTGRESQL </td>
+  </tr>
+  <tr>
+    <td> postgresql </td>
+    <td> SqlDialect.DatabaseProduct.POSTGRESQL </td>
+  </tr>
+  <tr>
+    <td> mysql  </td>
+    <td> SqlDialect.DatabaseProduct.MYSQL </td>
+  </tr>
+  <tr>
+     <td> sql.keyword-default-uppercase </td>
+     <td> whether &lt;default&gt; should be transform to uppercase </td>
+  </tr>
+  <tr>
+    <td> mssql </td>
+    <td> SqlDialect.DatabaseProduct.MSSQL </td>
+  </tr>
+  <tr>
+    <td> oracle </td>
+    <td> SqlDialect.DatabaseProduct.ORACLE </td>
+  </tr>
+  <tr>
+    <td> vertica </td>
+    <td> SqlDialect.DatabaseProduct.VERTICA </td>
+  </tr>
+  <tr>
+    <td> redshift </td>
+    <td> SqlDialect.DatabaseProduct.REDSHIFT </td>
+  </tr>
+  <tr>
+    <td> hive </td>
+    <td> SqlDialect.DatabaseProduct.HIVE </td>
+  </tr>
+  <tr>
+    <td> h2 </td>
+    <td> SqlDialect.DatabaseProduct.H2 </td>
+  </tr>
+  <tr>
+    <td> unkown </td>
+    <td> SqlDialect.DUMMY </td>
+  </tr>    
+  </tbody>
+</table>
+
+<ul>
+  <li>å±æ§èç¹:  <br />
+å®ä¹æ¹è¨çå±æ§ã</li>
+</ul>
 
 <table>
   <tbody align="left">  
@@ -6164,9 +6235,9 @@ kylin.source.jdbc.driver={JDBC é©±å�
 kylin.source.default=16
 kylin.source.jdbc.dialect=mysql
 kylin.source.jdbc.adaptor=org.apache.kylin.sdk.datasource.adaptor.MysqlAdaptor
-kylin.source.jdbc.user={mysql username}
-kylin.source.jdbc.pass={mysql password}
-kylin.source.jdbc.connection-url=jdbc:mysql://{HOST_URL}:3306/{Database name}
+kylin.source.jdbc.user={mysql ç¨æ·å}
+kylin.source.jdbc.pass={mysql ç¨æ·å¯ç }
+kylin.source.jdbc.connection-url=jdbc:mysql://{ä¸»æºurl}:3306/{æ°æ®åºåç§°}
 kylin.source.jdbc.driver=com.mysql.jdbc.Driver</code></pre></div>
 
 <p>æ°å¢å ç <em>{dialect}.xml</em> æ¾ç½®å¨ $KYLIN_HOME/conf/datasource ç®å½ä¸ã<br />

Modified: kylin/site/development/datasource_sdk.html
URL: http://svn.apache.org/viewvc/kylin/site/development/datasource_sdk.html?rev=1852366&r1=1852365&r2=1852366&view=diff
==============================================================================
--- kylin/site/development/datasource_sdk.html (original)
+++ kylin/site/development/datasource_sdk.html Mon Jan 28 14:09:40 2019
@@ -6026,7 +6026,9 @@ var _hmt = _hmt || [];
 						<div id="pjax">
 							<h1 class="post-title">Develop JDBC Data Source</h1>
 							<article class="post-content" >
-							<p>&gt; Available since Apache Kylin v2.6.0</p>
+							<blockquote>
+  <p>Available since Apache Kylin v2.6.0</p>
+</blockquote>
 
 <h2 id="data-source-sdk">Data source SDK</h2>
 
@@ -6043,8 +6045,79 @@ var _hmt = _hmt || [];
 <p>Structure of the configuration:</p>
 
 <ul>
-  <li>Root node:  <br />
-&lt;DATASOURCE_DEF NAME=âkylinâ ID=âdefaultâ&gt;, the value of ID should be name of dialect.</li>
+  <li>Root node:</li>
+</ul>
+
+<div class="highlighter-rouge"><pre class="highlight"><code>&lt;DATASOURCE_DEF NAME="kylin" ID="mysql" DIALECT="mysql"/&gt;
+</code></pre>
+</div>
+
+<p>The value of ID is normally the same with configuration file.  <br />
+The value of DIALECT is defined mainly for quote string for database identifier.  <br />
+For example Mysql use ``, Microsoft sql server use [].   <br />
+Mapping of Kylin DIALECT and Apache Calcite Dialect as belows:</p>
+<table>
+  <tbody align="left">  
+  <tr>
+    <td align="center">Dialect in Kylin</td>
+    <td align="center">Dialect in Apache Calcite</td>
+  </tr>
+  <tr>
+    <td> default </td>
+    <td> SqlDialect.CALCITE </td>
+  </tr>
+  <tr>
+    <td> calcite </td>
+    <td> SqlDialect.CALCITE </td>
+  </tr>
+  <tr>
+    <td> greenplum </td>
+    <td> SqlDialect.DatabaseProduct.POSTGRESQL </td>
+  </tr>
+  <tr>
+    <td> postgresql </td>
+    <td> SqlDialect.DatabaseProduct.POSTGRESQL </td>
+  </tr>
+  <tr>
+    <td> mysql  </td>
+    <td> SqlDialect.DatabaseProduct.MYSQL </td>
+  </tr>
+  <tr>
+     <td> sql.keyword-default-uppercase </td>
+     <td> whether &lt;default&gt; should be transform to uppercase </td>
+  </tr>
+  <tr>
+    <td> mssql </td>
+    <td> SqlDialect.DatabaseProduct.MSSQL </td>
+  </tr>
+  <tr>
+    <td> oracle </td>
+    <td> SqlDialect.DatabaseProduct.ORACLE </td>
+  </tr>
+  <tr>
+    <td> vertica </td>
+    <td> SqlDialect.DatabaseProduct.VERTICA </td>
+  </tr>
+  <tr>
+    <td> redshift </td>
+    <td> SqlDialect.DatabaseProduct.REDSHIFT </td>
+  </tr>
+  <tr>
+    <td> hive </td>
+    <td> SqlDialect.DatabaseProduct.HIVE </td>
+  </tr>
+  <tr>
+    <td> h2 </td>
+    <td> SqlDialect.DatabaseProduct.H2 </td>
+  </tr>
+  <tr>
+    <td> unkown </td>
+    <td> SqlDialect.DUMMY </td>
+  </tr>    
+  </tbody>
+</table>
+
+<ul>
   <li>Property node:  <br />
 Define the properties of the dialect.</li>
 </ul>
@@ -6052,8 +6125,8 @@ Define the properties of the dialect.</l
 <table>
   <tbody align="left">  
   <tr>
-    <td align="center">å±æ§</td>
-    <td align="center">æè¿°</td>
+    <td align="center">Property</td>
+    <td align="center">Description</td>
   </tr>
   <tr>
     <td> sql.default-converted-enabled </td>
@@ -6165,9 +6238,9 @@ kylin.source.jdbc.driver={JDBC Driver Cl
 kylin.source.default=16
 kylin.source.jdbc.dialect=mysql
 kylin.source.jdbc.adaptor=org.apache.kylin.sdk.datasource.adaptor.MysqlAdaptor
-kylin.source.jdbc.user={mysql username}
-kylin.source.jdbc.pass={mysql password}
-kylin.source.jdbc.connection-url=jdbc:mysql://{HOST_URL}:3306/{Database name}
+kylin.source.jdbc.user={MYSQL_USERNAME}
+kylin.source.jdbc.pass={MYSQL_PASSWORD}
+kylin.source.jdbc.connection-url=jdbc:mysql://{HOST_URL}:3306/{DATABASE_NAME}
 kylin.source.jdbc.driver=com.mysql.jdbc.Driver</code></pre></div>
 
 <p>Put the configuration file <em>{dialect}.xml</em> under directory $KYLIN_HOME/conf/datasource.<br />

Modified: kylin/site/feed.xml
URL: http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1852366&r1=1852365&r2=1852366&view=diff
==============================================================================
--- kylin/site/feed.xml (original)
+++ kylin/site/feed.xml Mon Jan 28 14:09:40 2019
@@ -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>Tue, 22 Jan 2019 05:59:17 -0800</pubDate>
-    <lastBuildDate>Tue, 22 Jan 2019 05:59:17 -0800</lastBuildDate>
+    <pubDate>Mon, 28 Jan 2019 05:59:25 -0800</pubDate>
+    <lastBuildDate>Mon, 28 Jan 2019 05:59:25 -0800</lastBuildDate>
     <generator>Jekyll v2.5.3</generator>
     
       <item>