http://git-wip-us.apache.org/repos/asf/carbondata-site/blob/14d670df/src/main/webapp/bloomfilter-datamap-guide.html ---------------------------------------------------------------------- diff --git a/src/main/webapp/bloomfilter-datamap-guide.html b/src/main/webapp/bloomfilter-datamap-guide.html index 41aef5c..e3b3eb6 100644 --- a/src/main/webapp/bloomfilter-datamap-guide.html +++ b/src/main/webapp/bloomfilter-datamap-guide.html @@ -51,6 +51,9 @@ aria-expanded="false"> Download <span class="caret"></span></a> <ul class="dropdown-menu"> <li> + <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.1/"; + target="_blank">Apache CarbonData 1.4.1</a></li> + <li> <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.0/"; target="_blank">Apache CarbonData 1.4.0</a></li> <li> @@ -60,27 +63,6 @@ <a href="https://dist.apache.org/repos/dist/release/carbondata/1.3.0/"; target="_blank">Apache CarbonData 1.3.0</a></li> <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.2.0/"; - target="_blank">Apache CarbonData 1.2.0</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.1/"; - target="_blank">Apache CarbonData 1.1.1</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.0/"; - target="_blank">Apache CarbonData 1.1.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/1.0.0-incubating/"; - target="_blank">Apache CarbonData 1.0.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.2.0-incubating/"; - target="_blank">Apache CarbonData 0.2.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.1-incubating/"; - target="_blank">Apache CarbonData 0.1.1</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.0-incubating/"; - target="_blank">Apache CarbonData 0.1.0</a></li> - <li> <a href="https://cwiki.apache.org/confluence/display/CARBONDATA/Releases"; target="_blank">Release Archive</a></li> </ul> @@ -176,14 +158,16 @@ <div id="viewpage" name="viewpage"> <div class="row"> <div class="col-sm-12 col-md-12"> - <div><h1> -<a id="carbondata-bloomfilter-datamap-alpha-feature-in-140" class="anchor" href="#carbondata-bloomfilter-datamap-alpha-feature-in-140" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>CarbonData BloomFilter DataMap (Alpha feature in 1.4.0)</h1> + <div> +<h1> +<a id="carbondata-bloomfilter-datamap-alpha-feature" class="anchor" href="#carbondata-bloomfilter-datamap-alpha-feature" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>CarbonData BloomFilter DataMap (Alpha Feature)</h1> <ul> <li><a href="#datamap-management">DataMap Management</a></li> <li><a href="#bloomfilter-datamap-introduction">BloomFilter Datamap Introduction</a></li> <li><a href="#loading-data">Loading Data</a></li> <li><a href="#querying-data">Querying Data</a></li> <li><a href="#data-management-with-bloomfilter-datamap">Data Management</a></li> +<li><a href="#useful-tips">Useful Tips</a></li> </ul> <h4> <a id="datamap-management" class="anchor" href="#datamap-management" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>DataMap Management</h4> @@ -201,14 +185,22 @@ ON TABLE main_table <pre><code>SHOW DATAMAP ON TABLE main_table </code></pre> -<p>It will show all DataMaps created on main table.</p> +<p>Disable Datamap</p> +<blockquote> +<p>The datamap by default is enabled. To support tuning on query, we can disable a specific datamap during query to observe whether we can gain performance enhancement from it. This will only take effect current session.</p> +</blockquote> +<pre><code>// disable the datamap +SET carbon.datamap.visible.dbName.tableName.dataMapName = false +// enable the datamap +SET carbon.datamap.visible.dbName.tableName.dataMapName = true +</code></pre> <h2> <a id="bloomfilter-datamap-introduction" class="anchor" href="#bloomfilter-datamap-introduction" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>BloomFilter DataMap Introduction</h2> <p>A Bloom filter is a space-efficient probabilistic data structure that is used to test whether an element is a member of a set. -Carbondata introduce BloomFilter as an index datamap to enhance the performance of querying with precise value. +Carbondata introduced BloomFilter as an index datamap to enhance the performance of querying with precise value. It is well suitable for queries that do precise match on high cardinality columns(such as Name/ID). Internally, CarbonData maintains a BloomFilter per blocklet for each index column to indicate that whether a value of the column is in this blocklet. -Just like the other datamaps, BloomFilter datamap is managed ablong with main tables by CarbonData. +Just like the other datamaps, BloomFilter datamap is managed along with main tables by CarbonData. User can create BloomFilter datamap on specified columns with specified BloomFilter configurations such as size and probability.</p> <p>For instance, main table called <strong>datamap_test</strong> which is defined as:</p> <pre><code>CREATE TABLE datamap_test ( @@ -250,19 +242,19 @@ DMPROPERTIES ('INDEX_COLUMNS' = 'name,id', 'BLOOM_SIZE'='640000', 'BLOOM_FPP'='0 <td>INDEX_COLUMNS</td> <td>YES</td> <td></td> -<td>Carbondata will generate BloomFilter index on these columns. Queries on there columns are usually like 'COL = VAL'.</td> +<td>Carbondata will generate BloomFilter index on these columns. Queries on these columns are usually like 'COL = VAL'.</td> </tr> <tr> <td>BLOOM_SIZE</td> <td>NO</td> -<td>32000</td> -<td>This value is internally used by BloomFilter as the number of expected insertions, it will affects the size of BloomFilter index. Since each blocklet has a BloomFilter here, so the value is the approximate records in a blocklet. In another word, the value 32000 * #noOfPagesInBlocklet. The value should be an integer.</td> +<td>640000</td> +<td>This value is internally used by BloomFilter as the number of expected insertions, it will affect the size of BloomFilter index. Since each blocklet has a BloomFilter here, so the default value is the approximate distinct index values in a blocklet assuming that each blocklet contains 20 pages and each page contains 32000 records. The value should be an integer.</td> </tr> <tr> <td>BLOOM_FPP</td> <td>NO</td> -<td>0.01</td> -<td>This value is internally used by BloomFilter as the False-Positive Probability, it will affects the size of bloomfilter index as well as the number of hash functions for the BloomFilter. The value should be in range (0, 1).</td> +<td>0.00001</td> +<td>This value is internally used by BloomFilter as the False-Positive Probability, it will affect the size of bloomfilter index as well as the number of hash functions for the BloomFilter. The value should be in the range (0, 1). In one test scenario, a 96GB TPCH customer table with bloom_size=320000 and bloom_fpp=0.00001 will result in 18 false positive samples.</td> </tr> <tr> <td>BLOOM_COMPRESS</td> @@ -280,14 +272,39 @@ These index files will be written inside a folder named with datamap name inside each segment folders.</p> <h2> <a id="querying-data" class="anchor" href="#querying-data" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>Querying Data</h2> -<p>A system level configuration <code>carbon.query.datamap.bloom.cache.size</code> can used to enhance query performance with BloomFilter datamap by providing a cache for the bloomfilter index files. -The default value is <code>512</code> and its unit is <code>MB</code>. Internally the cache will be expired after it's idle for 2 hours.</p> <p>User can verify whether a query can leverage BloomFilter datamap by executing <code>EXPLAIN</code> command, which will show the transformed logical plan, and thus user can check whether the BloomFilter datamap can skip blocklets during the scan. If the datamap does not prune blocklets well, you can try to increase the value of property <code>BLOOM_SIZE</code> and decrease the value of property <code>BLOOM_FPP</code>.</p> <h2> <a id="data-management-with-bloomfilter-datamap" class="anchor" href="#data-management-with-bloomfilter-datamap" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>Data Management With BloomFilter DataMap</h2> -<p>Data management with BloomFilter datamap has no difference with that on Lucene datamap. You can refer to the corresponding section in <code>CarbonData BloomFilter DataMap</code>.</p> +<p>Data management with BloomFilter datamap has no difference with that on Lucene datamap. +You can refer to the corresponding section in <code>CarbonData Lucene DataMap</code>.</p> +<h2> +<a id="useful-tips" class="anchor" href="#useful-tips" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>Useful Tips</h2> +<ul> +<li>BloomFilter DataMap is suggested to be created on the high cardinality columns. +Query conditions on these columns are always simple <code>equal</code> or <code>in</code>, +such as 'col1=XX', 'col1 in (XX, YY)'.</li> +<li>We can create multiple BloomFilter datamaps on one table, +but we do recommend you to create one BloomFilter datamap that contains multiple index columns, +because the data loading and query performance will be better.</li> +<li> +<code>BLOOM_FPP</code> is only the expected number from user, the actually FPP may be worse. +If the BloomFilter datamap does not work well, +you can try to increase <code>BLOOM_SIZE</code> and decrease <code>BLOOM_FPP</code> at the same time. +Notice that bigger <code>BLOOM_SIZE</code> will increase the size of index file +and smaller <code>BLOOM_FPP</code> will increase runtime calculation while performing query.</li> +<li>'0' skipped blocklets of BloomFilter datamap in explain output indicates that +BloomFilter datamap does not prune better than Main datamap. +(For example since the data is not ordered, a specific value may be contained in many blocklets. In this case, bloom may not work better than Main DataMap.) +If this occurs very often, it means that current BloomFilter is useless. You can disable or drop it. +Sometimes we cannot see any pruning result about BloomFilter datamap in the explain output, +this indicates that the previous datamap has pruned all the blocklets and there is no need to continue pruning.</li> +<li>In some scenarios, the BloomFilter datamap may not enhance the query performance significantly +but if it can reduce the number of spark task, +there is still a chance that BloomFilter datamap can enhance the performance for concurrent query.</li> +<li>Note that BloomFilter datamap will decrease the data loading performance and may cause slightly storage expansion (for datamap index file).</li> +</ul> </div> </div> </div>
http://git-wip-us.apache.org/repos/asf/carbondata-site/blob/14d670df/src/main/webapp/configuration-parameters.html ---------------------------------------------------------------------- diff --git a/src/main/webapp/configuration-parameters.html b/src/main/webapp/configuration-parameters.html index 2768b0e..4f4f1cd 100644 --- a/src/main/webapp/configuration-parameters.html +++ b/src/main/webapp/configuration-parameters.html @@ -51,6 +51,9 @@ aria-expanded="false"> Download <span class="caret"></span></a> <ul class="dropdown-menu"> <li> + <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.1/"; + target="_blank">Apache CarbonData 1.4.1</a></li> + <li> <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.0/"; target="_blank">Apache CarbonData 1.4.0</a></li> <li> @@ -60,27 +63,6 @@ <a href="https://dist.apache.org/repos/dist/release/carbondata/1.3.0/"; target="_blank">Apache CarbonData 1.3.0</a></li> <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.2.0/"; - target="_blank">Apache CarbonData 1.2.0</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.1/"; - target="_blank">Apache CarbonData 1.1.1</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.0/"; - target="_blank">Apache CarbonData 1.1.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/1.0.0-incubating/"; - target="_blank">Apache CarbonData 1.0.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.2.0-incubating/"; - target="_blank">Apache CarbonData 0.2.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.1-incubating/"; - target="_blank">Apache CarbonData 0.1.1</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.0-incubating/"; - target="_blank">Apache CarbonData 0.1.0</a></li> - <li> <a href="https://cwiki.apache.org/confluence/display/CARBONDATA/Releases"; target="_blank">Release Archive</a></li> </ul> @@ -240,6 +222,16 @@ <td>48</td> <td>This property value indicates the number of hours the segment lock files will be preserved after dataload. These lock files will be deleted with the clean command after the configured number of hours.</td> </tr> +<tr> +<td>carbon.unsafe.working.memory.in.mb</td> +<td>512</td> +<td>Specifies the size of executor unsafe working memory. Used for sorting data, storing column pages,etc. This value is expressed in MB.</td> +</tr> +<tr> +<td>carbon.unsafe.driver.working.memory.in.mb</td> +<td>512</td> +<td>Specifies the size of driver unsafe working memory. Used for storing block or blocklet datamap cache. If not configured then carbon.unsafe.working.memory.in.mb value is considered. This value is expressed in MB.</td> +</tr> </tbody> </table> <h2> @@ -290,12 +282,36 @@ <td></td> </tr> <tr> +<td>carbon.insert.persist.enable</td> +<td>false</td> +<td>Enabling this parameter considers persistent data. If we are executing insert into query from source table using select statement & loading the same source table concurrently, when select happens on source table during the data load, it gets new record for which dictionary is not generated, so there will be inconsistency. To avoid this condition we can persist the dataframe into MEMORY_AND_DISK(default value) and perform insert into operation. By default this value will be false because no need to persist the dataframe in all cases. If user wants to run load and insert queries on source table concurrently then user can enable this parameter.</td> +<td></td> +</tr> +<tr> +<td>carbon.insert.storage.level</td> +<td>MEMORY_AND_DISK</td> +<td>Which storage level to persist dataframe when 'carbon.insert.persist.enable'=true, if user's executor has less memory, set this parameter to 'MEMORY_AND_DISK_SER' or other storage level to correspond to different environment. <a href="http://spark.apache.org/docs/latest/rdd-programming-guide.html#rdd-persistence"; rel="nofollow">See detail</a>.</td> +<td></td> +</tr> +<tr> <td>carbon.update.persist.enable</td> <td>true</td> <td>Enabling this parameter considers persistent data. Enabling this will reduce the execution time of UPDATE operation.</td> <td></td> </tr> <tr> +<td>carbon.update.storage.level</td> +<td>MEMORY_AND_DISK</td> +<td>Which storage level to persist dataframe when 'carbon.update.persist.enable'=true, if user's executor has less memory, set this parameter to 'MEMORY_AND_DISK_SER' or other storage level to correspond to different environment. <a href="http://spark.apache.org/docs/latest/rdd-programming-guide.html#rdd-persistence"; rel="nofollow">See detail</a>.</td> +<td></td> +</tr> +<tr> +<td>carbon.global.sort.rdd.storage.level</td> +<td>MEMORY_ONLY</td> +<td>Which storage level to persist rdd when loading data with 'sort_scope'='global_sort', if user's executor has less memory, set this parameter to 'MEMORY_AND_DISK_SER' or other storage level to correspond to different environment. <a href="http://spark.apache.org/docs/latest/rdd-programming-guide.html#rdd-persistence"; rel="nofollow">See detail</a>.</td> +<td></td> +</tr> +<tr> <td>carbon.load.global.sort.partitions</td> <td>0</td> <td>The Number of partitions to use when shuffling data for sort. If user don't configurate or configurate it less than 1, it uses the number of map tasks as reduce tasks. In general, we recommend 2-3 tasks per CPU core in your cluster.</td> @@ -344,6 +360,12 @@ <strong>block</strong>: Setting this value will launch one task per block. This setting is suggested in case of concurrent queries and queries having big shuffling scenarios. <strong>custom</strong>: Setting this value will group the blocks and distribute it uniformly to the available resources in the cluster. This enhances the query performance but not suggested in case of concurrent queries and queries having big shuffling scenarios. <strong>blocklet</strong>: Setting this value will launch one task per blocklet. This setting is suggested in case of concurrent queries and queries having big shuffling scenarios. <strong>merge_small_files</strong>: Setting this value will merge all the small partitions to a size of (128 MB is the default value of "spark.sql.files.maxPartitionBytes",it is configurable) during querying. The small partitions are combined to a map task to reduce the number of read task. This enhances the performance.</td> <td></td> </tr> +<tr> +<td>carbon.load.sortmemory.spill.percentage</td> +<td>0</td> +<td>If we use unsafe memory during data loading, this configuration will be used to control the behavior of spilling inmemory pages to disk. Internally in Carbondata, during sorting carbondata will sort data in pages and add them in unsafe memory. If the memory is insufficient, carbondata will spill the pages to disk and generate sort temp file. This configuration controls how many pages in memory will be spilled to disk based size. The size can be calculated by multiplying this configuration value with 'carbon.sort.storage.inmemory.size.inmb'. For example, default value 0 means that no pages in unsafe memory will be spilled and all the newly sorted data will be spilled to disk; Value 50 means that if the unsafe memory is insufficient, about half of pages in the unsafe memory will be spilled to disk while value 100 means that almost all pages in unsafe memory will be spilled. <strong>Note</strong>: This configuration only works for 'LOCAL_SORT' and 'BATCH_SORT' and the actual spilli ng behavior may slightly be different in each data loading.</td> +<td>Integer values between 0 and 100</td> +</tr> </tbody> </table> <ul> @@ -401,6 +423,12 @@ <td>This property specifies the parallelism for each segment during update. If there are segments that contain too many records to update and the spark job encounter data-spill related errors, it is better to increase this property value. It is recommended to set this value to a multiple of the number of executors for balance.</td> <td>Values between 1 to 1000.</td> </tr> +<tr> +<td>carbon.merge.index.in.segment</td> +<td>true</td> +<td>This property is used to merge all carbon index files (.carbonindex) inside a segment to a single carbon index merge file (.carbonindexmerge).</td> +<td>Values true or false</td> +</tr> </tbody> </table> <ul> @@ -475,6 +503,37 @@ <td>This configuration specifies the type of lock to be acquired during concurrent operations on table. There are following types of lock implementation: - LOCALLOCK: Lock is created on local file system as file. This lock is useful when only one spark driver (thrift server) runs on a machine and no other CarbonData spark application is launched concurrently. - HDFSLOCK: Lock is created on HDFS file system as file. This lock is useful when multiple CarbonData spark applications are launched and no ZooKeeper is running on cluster and HDFS supports file based locking.</td> </tr> <tr> +<td>carbon.lock.path</td> +<td>TABLEPATH</td> +<td>Locks on the files are used to prevent concurrent operation from modifying the same files. This</td> +</tr> +<tr> +<td>configuration specifies the path where lock files have to be created. Recommended to configure</td> +<td></td> +<td></td> +</tr> +<tr> +<td>HDFS lock path(to this property) in case of S3 file system as locking is not feasible on S3.</td> +<td></td> +<td></td> +</tr> +<tr> +<td> +<strong>Note:</strong> If this property is not set to HDFS location for S3 store, then there is a possibility</td> +<td></td> +<td></td> +</tr> +<tr> +<td>of data corruption because multiple data manipulation calls might try to update the status file</td> +<td></td> +<td></td> +</tr> +<tr> +<td>and as lock is not acquired before updation data might get overwritten.</td> +<td></td> +<td></td> +</tr> +<tr> <td>carbon.sort.intermediate.files.limit</td> <td>20</td> <td>Minimum number of intermediate files after which merged sort can be started (minValue = 2, maxValue=50).</td> @@ -594,7 +653,7 @@ <td>Specifies the minimum resource (executor) ratio needed for starting the block distribution. The default value is 0.8, which indicates 80% of the requested resource is allocated for starting block distribution. The minimum value is 0.1 min and the maximum value is 1.0.</td> </tr> <tr> -<td>carbon.search.enabled</td> +<td>carbon.search.enabled (Alpha Feature)</td> <td>false</td> <td>If set to true, it will use CarbonReader to do distributed scan directly instead of using compute framework like spark, thus avoiding limitation of compute framework like SQL optimizer and task scheduling overhead.</td> </tr> http://git-wip-us.apache.org/repos/asf/carbondata-site/blob/14d670df/src/main/webapp/data-management-on-carbondata.html ---------------------------------------------------------------------- diff --git a/src/main/webapp/data-management-on-carbondata.html b/src/main/webapp/data-management-on-carbondata.html index c81b02c..566bb8e 100644 --- a/src/main/webapp/data-management-on-carbondata.html +++ b/src/main/webapp/data-management-on-carbondata.html @@ -51,6 +51,9 @@ aria-expanded="false"> Download <span class="caret"></span></a> <ul class="dropdown-menu"> <li> + <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.1/"; + target="_blank">Apache CarbonData 1.4.1</a></li> + <li> <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.0/"; target="_blank">Apache CarbonData 1.4.0</a></li> <li> @@ -60,27 +63,6 @@ <a href="https://dist.apache.org/repos/dist/release/carbondata/1.3.0/"; target="_blank">Apache CarbonData 1.3.0</a></li> <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.2.0/"; - target="_blank">Apache CarbonData 1.2.0</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.1/"; - target="_blank">Apache CarbonData 1.1.1</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.0/"; - target="_blank">Apache CarbonData 1.1.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/1.0.0-incubating/"; - target="_blank">Apache CarbonData 1.0.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.2.0-incubating/"; - target="_blank">Apache CarbonData 0.2.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.1-incubating/"; - target="_blank">Apache CarbonData 0.1.1</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.0-incubating/"; - target="_blank">Apache CarbonData 0.1.0</a></li> - <li> <a href="https://cwiki.apache.org/confluence/display/CARBONDATA/Releases"; target="_blank">Release Archive</a></li> </ul> @@ -210,6 +192,7 @@ STORED AS carbondata Suggested use cases : do dictionary encoding for low cardinality columns, it might help to improve data compression ratio and performance.</p> <pre><code>TBLPROPERTIES ('DICTIONARY_INCLUDE'='column1, column2') </code></pre> +<p>NOTE: Dictionary Include/Exclude for complex child columns is not supported.</p> </li> <li> <p><strong>Inverted Index Configuration</strong></p> @@ -231,6 +214,7 @@ Suggested use cases : Only build MDK index for required columns,it might help to OR TBLPROPERTIES ('SORT_COLUMNS'='') </code></pre> +<p>NOTE: Sort_Columns for Complex datatype columns is not supported.</p> </li> <li> <p><strong>Sort Scope Configuration</strong></p> @@ -243,6 +227,24 @@ TBLPROPERTIES ('SORT_COLUMNS'='') And if you care about loading resources isolation strictly, because the system uses the spark GroupBy to sort data, the resource can be controlled by spark.</li> </ul> </li> +</ul> +<pre><code>### Example: +</code></pre> +<pre><code> CREATE TABLE IF NOT EXISTS productSchema.productSalesTable ( + productNumber INT, + productName STRING, + storeCity STRING, + storeProvince STRING, + productCategory STRING, + productBatch STRING, + saleQuantity INT, + revenue INT) + STORED BY 'carbondata' + TBLPROPERTIES ('SORT_COLUMNS'='productName,storeCity', + 'SORT_SCOPE'='NO_SORT') +</code></pre> +<p><strong>NOTE:</strong> CarbonData also supports "using carbondata". Find example code at <a href="https://github.com/apache/carbondata/blob/master/examples/spark2/src/main/scala/org/apache/carbondata/examples/SparkSessionExample.scala"; target=_blank>SparkSessionExample</a> in the CarbonData repo.</p> +<ul> <li> <p><strong>Table Block Size Configuration</strong></p> <p>This command is for setting block size of this table, the default value is 1024 MB and supports a range of 1 MB to 2048 MB.</p> @@ -274,23 +276,216 @@ Following are 5 configurations:</p> <pre><code>TBLPROPERTIES ('streaming'='true') </code></pre> </li> +<li> +<p><strong>Local Dictionary Configuration</strong></p> +</li> </ul> +<p>Columns for which dictionary is not generated needs more storage space and in turn more IO. Also since more data will have to be read during query, query performance also would suffer.Generating dictionary per blocklet for such columns would help in saving storage space and assist in improving query performance as carbondata is optimized for handling dictionary encoded columns more effectively.Generating dictionary internally per blocklet is termed as local dictionary. Please refer to <a href="../file-structure-of-carbondata.html">File structure of Carbondata</a> for understanding about the file structure of carbondata and meaning of terms like blocklet.</p> +<p>Local Dictionary helps in:</p> +<ol> +<li>Getting more compression.</li> +<li>Filter queries and full scan queries will be faster as filter will be done on encoded data.</li> +<li>Reducing the store size and memory footprint as only unique values will be stored as part of local dictionary and corresponding data will be stored as encoded data.</li> +<li>Getting higher IO throughput.</li> +</ol> +<p><strong>NOTE:</strong></p> +<ul> +<li> +<p>Following Data Types are Supported for Local Dictionary:</p> +<ul> +<li>STRING</li> +<li>VARCHAR</li> +<li>CHAR</li> +</ul> +</li> +<li> +<p>Following Data Types are not Supported for Local Dictionary:</p> +<ul> +<li>SMALLINT</li> +<li>INTEGER</li> +<li>BIGINT</li> +<li>DOUBLE</li> +<li>DECIMAL</li> +<li>TIMESTAMP</li> +<li>DATE</li> +<li>BOOLEAN</li> +</ul> +</li> +<li> +<p>In case of multi-level complex dataType columns, primitive string/varchar/char columns are considered for local dictionary generation.</p> +</li> +</ul> +<p>Local dictionary will have to be enabled explicitly during create table or by enabling the system property 'carbon.local.dictionary.enable'. By default, Local Dictionary will be disabled for the carbondata table.</p> +<p>Local Dictionary can be configured using the following properties during create table command:</p> +<table> +<thead> +<tr> +<th>Properties</th> +<th>Default value</th> +<th>Description</th> +</tr> +</thead> +<tbody> +<tr> +<td>LOCAL_DICTIONARY_ENABLE</td> +<td>false</td> +<td>Whether to enable local dictionary generation. <strong>NOTE:</strong> If this property is defined, it will override the value configured at system level by 'carbon.local.dictionary.enable'</td> +</tr> +<tr> +<td>LOCAL_DICTIONARY_THRESHOLD</td> +<td>10000</td> +<td>The maximum cardinality of a column upto which carbondata can try to generate local dictionary (maximum - 100000)</td> +</tr> +<tr> +<td>LOCAL_DICTIONARY_INCLUDE</td> +<td>string/varchar/char columns</td> +<td>Columns for which Local Dictionary has to be generated.<strong>NOTE:</strong> Those string/varchar/char columns which are added into DICTIONARY_INCLUDE option will not be considered for local dictionary generation.</td> +</tr> +<tr> +<td>LOCAL_DICTIONARY_EXCLUDE</td> +<td>none</td> +<td>Columns for which Local Dictionary need not be generated.</td> +</tr> +</tbody> +</table> +<p><strong>Fallback behavior:</strong></p> +<ul> +<li>When the cardinality of a column exceeds the threshold, it triggers a fallback and the generated dictionary will be reverted and data loading will be continued without dictionary encoding.</li> +</ul> +<p><strong>NOTE:</strong> When fallback is triggered, the data loading performance will decrease as encoded data will be discarded and the actual data is written to the temporary sort files.</p> +<p><strong>Points to be noted:</strong></p> +<ol> +<li> +<p>Reduce Block size:</p> +<p>Number of Blocks generated is less in case of Local Dictionary as compression ratio is high. This may reduce the number of tasks launched during query, resulting in degradation of query performance if the pruned blocks are less compared to the number of parallel tasks which can be run. So it is recommended to configure smaller block size which in turn generates more number of blocks.</p> +</li> +<li> +<p>All the page-level data for a blocklet needs to be maintained in memory until all the pages encoded for local dictionary is processed in order to handle fallback. Hence the memory required for local dictionary based table is more and this memory increase is proportional to number of columns.</p> +</li> +</ol> <h3> <a id="example" class="anchor" href="#example" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>Example:</h3> -<pre><code> CREATE TABLE IF NOT EXISTS productSchema.productSalesTable ( - productNumber INT, - productName STRING, - storeCity STRING, - storeProvince STRING, - productCategory STRING, - productBatch STRING, - saleQuantity INT, - revenue INT) - STORED BY 'carbondata' - TBLPROPERTIES ('SORT_COLUMNS'='productName,storeCity', - 'SORT_SCOPE'='NO_SORT') +<pre><code>CREATE TABLE carbontable( + + column1 string, + + column2 string, + + column3 LONG ) + + STORED BY 'carbondata' + TBLPROPERTIES('LOCAL_DICTIONARY_ENABLE'='true','LOCAL_DICTIONARY_THRESHOLD'='1000', + 'LOCAL_DICTIONARY_INCLUDE'='column1','LOCAL_DICTIONARY_EXCLUDE'='column2') +</code></pre> +<p><strong>NOTE:</strong></p> +<ul> +<li>We recommend to use Local Dictionary when cardinality is high but is distributed across multiple loads</li> +<li>On a large cluster, decoding data can become a bottleneck for global dictionary as there will be many remote reads. In this scenario, it is better to use Local Dictionary.</li> +<li>When cardinality is less, but loads are repetitive, it is better to use global dictionary as local dictionary generates multiple dictionary files at blocklet level increasing redundancy.</li> +</ul> +<ul> +<li> +<p><strong>Caching Min/Max Value for Required Columns</strong> +By default, CarbonData caches min and max values of all the columns in schema. As the load increases, the memory required to hold the min and max values increases considerably. This feature enables you to configure min and max values only for the required columns, resulting in optimized memory usage.</p> +<p>Following are the valid values for COLUMN_META_CACHE:</p> +<ul> +<li>If you want no column min/max values to be cached in the driver.</li> +</ul> +<pre><code>COLUMN_META_CACHE=?? +</code></pre> +<ul> +<li>If you want only col1 min/max values to be cached in the driver.</li> +</ul> +<pre><code>COLUMN_META_CACHE=?col1? +</code></pre> +<ul> +<li>If you want min/max values to be cached in driver for all the specified columns.</li> +</ul> +<pre><code>COLUMN_META_CACHE=?col1,col2,col3,?? +</code></pre> +<p>Columns to be cached can be specified either while creating table or after creation of the table. +During create table operation; specify the columns to be cached in table properties.</p> +<p>Syntax:</p> +<pre><code>CREATE TABLE [dbName].tableName (col1 String, col2 String, col3 int,?) STORED BY ?carbondata? TBLPROPERTIES (?COLUMN_META_CACHE?=?col1,col2,??) +</code></pre> +<p>Example:</p> +<pre><code>CREATE TABLE employee (name String, city String, id int) STORED BY ?carbondata? TBLPROPERTIES (?COLUMN_META_CACHE?=?name?) +</code></pre> +<p>After creation of table or on already created tables use the alter table command to configure the columns to be cached.</p> +<p>Syntax:</p> +<pre><code>ALTER TABLE [dbName].tableName SET TBLPROPERTIES (?COLUMN_META_CACHE?=?col1,col2,??) +</code></pre> +<p>Example:</p> +<pre><code>ALTER TABLE employee SET TBLPROPERTIES (?COLUMN_META_CACHE?=?city?) +</code></pre> +</li> +<li> +<p><strong>Caching at Block or Blocklet Level</strong></p> +<p>This feature allows you to maintain the cache at Block level, resulting in optimized usage of the memory. The memory consumption is high if the Blocklet level caching is maintained as a Block can have multiple Blocklet.</p> +<p>Following are the valid values for CACHE_LEVEL:</p> +<p><em>Configuration for caching in driver at Block level (default value).</em></p> +<pre><code>CACHE_LEVEL= ?BLOCK? +</code></pre> +<p><em>Configuration for caching in driver at Blocklet level.</em></p> +<pre><code>CACHE_LEVEL= ?BLOCKLET? +</code></pre> +<p>Cache level can be specified either while creating table or after creation of the table. +During create table operation specify the cache level in table properties.</p> +<p>Syntax:</p> +<pre><code>CREATE TABLE [dbName].tableName (col1 String, col2 String, col3 int,?) STORED BY ?carbondata? TBLPROPERTIES (?CACHE_LEVEL?=?Blocklet?) +</code></pre> +<p>Example:</p> +<pre><code>CREATE TABLE employee (name String, city String, id int) STORED BY ?carbondata? TBLPROPERTIES (?CACHE_LEVEL?=?Blocklet?) +</code></pre> +<p>After creation of table or on already created tables use the alter table command to configure the cache level.</p> +<p>Syntax:</p> +<pre><code>ALTER TABLE [dbName].tableName SET TBLPROPERTIES (?CACHE_LEVEL?=?Blocklet?) +</code></pre> +<p>Example:</p> +<pre><code>ALTER TABLE employee SET TBLPROPERTIES (?CACHE_LEVEL?=?Blocklet?) +</code></pre> +</li> +</ul> +<pre><code>- **Support Flat folder same as Hive/Parquet** + + This feature allows all carbondata and index files to keep directy under tablepath. Currently all carbondata/carbonindex files written under tablepath/Fact/Part0/Segment_NUM folder and it is not same as hive/parquet folder structure. This feature makes all files written will be directly under tablepath, it does not maintain any segment folder structure.This is useful for interoperability between the execution engines and plugin with other execution engines like hive or presto becomes easier. + + Following table property enables this feature and default value is false. + ``` + 'flat_folder'='true' + ``` + Example: + ``` + CREATE TABLE employee (name String, city String, id int) STORED BY ?carbondata? TBLPROPERTIES ('flat_folder'='true') + ``` + +- **String longer than 32000 characters** + + In common scenarios, the length of string is less than 32000, + so carbondata stores the length of content using Short to reduce memory and space consumption. + To support string longer than 32000 characters, carbondata introduces a table property called `LONG_STRING_COLUMNS`. + For these columns, carbondata internally stores the length of content using Integer. + + You can specify the columns as 'long string column' using below tblProperties: + + ``` + // specify col1, col2 as long string columns + TBLPROPERTIES ('LONG_STRING_COLUMNS'='col1,col2') + ``` + + Besides, you can also use this property through DataFrame by + ``` + df.format("carbondata") + .option("tableName", "carbonTable") + .option("long_string_columns", "col1, col2") + .save() + ``` + + If you are using Carbon-SDK, you can specify the datatype of long string column as `varchar`. + You can refer to SDKwriterTestCase for example. + + **NOTE:** The LONG_STRING_COLUMNS can only be string/char/varchar columns and cannot be dictionary_include/sort_columns/complex columns. </code></pre> -<p><strong>NOTE:</strong> CarbonData also supports "using carbondata". Find example code at <a href="https://github.com/apache/carbondata/blob/master/examples/spark2/src/main/scala/org/apache/carbondata/examples/SparkSessionExample.scala"; target=_blank>SparkSessionExample</a> in the CarbonData repo.</p> <h2> <a id="create-table-as-select" class="anchor" href="#create-table-as-select" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>CREATE TABLE AS SELECT</h2> <p>This function allows user to create a Carbon table from any of the Parquet/Hive/Carbon table. This is beneficial when the user wants to create Carbon table from any other Parquet/Hive table and use the Carbon query engine to query and achieve better query results for cases where Carbon is faster than other file formats. Also this feature can be used for backing up the data.</p> @@ -357,8 +552,15 @@ s"""CREATE EXTERNAL TABLE sdkOutputTable STORED BY 'carbondata' LOCATION </code></pre> <p>Here writer path will have carbondata and index files. This can be SDK output. Refer <a href="https://github.com/apache/carbondata/blob/master/docs/sdk-writer-guide.html"; target=_blank>SDK Writer Guide</a>.</p> -<p><strong>Note:</strong> -Dropping of the external table should not delete the files present in the location.</p> +<p><strong>Note:</strong></p> +<ol> +<li>Dropping of the external table should not delete the files present in the location.</li> +<li>When external table is created on non-transactional table data, +external table will be registered with the schema of carbondata files. +If multiple files with different schema is present, exception will be thrown. +So, If table registered with one schema and files are of different schema, +suggest to drop the external table and create again to register table with new schema.</li> +</ol> <h2> <a id="create-database" class="anchor" href="#create-database" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>CREATE DATABASE</h2> <p>This function creates a new database. By default the database is created in Carbon store location, but you can also specify custom location.</p> @@ -409,7 +611,13 @@ TBLPROPERTIES('DICTIONARY_INCLUDE'='col_name,...', </code></pre> <pre><code>ALTER TABLE carbon ADD COLUMNS (a1 INT, b1 STRING) TBLPROPERTIES('DEFAULT.VALUE.a1'='10') </code></pre> +<p>NOTE: Add Complex datatype columns is not supported.</p> </li> +</ul> +<p>Users can specify which columns to include and exclude for local dictionary generation after adding new columns. These will be appended with the already existing local dictionary include and exclude columns of main table respectively.</p> +<pre><code> ALTER TABLE carbon ADD COLUMNS (a1 STRING, b1 STRING) TBLPROPERTIES('LOCAL_DICTIONARY_INCLUDE'='a1','LOCAL_DICTIONARY_EXCLUDE'='b1') +</code></pre> +<ul> <li> <p><strong>DROP COLUMNS</strong></p> <p>This command is used to delete the existing column(s) in a table.</p> @@ -422,6 +630,7 @@ ALTER TABLE test_db.carbon DROP COLUMNS (b1) ALTER TABLE carbon DROP COLUMNS (c1,d1) </code></pre> +<p>NOTE: Drop Complex child column is not supported.</p> </li> <li> <p><strong>CHANGE DATA TYPE</strong></p> @@ -443,6 +652,34 @@ Change of decimal data type from lower precision to higher precision will only b <pre><code>ALTER TABLE test_db.carbon CHANGE a1 a1 DECIMAL(18,2) </code></pre> </li> +<li> +<p><strong>MERGE INDEX</strong></p> +<p>This command is used to merge all the CarbonData index files (.carbonindex) inside a segment to a single CarbonData index merge file (.carbonindexmerge). This enhances the first query performance.</p> +<pre><code> ALTER TABLE [db_name.]table_name COMPACT 'SEGMENT_INDEX' + ``` + + Examples: + ``` + ALTER TABLE test_db.carbon COMPACT 'SEGMENT_INDEX' + ``` + **NOTE:** + * Merge index is not supported on streaming table. + +</code></pre> +</li> +<li> +<p><strong>SET and UNSET for Local Dictionary Properties</strong></p> +<p>When set command is used, all the newly set properties will override the corresponding old properties if exists.</p> +<p>Example to SET Local Dictionary Properties:</p> +<pre><code>ALTER TABLE tablename SET TBLPROPERTIES('LOCAL_DICTIONARY_ENABLE'='false','LOCAL_DICTIONARY_THRESHOLD'='1000','LOCAL_DICTIONARY_INCLUDE'='column1','LOCAL_DICTIONARY_EXCLUDE'='column2') +</code></pre> +<p>When Local Dictionary properties are unset, corresponding default values will be used for these properties.</p> +<p>Example to UNSET Local Dictionary Properties:</p> +<pre><code>ALTER TABLE tablename UNSET TBLPROPERTIES('LOCAL_DICTIONARY_ENABLE','LOCAL_DICTIONARY_THRESHOLD','LOCAL_DICTIONARY_INCLUDE','LOCAL_DICTIONARY_EXCLUDE') +</code></pre> +<p><strong>NOTE:</strong> For old tables, by default, local dictionary is disabled. If user wants local dictionary for these tables, user can enable/disable local dictionary for new data at their discretion. +This can be achieved by using the alter table set command.</p> +</li> </ul> <h3> <a id="drop-table" class="anchor" href="#drop-table" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>DROP TABLE</h3> @@ -631,13 +868,30 @@ projectjoindate,projectenddate,attendance,utilization,salary', <li>If the FORCE option is used, then it auto-converts the data by storing the bad records as NULL before Loading data.</li> <li>If the IGNORE option is used, then bad records are neither loaded nor written to the separate CSV file.</li> <li>In loaded data, if all records are bad records, the BAD_RECORDS_ACTION is invalid and the load operation fails.</li> -<li>The maximum number of characters per column is 32000. If there are more than 32000 characters in a column, data loading will fail.</li> +<li>The default maximum number of characters per column is 32000. If there are more than 32000 characters in a column, please refer to <em>String longer than 32000 characters</em> section.</li> +<li>Since Bad Records Path can be specified in create, load and carbon properties. +Therefore, value specified in load will have the highest priority, and value specified in carbon properties will have the least priority.</li> </ul> +<p><strong>Bad Records Path:</strong></p> +<p>This property is used to specify the location where bad records would be written.</p> +<pre><code>TBLPROPERTIES('BAD_RECORDS_PATH'='/opt/badrecords'') +</code></pre> <p>Example:</p> <pre><code>LOAD DATA INPATH 'filepath.csv' INTO TABLE tablename OPTIONS('BAD_RECORDS_LOGGER_ENABLE'='true','BAD_RECORD_PATH'='hdfs://hacluster/tmp/carbon', 'BAD_RECORDS_ACTION'='REDIRECT','IS_EMPTY_DATA_BAD_RECORD'='false') </code></pre> +<ul> +<li> +<strong>GLOBAL_SORT_PARTITIONS:</strong> If the SORT_SCOPE is defined as GLOBAL_SORT, then user can specify the number of partitions to use while shuffling data for sort using GLOBAL_SORT_PARTITIONS. If it is not configured, or configured less than 1, then it uses the number of map task as reduce task. It is recommended that each reduce task deal with 512MB-1GB data.</li> +</ul> +<pre><code>OPTIONS('GLOBAL_SORT_PARTITIONS'='2') +</code></pre> +<p>NOTE:</p> +<ul> +<li>GLOBAL_SORT_PARTITIONS should be Integer type, the range is [1,Integer.MaxValue].</li> +<li>It is only used when the SORT_SCOPE is GLOBAL_SORT.</li> +</ul> <h3> <a id="insert-data-into-carbondata-table" class="anchor" href="#insert-data-into-carbondata-table" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>INSERT DATA INTO CARBONDATA TABLE</h3> <p>This command inserts data into a CarbonData table, it is defined as a combination of two queries Insert and Select query respectively. @@ -694,6 +948,7 @@ SET (column_name1, column_name2) =(select sourceColumn1, sourceColumn2 from sour </code></pre> <pre><code>UPDATE t3 SET (t3_country, t3_salary) = (SELECT t5_country, t5_salary FROM t5 FULL JOIN t3 u WHERE u.t3_id = t5_id and t5_id=6) WHERE t3_id >6 </code></pre> +<p>NOTE: Update Complex datatype columns is not supported.</p> <h3> <a id="delete" class="anchor" href="#delete" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>DELETE</h3> <p>This command allows us to delete records from CarbonData table.</p> @@ -743,6 +998,7 @@ All specified segment ids should exist and be valid, otherwise compaction will f Custom compaction is usually done during the off-peak time.</p> <pre><code>ALTER TABLE table_name COMPACT 'CUSTOM' WHERE SEGMENT.ID IN (2,3,4) </code></pre> +<p>NOTE: Compaction is unsupported for table containing Complex columns.</p> <ul> <li><strong>CLEAN SEGMENTS AFTER Compaction</strong></li> </ul> @@ -775,6 +1031,7 @@ Custom compaction is usually done during the off-peak time.</p> PARTITIONED BY (productCategory STRING, productBatch STRING) STORED BY 'carbondata' </code></pre> +<p>NOTE: Hive partition is not supported on complex datatype columns.</p> <h4> <a id="load-data-using-static-partition" class="anchor" href="#load-data-using-static-partition" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>Load Data Using Static Partition</h4> <p>This command allows you to load data using static partition.</p> http://git-wip-us.apache.org/repos/asf/carbondata-site/blob/14d670df/src/main/webapp/datamap-developer-guide.html ---------------------------------------------------------------------- diff --git a/src/main/webapp/datamap-developer-guide.html b/src/main/webapp/datamap-developer-guide.html index 367fcb7..9ec7a91 100644 --- a/src/main/webapp/datamap-developer-guide.html +++ b/src/main/webapp/datamap-developer-guide.html @@ -51,6 +51,9 @@ aria-expanded="false"> Download <span class="caret"></span></a> <ul class="dropdown-menu"> <li> + <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.1/"; + target="_blank">Apache CarbonData 1.4.1</a></li> + <li> <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.0/"; target="_blank">Apache CarbonData 1.4.0</a></li> <li> @@ -60,27 +63,6 @@ <a href="https://dist.apache.org/repos/dist/release/carbondata/1.3.0/"; target="_blank">Apache CarbonData 1.3.0</a></li> <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.2.0/"; - target="_blank">Apache CarbonData 1.2.0</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.1/"; - target="_blank">Apache CarbonData 1.1.1</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.0/"; - target="_blank">Apache CarbonData 1.1.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/1.0.0-incubating/"; - target="_blank">Apache CarbonData 1.0.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.2.0-incubating/"; - target="_blank">Apache CarbonData 0.2.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.1-incubating/"; - target="_blank">Apache CarbonData 0.1.1</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.0-incubating/"; - target="_blank">Apache CarbonData 0.1.0</a></li> - <li> <a href="https://cwiki.apache.org/confluence/display/CARBONDATA/Releases"; target="_blank">Release Archive</a></li> </ul> http://git-wip-us.apache.org/repos/asf/carbondata-site/blob/14d670df/src/main/webapp/datamap-management.html ---------------------------------------------------------------------- diff --git a/src/main/webapp/datamap-management.html b/src/main/webapp/datamap-management.html new file mode 100644 index 0000000..50191af --- /dev/null +++ b/src/main/webapp/datamap-management.html @@ -0,0 +1,311 @@ +<!DOCTYPE html> +<html lang="en"> +<head> + <meta charset="utf-8"> + <meta http-equiv="X-UA-Compatible" content="IE=edge"> + <meta name="viewport" content="width=device-width, initial-scale=1"> + <link href='images/favicon.ico' rel='shortcut icon' type='image/x-icon'> + <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags --> + <title>CarbonData</title> + <style> + + </style> + <!-- Bootstrap --> + + <link rel="stylesheet" href="css/bootstrap.min.css"> + <link href="css/style.css" rel="stylesheet"> + <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries --> + <!-- WARNING: Respond.js doesn't work if you view the page via file:// --> + <!--[if lt IE 9]> + <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js";></script> + <script src="https://oss.maxcdn.scom/respond/1.4.2/respond.min.js";></script> + <![endif]--> + <script src="js/jquery.min.js"></script> + <script src="js/bootstrap.min.js"></script> + + +</head> +<body> +<header> + <nav class="navbar navbar-default navbar-custom cd-navbar-wrapper"> + <div class="container"> + <div class="navbar-header"> + <button aria-controls="navbar" aria-expanded="false" data-target="#navbar" data-toggle="collapse" + class="navbar-toggle collapsed" type="button"> + <span class="sr-only">Toggle navigation</span> + <span class="icon-bar"></span> + <span class="icon-bar"></span> + <span class="icon-bar"></span> + </button> + <a href="index.html" class="logo"> + <img src="images/CarbonDataLogo.png" alt="CarbonData logo" title="CarbocnData logo"/> + </a> + </div> + <div class="navbar-collapse collapse cd_navcontnt" id="navbar"> + <ul class="nav navbar-nav navbar-right navlist-custom"> + <li><a href="index.html" class="hidden-xs"><i class="fa fa-home" aria-hidden="true"></i> </a> + </li> + <li><a href="index.html" class="hidden-lg hidden-md hidden-sm">Home</a></li> + <li class="dropdown"> + <a href="#" class="dropdown-toggle " data-toggle="dropdown" role="button" aria-haspopup="true" + aria-expanded="false"> Download <span class="caret"></span></a> + <ul class="dropdown-menu"> + <li> + <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.1/"; + target="_blank">Apache CarbonData 1.4.1</a></li> + <li> + <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.0/"; + target="_blank">Apache CarbonData 1.4.0</a></li> + <li> + <a href="https://dist.apache.org/repos/dist/release/carbondata/1.3.1/"; + target="_blank">Apache CarbonData 1.3.1</a></li> + <li> + <a href="https://dist.apache.org/repos/dist/release/carbondata/1.3.0/"; + target="_blank">Apache CarbonData 1.3.0</a></li> + <li> + <a href="https://cwiki.apache.org/confluence/display/CARBONDATA/Releases"; + target="_blank">Release Archive</a></li> + </ul> + </li> + <li><a href="mainpage.html" class="active">Documentation</a></li> + <li class="dropdown"> + <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" + aria-expanded="false">Community <span class="caret"></span></a> + <ul class="dropdown-menu"> + <li> + <a href="https://github.com/apache/carbondata/blob/master/docs/How-to-contribute-to-Apache-CarbonData.md"; + target="_blank">Contributing to CarbonData</a></li> + <li> + <a href="https://github.com/apache/carbondata/blob/master/docs/release-guide.md"; + target="_blank">Release Guide</a></li> + <li> + <a href="https://cwiki.apache.org/confluence/display/CARBONDATA/PMC+and+Committers+member+list"; + target="_blank">Project PMC and Committers</a></li> + <li> + <a href="https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=66850609"; + target="_blank">CarbonData Meetups</a></li> + <li><a href="security.html">Apache CarbonData Security</a></li> + <li><a href="https://issues.apache.org/jira/browse/CARBONDATA"; target="_blank">Apache + Jira</a></li> + <li><a href="videogallery.html">CarbonData Videos </a></li> + </ul> + </li> + <li class="dropdown"> + <a href="http://www.apache.org/"; class="apache_link hidden-xs dropdown-toggle" + data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Apache</a> + <ul class="dropdown-menu"> + <li><a href="http://www.apache.org/"; target="_blank">Apache Homepage</a></li> + <li><a href="http://www.apache.org/licenses/"; target="_blank">License</a></li> + <li><a href="http://www.apache.org/foundation/sponsorship.html"; + target="_blank">Sponsorship</a></li> + <li><a href="http://www.apache.org/foundation/thanks.html"; target="_blank">Thanks</a></li> + </ul> + </li> + + <li class="dropdown"> + <a href="http://www.apache.org/"; class="hidden-lg hidden-md hidden-sm dropdown-toggle" + data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Apache</a> + <ul class="dropdown-menu"> + <li><a href="http://www.apache.org/"; target="_blank">Apache Homepage</a></li> + <li><a href="http://www.apache.org/licenses/"; target="_blank">License</a></li> + <li><a href="http://www.apache.org/foundation/sponsorship.html"; + target="_blank">Sponsorship</a></li> + <li><a href="http://www.apache.org/foundation/thanks.html"; target="_blank">Thanks</a></li> + </ul> + </li> + + <li> + <a href="#" id="search-icon"><i class="fa fa-search" aria-hidden="true"></i></a> + + </li> + + </ul> + </div><!--/.nav-collapse --> + <div id="search-box"> + <form method="get" action="http://www.google.com/search"; target="_blank"> + <div class="search-block"> + <table border="0" cellpadding="0" width="100%"> + <tr> + <td style="width:80%"> + <input type="text" name="q" size=" 5" maxlength="255" value="" + class="search-input" placeholder="Search...." required/> + </td> + <td style="width:20%"> + <input type="submit" value="Search"/></td> + </tr> + <tr> + <td align="left" style="font-size:75%" colspan="2"> + <input type="checkbox" name="sitesearch" value="carbondata.apache.org" checked/> + <span style=" position: relative; top: -3px;"> Only search for CarbonData</span> + </td> + </tr> + </table> + </div> + </form> + </div> + </div> + </nav> +</header> <!-- end Header part --> + +<div class="fixed-padding"></div> <!-- top padding with fixde header --> + +<section><!-- Dashboard nav --> + <div class="container-fluid q"> + <div class="col-sm-12 col-md-12 maindashboard"> + <div class="row"> + <section> + <div style="padding:10px 15px;"> + <div id="viewpage" name="viewpage"> + <div class="row"> + <div class="col-sm-12 col-md-12"> + <div> +<h1> +<a id="carbondata-datamap-management" class="anchor" href="#carbondata-datamap-management" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>CarbonData DataMap Management</h1> +<h2> +<a id="overview" class="anchor" href="#overview" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>Overview</h2> +<p>DataMap can be created using following DDL</p> +<pre><code> CREATE DATAMAP [IF NOT EXISTS] datamap_name + [ON TABLE main_table] + USING "datamap_provider" + [WITH DEFERRED REBUILD] + DMPROPERTIES ('key'='value', ...) + AS + SELECT statement +</code></pre> +<p>Currently, there are 5 DataMap implementations in CarbonData.</p> +<table> +<thead> +<tr> +<th>DataMap Provider</th> +<th>Description</th> +<th>DMPROPERTIES</th> +<th>Management</th> +</tr> +</thead> +<tbody> +<tr> +<td>preaggregate</td> +<td>single table pre-aggregate table</td> +<td>No DMPROPERTY is required</td> +<td>Automatic</td> +</tr> +<tr> +<td>timeseries</td> +<td>time dimension rollup table</td> +<td>event_time, xx_granularity, please refer to <a href="https://github.com/apache/carbondata/blob/master/docs/datamap/timeseries-datamap-guide.html"; target=_blank>Timeseries DataMap</a> +</td> +<td>Automatic</td> +</tr> +<tr> +<td>mv</td> +<td>multi-table pre-aggregate table</td> +<td>No DMPROPERTY is required</td> +<td>Manual</td> +</tr> +<tr> +<td>lucene</td> +<td>lucene indexing for text column</td> +<td>index_columns to specifying the index columns</td> +<td>Automatic</td> +</tr> +<tr> +<td>bloomfilter</td> +<td>bloom filter for high cardinality column, geospatial column</td> +<td>index_columns to specifying the index columns</td> +<td>Automatic</td> +</tr> +</tbody> +</table> +<h2> +<a id="datamap-management" class="anchor" href="#datamap-management" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>DataMap Management</h2> +<p>There are two kinds of management semantic for DataMap.</p> +<ol> +<li>Automatic Refresh: Create datamap without <code>WITH DEFERRED REBUILD</code> in the statement, which is by default.</li> +<li>Manual Refresh: Create datamap with <code>WITH DEFERRED REBUILD</code> in the statement</li> +</ol> +<p><strong>CAUTION:</strong> +Manual refresh currently only works fine for MV, it has some bugs with other types of datamap in Carbondata 1.4.1, so we block this option for them in this version. +If user create MV datamap without specifying <code>WITH DEFERRED REBUILD</code>, carbondata will give a warning and treat the datamap as deferred rebuild.</p> +<h3> +<a id="automatic-refresh" class="anchor" href="#automatic-refresh" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>Automatic Refresh</h3> +<p>When user creates a datamap on the main table without using <code>WITH DEFERRED REBUILD</code> syntax, the datamap will be managed by system automatically. +For every data load to the main table, system will immediately triger a load to the datamap automatically. These two data loading (to main table and datamap) is executed in a transactional manner, meaning that it will be either both success or neither success.</p> +<p>The data loading to datamap is incremental based on Segment concept, avoiding a expesive total rebuild.</p> +<p>If user perform following command on the main table, system will return failure. (reject the operation)</p> +<ol> +<li>Data management command: <code>UPDATE/DELETE/DELETE SEGMENT</code>.</li> +<li>Schema management command: <code>ALTER TABLE DROP COLUMN</code>, <code>ALTER TABLE CHANGE DATATYPE</code>, +<code>ALTER TABLE RENAME</code>. Note that adding a new column is supported, and for dropping columns and +change datatype command, CarbonData will check whether it will impact the pre-aggregate table, if +not, the operation is allowed, otherwise operation will be rejected by throwing exception.</li> +<li>Partition management command: `ALTER TABLE ADD/DROP PARTITION</li> +</ol> +<p>If user do want to perform above operations on the main table, user can first drop the datamap, perform the operation, and re-create the datamap again.</p> +<p>If user drop the main table, the datamap will be dropped immediately too.</p> +<p>We do recommend you to use this management for index datamap.</p> +<h3> +<a id="manual-refresh" class="anchor" href="#manual-refresh" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>Manual Refresh</h3> +<p>When user creates a datamap specifying maunal refresh semantic, the datamap is created with status <em>disabled</em> and query will NOT use this datamap until user can issue REBUILD DATAMAP command to build the datamap. For every REBUILD DATAMAP command, system will trigger a full rebuild of the datamap. After rebuild is done, system will change datamap status to <em>enabled</em>, so that it can be used in query rewrite.</p> +<p>For every new data loading, data update, delete, the related datamap will be made <em>disabled</em>, +which means that the following queries will not benefit from the datamap before it becomes <em>enabled</em> again.</p> +<p>If the main table is dropped by user, the related datamap will be dropped immediately.</p> +<p><strong>Note</strong>:</p> +<ul> +<li>If you are creating a datamap on external table, you need to do manual management of the datamap.</li> +<li>For index datamap such as BloomFilter datamap, there is no need to do manual refresh. +By default it is automatic refresh, +which means its data will get refreshed immediately after the datamap is created or the main table is loaded. +Manual refresh on this datamap will has no impact.</li> +</ul> +<h2> +<a id="datamap-catalog" class="anchor" href="#datamap-catalog" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>DataMap Catalog</h2> +<p>Currently, when user creates a datamap, system will store the datamap metadata in a configurable <em>system</em> folder in HDFS or S3.</p> +<p>In this <em>system</em> folder, it contains:</p> +<ul> +<li>DataMapSchema file. It is a json file containing schema for one datamap. Ses DataMapSchema class. If user creates 100 datamaps (on different tables), there will be 100 files in <em>system</em> folder.</li> +<li>DataMapStatus file. Only one file, it is in json format, and each entry in the file represents for one datamap. Ses DataMapStatusDetail class</li> +</ul> +<p>There is a DataMapCatalog interface to retrieve schema of all datamap, it can be used in optimizer to get the metadata of datamap.</p> +<h2> +<a id="datamap-related-commands" class="anchor" href="#datamap-related-commands" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>DataMap Related Commands</h2> +<h3> +<a id="explain" class="anchor" href="#explain" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>Explain</h3> +<p>How can user know whether datamap is used in the query?</p> +<p>User can use EXPLAIN command to know, it will print out something like</p> +<pre lang="text"><code>== CarbonData Profiler == +Hit mv DataMap: datamap1 +Scan Table: default.datamap1_table ++- filter: ++- pruning by CG DataMap ++- all blocklets: 1 + skipped blocklets: 0 +</code></pre> +<h3> +<a id="show-datamap" class="anchor" href="#show-datamap" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>Show DataMap</h3> +<p>There is a SHOW DATAMAPS command, when this is issued, system will read all datamap from <em>system</em> folder and print all information on screen. The current information includes:</p> +<ul> +<li>DataMapName</li> +<li>DataMapProviderName like mv, preaggreagte, timeseries, etc</li> +<li>Associated Table</li> +</ul> +<h3> +<a id="compaction-on-datamap" class="anchor" href="#compaction-on-datamap" aria-hidden="true"><span aria-hidden="true" class="octicon octicon-link"></span></a>Compaction on DataMap</h3> +<p>This feature applies for preaggregate datamap only</p> +<p>Running Compaction command (<code>ALTER TABLE COMPACT</code>) on main table will <strong>not automatically</strong> compact the pre-aggregate tables created on the main table. User need to run Compaction command separately on each pre-aggregate table to compact them.</p> +<p>Compaction is an optional operation for pre-aggregate table. If compaction is performed on main table but not performed on pre-aggregate table, all queries still can benefit from pre-aggregate tables. To further improve the query performance, compaction on pre-aggregate tables can be triggered to merge the segments and files in the pre-aggregate tables.</p> +</div> +</div> +</div> +</div> +<div class="doc-footer"> + <a href="#top" class="scroll-top">Top</a> +</div> +</div> +</section> +</div> +</div> +</div> +</section><!-- End systemblock part --> +<script src="js/custom.js"></script> +</body> +</html> \ No newline at end of file http://git-wip-us.apache.org/repos/asf/carbondata-site/blob/14d670df/src/main/webapp/faq.html ---------------------------------------------------------------------- diff --git a/src/main/webapp/faq.html b/src/main/webapp/faq.html index 5d43ff1..cf84d34 100644 --- a/src/main/webapp/faq.html +++ b/src/main/webapp/faq.html @@ -51,6 +51,9 @@ aria-expanded="false"> Download <span class="caret"></span></a> <ul class="dropdown-menu"> <li> + <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.1/"; + target="_blank">Apache CarbonData 1.4.1</a></li> + <li> <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.0/"; target="_blank">Apache CarbonData 1.4.0</a></li> <li> @@ -60,27 +63,6 @@ <a href="https://dist.apache.org/repos/dist/release/carbondata/1.3.0/"; target="_blank">Apache CarbonData 1.3.0</a></li> <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.2.0/"; - target="_blank">Apache CarbonData 1.2.0</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.1/"; - target="_blank">Apache CarbonData 1.1.1</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.0/"; - target="_blank">Apache CarbonData 1.1.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/1.0.0-incubating/"; - target="_blank">Apache CarbonData 1.0.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.2.0-incubating/"; - target="_blank">Apache CarbonData 0.2.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.1-incubating/"; - target="_blank">Apache CarbonData 0.1.1</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.0-incubating/"; - target="_blank">Apache CarbonData 0.1.0</a></li> - <li> <a href="https://cwiki.apache.org/confluence/display/CARBONDATA/Releases"; target="_blank">Release Archive</a></li> </ul> http://git-wip-us.apache.org/repos/asf/carbondata-site/blob/14d670df/src/main/webapp/file-structure-of-carbondata.html ---------------------------------------------------------------------- diff --git a/src/main/webapp/file-structure-of-carbondata.html b/src/main/webapp/file-structure-of-carbondata.html index dc1e239..edebccf 100644 --- a/src/main/webapp/file-structure-of-carbondata.html +++ b/src/main/webapp/file-structure-of-carbondata.html @@ -51,6 +51,9 @@ aria-expanded="false"> Download <span class="caret"></span></a> <ul class="dropdown-menu"> <li> + <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.1/"; + target="_blank">Apache CarbonData 1.4.1</a></li> + <li> <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.0/"; target="_blank">Apache CarbonData 1.4.0</a></li> <li> @@ -60,27 +63,6 @@ <a href="https://dist.apache.org/repos/dist/release/carbondata/1.3.0/"; target="_blank">Apache CarbonData 1.3.0</a></li> <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.2.0/"; - target="_blank">Apache CarbonData 1.2.0</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.1/"; - target="_blank">Apache CarbonData 1.1.1</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.0/"; - target="_blank">Apache CarbonData 1.1.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/1.0.0-incubating/"; - target="_blank">Apache CarbonData 1.0.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.2.0-incubating/"; - target="_blank">Apache CarbonData 0.2.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.1-incubating/"; - target="_blank">Apache CarbonData 0.1.1</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.0-incubating/"; - target="_blank">Apache CarbonData 0.1.0</a></li> - <li> <a href="https://cwiki.apache.org/confluence/display/CARBONDATA/Releases"; target="_blank">Release Archive</a></li> </ul> http://git-wip-us.apache.org/repos/asf/carbondata-site/blob/14d670df/src/main/webapp/index.html ---------------------------------------------------------------------- diff --git a/src/main/webapp/index.html b/src/main/webapp/index.html index 3fe3ba4..e4e0c0e 100644 --- a/src/main/webapp/index.html +++ b/src/main/webapp/index.html @@ -54,6 +54,9 @@ class="caret"></span></a> <ul class="dropdown-menu"> <li> + <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.1/"; + target="_blank">Apache CarbonData 1.4.1</a></li> + <li> <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.0/"; target="_blank">Apache CarbonData 1.4.0</a></li> <li> @@ -63,27 +66,6 @@ <a href="https://dist.apache.org/repos/dist/release/carbondata/1.3.0/"; target="_blank">Apache CarbonData 1.3.0</a></li> <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.2.0/"; - target="_blank">Apache CarbonData 1.2.0</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.1/"; - target="_blank">Apache CarbonData 1.1.1</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.0/"; - target="_blank">Apache CarbonData 1.1.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/1.0.0-incubating/"; - target="_blank">Apache CarbonData 1.0.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.2.0-incubating/"; - target="_blank">Apache CarbonData 0.2.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.1-incubating/"; - target="_blank">Apache CarbonData 0.1.1</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.0-incubating/"; - target="_blank">Apache CarbonData 0.1.0</a></li> - <li> <a href="https://cwiki.apache.org/confluence/display/CARBONDATA/Releases"; target="_blank">Release Archive</a></li> </ul> @@ -328,6 +310,13 @@ </h4> <div class="linkblock"> <div class="block-row"> + <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.1/"; + target="_blank">Apache CarbonData 1.4.1</a> + <span class="release-date">Aug 2018</span> + <a href="https://cwiki.apache.org/confluence/display/CARBONDATA/Apache+CarbonData+1.4.1+Release"; + class="whatsnew" target="_blank">what's new</a> + </div> + <div class="block-row"> <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.0/"; target="_blank">Apache CarbonData 1.4.0</a> <span class="release-date">May 2018</span> @@ -348,21 +337,6 @@ <a href="https://cwiki.apache.org/confluence/display/CARBONDATA/Apache+CarbonData+1.3.0+Release"; class="whatsnew" target="_blank">what's new</a> </div> - <div class="block-row"> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.2.0/"; - target="_blank">Apache CarbonData 1.2.0</a> - <span class="release-date">Sept 2017</span> - <a href="https://cwiki.apache.org/confluence/display/CARBONDATA/Apache+CarbonData+1.2.0+Release"; - class="whatsnew" target="_blank">what's new</a> - </div> - <div class="block-row"> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.1/"; - target="_blank">Apache CarbonData 1.1.1</a> - <span class="release-date">July 2017</span> - <a href="https://cwiki.apache.org/confluence/display/CARBONDATA/Apache+CarbonData+1.1.1+Release"; - class="whatsnew" target="_blank">what's new</a> - </div> - </div> </div> <div class="nextR"> <h4 class="title">Release Notes @@ -389,10 +363,6 @@ class="fa fa-github icon-margin-r" aria-hidden="true"></i> CarbonData Github </a> - <a href="pdf/CarbonData Documentation.pdf" class="quickstart-btn" - target="_blank"><i class="fa fa-file-pdf-o icon-margin-r" - aria-hidden="true"></i></i> Download Documentation - </a> <a href="pdf/CarbonData-TPCH-Report.pdf" class="quickstart-btn" target="_blank"><i class="fa fa-file-pdf-o icon-margin-r" aria-hidden="true"></i></i> CarbonData TPCH Report @@ -498,7 +468,7 @@ to do is:</p> <ol class="orderlist"> <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.3.1/"; + <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.1/"; target="_blank">Download</a>the latest release. </li> @@ -689,7 +659,7 @@ <div class="bottomcontant"> <div class="container-fluid"> <div class="col-md-8 col-sm-8"> - <p class="copyright-txt">Copyright © 2016-2017 Apache CarbonData. All rights reserved | + <p class="copyright-txt">Copyright © 2017-2018 Apache CarbonData. All rights reserved | <a href="http://www.apache.org/"; class="term-links" target="_blank">Apache Software Foundation </a> | <a href="http://www.apache.org/foundation/policies/privacy.html"; http://git-wip-us.apache.org/repos/asf/carbondata-site/blob/14d670df/src/main/webapp/installation-guide.html ---------------------------------------------------------------------- diff --git a/src/main/webapp/installation-guide.html b/src/main/webapp/installation-guide.html index ffb750e..2e7fab6 100644 --- a/src/main/webapp/installation-guide.html +++ b/src/main/webapp/installation-guide.html @@ -51,6 +51,9 @@ aria-expanded="false"> Download <span class="caret"></span></a> <ul class="dropdown-menu"> <li> + <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.1/"; + target="_blank">Apache CarbonData 1.4.1</a></li> + <li> <a href="https://dist.apache.org/repos/dist/release/carbondata/1.4.0/"; target="_blank">Apache CarbonData 1.4.0</a></li> <li> @@ -60,27 +63,6 @@ <a href="https://dist.apache.org/repos/dist/release/carbondata/1.3.0/"; target="_blank">Apache CarbonData 1.3.0</a></li> <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.2.0/"; - target="_blank">Apache CarbonData 1.2.0</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.1/"; - target="_blank">Apache CarbonData 1.1.1</a></li> - <li> - <a href="https://dist.apache.org/repos/dist/release/carbondata/1.1.0/"; - target="_blank">Apache CarbonData 1.1.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/1.0.0-incubating/"; - target="_blank">Apache CarbonData 1.0.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.2.0-incubating/"; - target="_blank">Apache CarbonData 0.2.0</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.1-incubating/"; - target="_blank">Apache CarbonData 0.1.1</a></li> - <li> - <a href="http://archive.apache.org/dist/incubator/carbondata/0.1.0-incubating/"; - target="_blank">Apache CarbonData 0.1.0</a></li> - <li> <a href="https://cwiki.apache.org/confluence/display/CARBONDATA/Releases"; target="_blank">Release Archive</a></li> </ul>
