Author: tdsilva
Date: Thu Jul 30 01:20:22 2015
New Revision: 1693380
URL: http://svn.apache.org/r1693380
Log:
make changes to markdown files instead of html
Modified:
phoenix/phoenix-docs/src/docsrc/help/phoenix.csv
phoenix/site/publish/Phoenix-in-15-minutes-or-less.html
phoenix/site/publish/array_type.html
phoenix/site/publish/building.html
phoenix/site/publish/building_website.html
phoenix/site/publish/bulk_dataload.html
phoenix/site/publish/contributing.html
phoenix/site/publish/develop.html
phoenix/site/publish/download.html
phoenix/site/publish/dynamic_columns.html
phoenix/site/publish/faq.html
phoenix/site/publish/flume.html
phoenix/site/publish/index.html
phoenix/site/publish/installation.html
phoenix/site/publish/issues.html
phoenix/site/publish/joins.html
phoenix/site/publish/language/datatypes.html
phoenix/site/publish/language/functions.html
phoenix/site/publish/language/index.html
phoenix/site/publish/mailing_list.html
phoenix/site/publish/multi-tenancy.html
phoenix/site/publish/news.html
phoenix/site/publish/paged.html
phoenix/site/publish/performance.html
phoenix/site/publish/pherf.html
phoenix/site/publish/phoenix_mr.html
phoenix/site/publish/phoenix_on_emr.html
phoenix/site/publish/phoenix_spark.html
phoenix/site/publish/pig_integration.html
phoenix/site/publish/recent.html
phoenix/site/publish/release.html
phoenix/site/publish/release_notes.html
phoenix/site/publish/resources.html
phoenix/site/publish/roadmap.html
phoenix/site/publish/salted.html
phoenix/site/publish/secondary_indexing.html
phoenix/site/publish/sequences.html
phoenix/site/publish/server.html
phoenix/site/publish/skip_scan.html
phoenix/site/publish/source.html
phoenix/site/publish/subqueries.html
phoenix/site/publish/team.html
phoenix/site/publish/tracing.html
phoenix/site/publish/tuning.html
phoenix/site/publish/udf.html
phoenix/site/publish/update_statistics.html
phoenix/site/publish/upgrading.html
phoenix/site/publish/views.html
phoenix/site/publish/who_is_using.html
phoenix/site/source/src/site/markdown/dynamic_columns.md
phoenix/site/source/src/site/markdown/recent.md
phoenix/site/source/src/site/markdown/secondary_indexing.md
Modified: phoenix/phoenix-docs/src/docsrc/help/phoenix.csv
URL:
http://svn.apache.org/viewvc/phoenix/phoenix-docs/src/docsrc/help/phoenix.csv?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/phoenix-docs/src/docsrc/help/phoenix.csv (original)
+++ phoenix/phoenix-docs/src/docsrc/help/phoenix.csv Thu Jul 30 01:20:22 2015
@@ -68,7 +68,7 @@ Column families that exist in the HBase
At create time, to improve query performance, an empty key value is added to
the first column family of any existing rows or the default column family if no
column families are explicitly defined. Upserts will also add this empty key
value. This improves query performance by having a key value column we can
guarantee always being there and thus minimizing the amount of data that must
be projected and subsequently returned back to the client. HBase table and
column configuration options may be passed through as key/value pairs to
configure the HBase table as desired. Note that when using the IF NOT EXISTS
clause, if a table already exists, then no change will be made to it.
Additionally, no validation is done to check whether the existing table
metadata matches the proposed table metadata. so it's better to use DROP TABLE
followed by CREATE TABLE is the table metadata may be changing.
","
-CREATE TABLE my_schema.my_table ( id BIGINT not null primary key, date DATE
not null)
+CREATE TABLE my_schema.my_table ( id BIGINT not null primary key, date)
CREATE TABLE my_table ( id INTEGER not null primary key desc, date DATE not
null,
m.db_utilization DECIMAL, i.db_utilization)
m.DATA_BLOCK_ENCODING='DIFF'
@@ -202,6 +202,7 @@ ALTER TABLE my_table SET IMMUTABLE_ROWS=
CREATE INDEX [IF NOT EXISTS] indexName
ON tableRef ( expression [ASC | DESC] [,...] )
[ INCLUDE ( columnRef [,...] ) ]
+[ ASYNC ]
[indexOptions] [ SPLIT ON ( splitPoint [,...] ) ]
","
Creates a new secondary index on a table or view. The index will be
automatically kept in sync with the table as the data changes.
@@ -212,6 +213,7 @@ in the CREATE TABLE statement or afterwa
Otherwise, if this property is not set on the table, then incremental index
maintenance will be performed on the server side when
the data changes.
As of the 4.3 release, functional indexes are supported which allow arbitrary
expressions rather than solely column names to be indexed.
+As of the 4.4.0 release, you can specify the ASYNC keyword to create the index
using a map reduce job.
","
CREATE INDEX my_idx ON sales.opportunity(last_updated_date DESC)
CREATE INDEX my_idx ON log.event(created_date DESC) INCLUDE (name, payload)
SALT_BUCKETS=10
Modified: phoenix/site/publish/Phoenix-in-15-minutes-or-less.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/Phoenix-in-15-minutes-or-less.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/Phoenix-in-15-minutes-or-less.html (original)
+++ phoenix/site/publish/Phoenix-in-15-minutes-or-less.html Thu Jul 30 01:20:22
2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/array_type.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/array_type.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/array_type.html (original)
+++ phoenix/site/publish/array_type.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/building.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/building.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/building.html (original)
+++ phoenix/site/publish/building.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/building_website.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/building_website.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/building_website.html (original)
+++ phoenix/site/publish/building_website.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/bulk_dataload.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/bulk_dataload.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/bulk_dataload.html (original)
+++ phoenix/site/publish/bulk_dataload.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/contributing.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/contributing.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/contributing.html (original)
+++ phoenix/site/publish/contributing.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/develop.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/develop.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/develop.html (original)
+++ phoenix/site/publish/develop.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/download.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/download.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/download.html (original)
+++ phoenix/site/publish/download.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/dynamic_columns.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/dynamic_columns.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/dynamic_columns.html (original)
+++ phoenix/site/publish/dynamic_columns.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -155,17 +155,12 @@ WHERE eventType = 'OOM' AND lastGCTime &
<pre>CREATE TABLE EventLog (
eventId BIGINT NOT NULL,
eventTime TIME NOT NULL,
- eventType CHAR(3)
+ eventType CHAR(3)
CONSTRAINT pk PRIMARY KEY (eventId, eventTime))
</pre>
-</div>
+</div>
<p>To upsert a row with dynamic columns:</p>
-<div class="source">
- <pre>UPSERT INTO EventLog (eventId, eventTime, eventType, lastGCTime TIME,
usedMemory BIGINT, maxMemory BIGINT)
- VALUES(1, CURRENT_TIME(), 'abc', CURRENT_TIME(), 512, 1024);
-</pre>
-</div>
-
+<p>UPSERT INTO EventLog (eventId, eventTime, eventType, lastGCTime TIME,
usedMemory BIGINT, maxMemory BIGINT) VALUES(1, CURRENT_TIME(), âabcâ,
CURRENT_TIME(), 512, 1024);</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/faq.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/faq.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/faq.html (original)
+++ phoenix/site/publish/faq.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/flume.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/flume.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/flume.html (original)
+++ phoenix/site/publish/flume.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/index.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/index.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/index.html (original)
+++ phoenix/site/publish/index.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/installation.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/installation.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/installation.html (original)
+++ phoenix/site/publish/installation.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/issues.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/issues.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/issues.html (original)
+++ phoenix/site/publish/issues.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/joins.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/joins.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/joins.html (original)
+++ phoenix/site/publish/joins.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/language/datatypes.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/language/datatypes.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/language/datatypes.html (original)
+++ phoenix/site/publish/language/datatypes.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/language/functions.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/language/functions.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/language/functions.html (original)
+++ phoenix/site/publish/language/functions.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/language/index.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/language/index.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/language/index.html (original)
+++ phoenix/site/publish/language/index.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -570,7 +570,7 @@ syntax-end -->
<p>Creates a new table. The <code>HBase</code> table and any column families
referenced are created if they don't already exist. All table, column
family and column names are uppercased unless they are double quoted in which
case they are case sensitive. Column families that exist in the
<code>HBase</code> table but are not listed are ignored. At create time, to
improve query performance, an empty key value is added to the first column
family of any existing rows or the default column family if no column families
are explicitly defined. Upserts will also add this empty key value. This
improves query performance by having a key value column we can guarantee always
being there and thus minimizing the amount of data that must be projected and
subsequently returned back to the client. <code>HBase</code> table and column
configuration options may be passed through as key/value pairs to configure the
<code>HBase</code> table as desired. Note that when using the <code>IF NOT
EXISTS</co
de> clause, if a table already exists, then no change will be made to it.
Additionally, no validation is done to check whether the existing table
metadata matches the proposed table metadata. so it's better to use
<code>DROP TABLE</code> followed by <code>CREATE TABLE</code> is the table
metadata may be changing.</p>
<p>Example:</p>
<p class="notranslate">
-CREATE TABLE my_schema.my_table ( id BIGINT not null primary key, date
DATE)<br />CREATE TABLE my_table ( id INTEGER not null primary key desc, date
DATE,<br /> m.db_utilization DECIMAL,
i.db_utilization)<br
/> m.DATA_BLOCK_ENCODING='DIFF'<br />CREATE
TABLE stats.prod_metrics ( host char(50) not null, created_date date,<br
/> txn_count bigint CONSTRAINT pk PRIMARY KEY (host,
created_date) )<br />CREATE TABLE IF NOT EXISTS
"my_case_sensitive_table"<br /> (
"id" char(10) not null primary key, "value" integer)<br
/> DATA_BLOCK_ENCODING='NONE',VERSIONS=5,MAX_FILESIZE=2000000
split on (?, ?, ?)<br />CREATE TABLE IF NOT EXISTS my_schema.my_table (<br
/> org_id CHAR(15), entity_id CHAR(15), payload
binary(1000),<br /> CONSTRAINT pk PRIMARY KEY (org_id,
entity_id) )<br /> &nbs
p; TTL=86400</p>
+CREATE TABLE my_schema.my_table ( id BIGINT not null primary key, date)<br
/>CREATE TABLE my_table ( id INTEGER not null primary key desc, date DATE not
null,<br /> m.db_utilization DECIMAL,
i.db_utilization)<br
/> m.DATA_BLOCK_ENCODING='DIFF'<br />CREATE
TABLE stats.prod_metrics ( host char(50) not null, created_date date not
null,<br /> txn_count bigint CONSTRAINT pk PRIMARY KEY
(host, created_date) )<br />CREATE TABLE IF NOT EXISTS
"my_case_sensitive_table"<br /> (
"id" char(10) not null primary key, "value" integer)<br
/> DATA_BLOCK_ENCODING='NONE',VERSIONS=5,MAX_FILESIZE=2000000
split on (?, ?, ?)<br />CREATE TABLE IF NOT EXISTS my_schema.my_table (<br
/> org_id CHAR(15), entity_id CHAR(15), payload
binary(1000),<br /> CONSTRAINT pk PRIMARY KEY (org_id,
entity_id) )<br />&nb
sp; TTL=86400</p>
<h3 id="drop_table" class="notranslate">DROP TABLE</h3>
<!-- railroad-start -->
@@ -746,11 +746,11 @@ ALTER TABLE my_schema.my_table ADD d.dep
CREATE INDEX [IF NOT EXISTS] <a href="index.html#name">indexName</a>
ON <a href="index.html#table_ref">tableRef</a> ( <a
href="index.html#expression">expression</a> [ASC | DESC] [,...] )
[ INCLUDE ( <a href="index.html#column_ref">columnRef</a> [,...] ) ]
-[ASYNC]
+[ ASYNC ]
[<a href="index.html#options">indexOptions</a>] [ SPLIT ON ( <a
href="index.html#split_point">splitPoint</a> [,...] ) ]
</pre>
<div name="railroad">
-<table class="railroad"><tr class="railroad"><td class="d"><code
class="c">CREATE INDEX</code></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"> </td><td
class="te"></td></tr><tr class="railroad"><td class="ls"></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="d"><code
class="c">IF NOT EXISTS</code></td></tr></table></td><td
class="le"></td></tr></table></td><td class="d"><code class="c"><a
href="index.html#name">indexName</a></code></td></tr></table><br /><table
class="railroad"><tr class="railroad"><td class="d"><code class="c">ON <a
href="index.html#table_ref">tableRef</a> ( <a
href="index.html#expression">expression</a></code></td><td class="d"><table
class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td
class="ts"></td><td class="d"><code class="
c">ASC</code></td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">DESC</code></td><td
class="le"></td></tr></table></td><td class="le"></td></tr></table></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">, ...</code></td><td
class="le"></td></tr></table></td><td class="d"><code
class="c">)</code></td></tr></table><br /><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"> </td><td
class="te"></td></tr><tr class="railroad"><td class="ls"></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="d"><code
class="c">INCLUDE ( <a
href="index.html#column_ref">columnRef</a></code></td><td class="d"><table
class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td class="l
s"></td><td class="d"><code class="c">, ...</code></td><td
class="le"></td></tr></table></td><td class="d"><code
class="c">)</code></td></tr></table></td><td class="le"></td></tr></table><br
/><table class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">ASYNC</code></td><td
class="le"></td></tr></table></td></td></tr></table></td><td
class="le"></td></tr></table><br /><table class="railroad"><tr
class="railroad"><td class="d"><table class="railroad"><tr class="railroad"><td
class="ts"></td><td class="d"> </td><td class="te"></td></tr><tr
class="railroad"><td class="ls"></td><td class="d"><code class="c"><a
href="index.html#options">indexOptions</a></code></td><td
class="le"></td></tr></table></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"> </td><td
class="te"></td></tr><tr class="railroad"><td class="
ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td
class="d"><code class="c">SPLIT ON ( <a
href="index.html#split_point">splitPoint</a></code></td><td class="d"><table
class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">, ...</code></td><td
class="le"></td></tr></table></td><td class="d"><code
class="c">)</code></td></tr></table></td><td
class="le"></td></tr></table></td></tr></table>
+<table class="railroad"><tr class="railroad"><td class="d"><code
class="c">CREATE INDEX</code></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"> </td><td
class="te"></td></tr><tr class="railroad"><td class="ls"></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="d"><code
class="c">IF NOT EXISTS</code></td></tr></table></td><td
class="le"></td></tr></table></td><td class="d"><code class="c"><a
href="index.html#name">indexName</a></code></td></tr></table><br /><table
class="railroad"><tr class="railroad"><td class="d"><code class="c">ON <a
href="index.html#table_ref">tableRef</a> ( <a
href="index.html#expression">expression</a></code></td><td class="d"><table
class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td
class="ts"></td><td class="d"><code class="
c">ASC</code></td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">DESC</code></td><td
class="le"></td></tr></table></td><td class="le"></td></tr></table></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">, ...</code></td><td
class="le"></td></tr></table></td><td class="d"><code
class="c">)</code></td></tr></table><br /><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"> </td><td
class="te"></td></tr><tr class="railroad"><td class="ls"></td><td
class="d"><table class="railroad"><tr class="railroad"><td class="d"><code
class="c">INCLUDE ( <a
href="index.html#column_ref">columnRef</a></code></td><td class="d"><table
class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td class="l
s"></td><td class="d"><code class="c">, ...</code></td><td
class="le"></td></tr></table></td><td class="d"><code
class="c">)</code></td></tr></table></td><td class="le"></td></tr></table><br
/><table class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">ASYNC</code></td><td
class="le"></td></tr></table><br /><table class="railroad"><tr
class="railroad"><td class="d"><table class="railroad"><tr class="railroad"><td
class="ts"></td><td class="d"> </td><td class="te"></td></tr><tr
class="railroad"><td class="ls"></td><td class="d"><code class="c"><a
href="index.html#options">indexOptions</a></code></td><td
class="le"></td></tr></table></td><td class="d"><table class="railroad"><tr
class="railroad"><td class="ts"></td><td class="d"> </td><td
class="te"></td></tr><tr class="railroad"><td class="ls"></td><td
class="d"><table class="railroad"><tr class="rai
lroad"><td class="d"><code class="c">SPLIT ON ( <a
href="index.html#split_point">splitPoint</a></code></td><td class="d"><table
class="railroad"><tr class="railroad"><td class="ts"></td><td
class="d"> </td><td class="te"></td></tr><tr class="railroad"><td
class="ls"></td><td class="d"><code class="c">, ...</code></td><td
class="le"></td></tr></table></td><td class="d"><code
class="c">)</code></td></tr></table></td><td
class="le"></td></tr></table></td></tr></table>
</div>
<!-- railroad-end -->
<!-- syntax-start
@@ -758,10 +758,11 @@ ON <a href="index.html#table_ref">tableR
CREATE INDEX [IF NOT EXISTS] <a href="index.html#name">indexName</a>
ON <a href="index.html#table_ref">tableRef</a> ( <a
href="index.html#expression">expression</a> [ASC | DESC] [,...] )
[ INCLUDE ( <a href="index.html#column_ref">columnRef</a> [,...] ) ]
+[ ASYNC ]
[<a href="index.html#options">indexOptions</a>] [ SPLIT ON ( <a
href="index.html#split_point">splitPoint</a> [,...] ) ]
</pre>
syntax-end -->
-<p>Creates a new secondary index on a table or view. The index will be
automatically kept in sync with the table as the data changes. At query time,
the optimizer will use the index if it contains all columns referenced in the
query and produces the most efficient execution plan. If a table has rows that
are write-once and append-only, then the table may set the
<code>IMMUTABLE_ROWS</code> property to true (either up-front in the
<code>CREATE TABLE</code> statement or afterwards in an <code>ALTER
TABLE</code> statement). This reduces the overhead at write time to maintain
the index. Otherwise, if this property is not set on the table, then
incremental index maintenance will be performed on the server side when the
data changes. As of the 4.3 release, functional indexes are supported which
allow arbitrary expressions rather than solely column names to be indexed. As
of the 4.4.0 release, you can specify the <code>ASYNC</code> keyword to create
the index asynchronously.</p>
+<p>Creates a new secondary index on a table or view. The index will be
automatically kept in sync with the table as the data changes. At query time,
the optimizer will use the index if it contains all columns referenced in the
query and produces the most efficient execution plan. If a table has rows that
are write-once and append-only, then the table may set the
<code>IMMUTABLE_ROWS</code> property to true (either up-front in the
<code>CREATE TABLE</code> statement or afterwards in an <code>ALTER
TABLE</code> statement). This reduces the overhead at write time to maintain
the index. Otherwise, if this property is not set on the table, then
incremental index maintenance will be performed on the server side when the
data changes. As of the 4.3 release, functional indexes are supported which
allow arbitrary expressions rather than solely column names to be indexed. As
of the 4.4.0 release, you can specify the <code>ASYNC</code> keyword to create
the index using a map reduce job.</p>
<p>Example:</p>
<p class="notranslate">
CREATE INDEX my_idx ON sales.opportunity(last_updated_date DESC)<br />CREATE
INDEX my_idx ON log.event(created_date DESC) INCLUDE (name, payload)
SALT_BUCKETS=10<br />CREATE INDEX IF NOT EXISTS my_comp_idx ON server_metrics (
gc_time DESC, created_date DESC )<br
/> DATA_BLOCK_ENCODING='NONE',VERSIONS=?,MAX_FILESIZE=2000000
split on (?, ?, ?)<br />CREATE INDEX my_idx ON
sales.opportunity(UPPER(contact_name))</p>
Modified: phoenix/site/publish/mailing_list.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/mailing_list.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/mailing_list.html (original)
+++ phoenix/site/publish/mailing_list.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/multi-tenancy.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/multi-tenancy.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/multi-tenancy.html (original)
+++ phoenix/site/publish/multi-tenancy.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/news.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/news.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/news.html (original)
+++ phoenix/site/publish/news.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/paged.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/paged.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/paged.html (original)
+++ phoenix/site/publish/paged.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/performance.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/performance.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/performance.html (original)
+++ phoenix/site/publish/performance.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/pherf.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/pherf.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/pherf.html (original)
+++ phoenix/site/publish/pherf.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/phoenix_mr.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_mr.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_mr.html (original)
+++ phoenix/site/publish/phoenix_mr.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/phoenix_on_emr.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_on_emr.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_on_emr.html (original)
+++ phoenix/site/publish/phoenix_on_emr.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/phoenix_spark.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_spark.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_spark.html (original)
+++ phoenix/site/publish/phoenix_spark.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/pig_integration.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/pig_integration.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/pig_integration.html (original)
+++ phoenix/site/publish/pig_integration.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/recent.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/recent.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/recent.html (original)
+++ phoenix/site/publish/recent.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -144,8 +144,8 @@
</div>
<p>As items are implemented from our road map, they are moved here to track
the progress weâve made:</p>
<ol style="list-style-type: decimal">
- <li><b><a href="udf.html">User Defined Functions</a></b>. Allows users to
create and deploy their own custom or domain-specific user-defined functions to
the cluster. <b>Available in our 4.4 release</b></li>
- <li><b><a href="secondary_indexing.html#MR_Index_Build">Asynchronous Initial
Population</a></b>. Enables an index to be created asynchronously using a map
reduce job <b>Available in our 4.4 release</b></li>
+ <li><b><a href="udf.html">User Defined Functions</a></b>. Allows users to
create and deploy their own custom or domain-specific user-defined functions to
the cluster. <b>Available in our 4.4 release</b></li>
+ <li><b><a href="secondary_indexing.html#MR_Index_Build">Asynchronous Initial
Population.</a></b>. Enables an index to be created asynchronously using a map
reduce job <b>Available in our 4.4 release</b></li>
<li><b><a href="secondary_indexing.html#Functional_Indexes">Functional
Indexes</a></b>. Enables an index to be defined as expressions as opposed to
just column names and have the index be used when a query contains this
expression. <b>Available in our 4.3 release</b></li>
<li><b><a href="phoenix_mr.html">Map-reduce Integration</a></b>. Support
general map-reduce integration to Phoenix by implementing custom input and
output formats.</li>
<li><b><a href="update_statistics.html">Statistics Collection</a></b>.
Collects the statistics for a table to improve query parallelization.
<b>Available in our 3.2/4.2 release</b></li>
Modified: phoenix/site/publish/release.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/release.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/release.html (original)
+++ phoenix/site/publish/release.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/release_notes.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/release_notes.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/release_notes.html (original)
+++ phoenix/site/publish/release_notes.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-28
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/resources.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/resources.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/resources.html (original)
+++ phoenix/site/publish/resources.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/roadmap.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/roadmap.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/roadmap.html (original)
+++ phoenix/site/publish/roadmap.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/salted.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/salted.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/salted.html (original)
+++ phoenix/site/publish/salted.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/secondary_indexing.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/secondary_indexing.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/secondary_indexing.html (original)
+++ phoenix/site/publish/secondary_indexing.html Thu Jul 30 01:20:22 2015
@@ -169,15 +169,15 @@
<h2 id="Asynchronous_Index_Population">Asynchronous Index Population</h2>
<p>As of the 4.5.0 release it is possible to use a map reduce job to
initially populate an index asynchronously by including the ASYNC keyword in
the index creation DDL statement:</p>
<div class="source">
- <pre>CREATE INDEX async_index ON my_table (v) ASYNC;
+ <pre>CREATE INDEX async_index ON my_schema.my_table (v) ASYNC;
</pre>
</div>
<p>The map reduce job that populates the index table must be kicked off
separately through the HBase command line like this:</p>
<div class="source">
- <pre>${HBASE_HOME}/bin/hbase org.apache.phoenix.mapreduce.index.IndexTool
-dt MY_TABLE -it ASYNC_IDX -op ASYNC_IDX_HFILES
+ <pre>${HBASE_HOME}/bin/hbase org.apache.phoenix.mapreduce.index.IndexTool
--schema MY_SCHEMA --data-table MY_TABLE --index-table ASYNC_IDX --output-path
ASYNC_IDX_HFILES
</pre>
</div>
- <p>Only when the map reduce job is complete will the index be activated and
start to be used in queries.</p>
+ <p>Only when the map reduce job is complete will the index be activated and
start to be used in queries. The output-path option is used to specify a HDFS
directory that is used for writing HFiles to.</p>
</div>
<div class="section">
<h2 id="Examples">Examples</h2>
Modified: phoenix/site/publish/sequences.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/sequences.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/sequences.html (original)
+++ phoenix/site/publish/sequences.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/server.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/server.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/server.html (original)
+++ phoenix/site/publish/server.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/skip_scan.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/skip_scan.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/skip_scan.html (original)
+++ phoenix/site/publish/skip_scan.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/source.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/source.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/source.html (original)
+++ phoenix/site/publish/source.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/subqueries.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/subqueries.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/subqueries.html (original)
+++ phoenix/site/publish/subqueries.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/team.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/team.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/team.html (original)
+++ phoenix/site/publish/team.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/tracing.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/tracing.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/tracing.html (original)
+++ phoenix/site/publish/tracing.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/tuning.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/tuning.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/tuning.html (original)
+++ phoenix/site/publish/tuning.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/udf.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/udf.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/udf.html (original)
+++ phoenix/site/publish/udf.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/update_statistics.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/update_statistics.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/update_statistics.html (original)
+++ phoenix/site/publish/update_statistics.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/upgrading.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/upgrading.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/upgrading.html (original)
+++ phoenix/site/publish/upgrading.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/views.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/views.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/views.html (original)
+++ phoenix/site/publish/views.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/who_is_using.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/who_is_using.html?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/publish/who_is_using.html (original)
+++ phoenix/site/publish/who_is_using.html Thu Jul 30 01:20:22 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-07-27
+ Generated by Apache Maven Doxia at 2015-07-29
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/source/src/site/markdown/dynamic_columns.md
URL:
http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/dynamic_columns.md?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/dynamic_columns.md (original)
+++ phoenix/site/source/src/site/markdown/dynamic_columns.md Thu Jul 30
01:20:22 2015
@@ -13,5 +13,10 @@ Where you may have defined only a subset
CREATE TABLE EventLog (
eventId BIGINT NOT NULL,
eventTime TIME NOT NULL,
- eventType CHAR(3) NOT NULL
+ eventType CHAR(3)
CONSTRAINT pk PRIMARY KEY (eventId, eventTime))
+
+To upsert a row with dynamic columns:
+
+ UPSERT INTO EventLog (eventId, eventTime, eventType, lastGCTime TIME,
usedMemory BIGINT, maxMemory BIGINT)
+ VALUES(1, CURRENT_TIME(), 'abc', CURRENT_TIME(), 512, 1024);
Modified: phoenix/site/source/src/site/markdown/recent.md
URL:
http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/recent.md?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/recent.md (original)
+++ phoenix/site/source/src/site/markdown/recent.md Thu Jul 30 01:20:22 2015
@@ -3,6 +3,7 @@
As items are implemented from our road map, they are moved here to track the
progress we've made:
1. **[User Defined Functions](udf.html)**. Allows users to create and deploy
their own custom or domain-specific user-defined functions to the cluster.
**Available in our 4.4 release**
+2. **[Asynchronous Initial
Population.](secondary_indexing.html#MR_Index_Build)**. Enables an index to be
created asynchronously using a map reduce job **Available in our 4.4 release**
1. **[Functional Indexes](secondary_indexing.html#Functional_Indexes)**.
Enables an index to be defined as expressions as opposed to just column names
and have the index be used when a query contains this expression. **Available
in our 4.3 release**
2. **[Map-reduce Integration](phoenix_mr.html)**. Support general map-reduce
integration to Phoenix by implementing custom input and output formats.
1. **[Statistics Collection](update_statistics.html)**. Collects the
statistics for a table to improve query parallelization. **Available in our
3.2/4.2 release**
Modified: phoenix/site/source/src/site/markdown/secondary_indexing.md
URL:
http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/secondary_indexing.md?rev=1693380&r1=1693379&r2=1693380&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/secondary_indexing.md (original)
+++ phoenix/site/source/src/site/markdown/secondary_indexing.md Thu Jul 30
01:20:22 2015
@@ -33,13 +33,13 @@ All indexes on a table declared with <co
## Asynchronous Index Population
As of the 4.5.0 release it is possible to use a map reduce job to initially
populate an index asynchronously by including the ASYNC keyword in the index
creation DDL statement:
- CREATE INDEX async_index ON my_table (v) ASYNC;
+ CREATE INDEX async_index ON my_schema.my_table (v) ASYNC;
The map reduce job that populates the index table must be kicked off
separately through the HBase command line like this:
- ${HBASE_HOME}/bin/hbase org.apache.phoenix.mapreduce.index.IndexTool -dt
MY_TABLE -it ASYNC_IDX -op ASYNC_IDX_HFILES
+ ${HBASE_HOME}/bin/hbase org.apache.phoenix.mapreduce.index.IndexTool
--schema MY_SCHEMA --data-table MY_TABLE --index-table ASYNC_IDX --output-path
ASYNC_IDX_HFILES
-Only when the map reduce job is complete will the index be activated and start
to be used in queries.
+Only when the map reduce job is complete will the index be activated and start
to be used in queries. The output-path option is used to specify a HDFS
directory that is used for writing HFiles to.
## Examples
