Author: skadam
Date: Wed Jul 24 00:54:37 2019
New Revision: 1863671
URL: http://svn.apache.org/viewvc?rev=1863671&view=rev
Log:
PHOENIX-4918: Apache Phoenix website Grammar page is running on an old version
(Xinyi Yan)
Modified:
phoenix/phoenix-docs/src/docsrc/help/phoenix.csv
phoenix/site/publish/language/index.html
Modified: phoenix/phoenix-docs/src/docsrc/help/phoenix.csv
URL:
http://svn.apache.org/viewvc/phoenix/phoenix-docs/src/docsrc/help/phoenix.csv?rev=1863671&r1=1863670&r2=1863671&view=diff
==============================================================================
--- phoenix/phoenix-docs/src/docsrc/help/phoenix.csv (original)
+++ phoenix/phoenix-docs/src/docsrc/help/phoenix.csv Wed Jul 24 00:54:37 2019
@@ -119,7 +119,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)
+CREATE TABLE my_schema.my_table ( id BIGINT not null primary key, date 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'
Modified: phoenix/site/publish/language/index.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/language/index.html?rev=1863671&r1=1863670&r2=1863671&view=diff
==============================================================================
--- phoenix/site/publish/language/index.html (original)
+++ phoenix/site/publish/language/index.html Wed Jul 24 00:54:37 2019
@@ -714,7 +714,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)<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>
+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 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
/> TTL=86400</p>
<h3 id="drop_table" class="notranslate">DROP TABLE</h3>
<!-- railroad-start -->
