Author: richardantal
Date: Mon Apr 11 08:21:54 2022
New Revision: 1899733
URL: http://svn.apache.org/viewvc?rev=1899733&view=rev
Log:
Fix generated pages on the Website
Modified:
phoenix/site/publish/Phoenix-in-15-minutes-or-less.html
phoenix/site/publish/array_type.html
phoenix/site/publish/atomic_upsert.html
phoenix/site/publish/building.html
phoenix/site/publish/building_website.html
phoenix/site/publish/bulk_dataload.html
phoenix/site/publish/columnencoding.html
phoenix/site/publish/contributing.html
phoenix/site/publish/cursors.html
phoenix/site/publish/develop.html
phoenix/site/publish/download.html
phoenix/site/publish/dynamic_columns.html
phoenix/site/publish/explainplan.html
phoenix/site/publish/faq.html
phoenix/site/publish/flume.html
phoenix/site/publish/hive_storage_handler.html
phoenix/site/publish/index.html
phoenix/site/publish/installation.html
phoenix/site/publish/issues.html
phoenix/site/publish/joins.html
phoenix/site/publish/kafka.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/metrics.html
phoenix/site/publish/multi-tenancy.html
phoenix/site/publish/namspace_mapping.html
phoenix/site/publish/news.html
phoenix/site/publish/omid.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_orm.html
phoenix/site/publish/phoenix_python.html
phoenix/site/publish/phoenix_spark.html
phoenix/site/publish/phoenixcon.html
phoenix/site/publish/pig_integration.html
phoenix/site/publish/python.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/rowtimestamp.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/tablesample.html
phoenix/site/publish/team.html
phoenix/site/publish/tech_talks.html
phoenix/site/publish/tephra.html
phoenix/site/publish/tracing.html
phoenix/site/publish/transactions.html
phoenix/site/publish/tuning.html
phoenix/site/publish/tuning_guide.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
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=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/Phoenix-in-15-minutes-or-less.html (original)
+++ phoenix/site/publish/Phoenix-in-15-minutes-or-less.html Mon Apr 11 08:21:54
2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/array_type.html (original)
+++ phoenix/site/publish/array_type.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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/atomic_upsert.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/atomic_upsert.html?rev=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/atomic_upsert.html (original)
+++ phoenix/site/publish/atomic_upsert.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/building.html (original)
+++ phoenix/site/publish/building.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/building_website.html (original)
+++ phoenix/site/publish/building_website.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/bulk_dataload.html (original)
+++ phoenix/site/publish/bulk_dataload.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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/columnencoding.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/columnencoding.html?rev=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/columnencoding.html (original)
+++ phoenix/site/publish/columnencoding.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/contributing.html (original)
+++ phoenix/site/publish/contributing.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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/cursors.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/cursors.html?rev=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/cursors.html (original)
+++ phoenix/site/publish/cursors.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/develop.html (original)
+++ phoenix/site/publish/develop.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/download.html (original)
+++ phoenix/site/publish/download.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/dynamic_columns.html (original)
+++ phoenix/site/publish/dynamic_columns.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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/explainplan.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/explainplan.html?rev=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/explainplan.html (original)
+++ phoenix/site/publish/explainplan.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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/faq.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/faq.html?rev=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/faq.html (original)
+++ phoenix/site/publish/faq.html Mon Apr 11 08:21:54 2022
@@ -1,699 +0,0 @@
-
-<!DOCTYPE html>
-<!--
- Generated by Apache Maven Doxia at 2022-04-10
- Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
--->
-<html xml:lang="en" lang="en">
-
- <head>
- <meta charset="UTF-8" />
- <title>F.A.Q. | Apache Phoenix</title>
- <meta name="viewport" content="width=device-width,
initial-scale=1.0" />
- <meta name="description" content="" />
- <meta http-equiv="content-language" content="en" />
-
- <link
href="//netdna.bootstrapcdn.com/bootswatch/2.3.2/flatly/bootstrap.min.css"
rel="stylesheet" />
- <link
href="//netdna.bootstrapcdn.com/twitter-bootstrap/2.3.1/css/bootstrap-responsive.min.css"
rel="stylesheet" />
- <link href="./css/bootswatch.css" rel="stylesheet" />
- <link href="./css/reflow-skin.css" rel="stylesheet" />
-
- <link href="//yandex.st/highlightjs/7.5/styles/default.min.css"
rel="stylesheet" />
-
- <link href="./css/lightbox.css" rel="stylesheet" />
-
- <link href="./css/site.css" rel="stylesheet" />
- <link href="./css/print.css" rel="stylesheet" media="print" />
-
- <!-- Le HTML5 shim, for IE6-8 support of HTML5 elements -->
- <!--[if lt IE 9]>
- <script
src="http://html5shim.googlecode.com/svn/trunk/html5.js";></script>
- <![endif]-->
-
-
-
- </head>
-
- <body class="page-faq project-phoenix-site" data-spy="scroll"
data-offset="60" data-target="#toc-scroll-target">
-
- <div class="navbar navbar-fixed-top">
- <div class="navbar-inner">
- <div class="container">
- <a class="btn btn-navbar"
data-toggle="collapse" data-target="#top-nav-collapse">
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- </a>
- <a class="brand" href="index.html"><div
class="xtoplogo"></div></a>
- <div class="nav-collapse collapse"
id="top-nav-collapse">
- <ul class="nav pull-right">
- <li class="dropdown">
- <a href="#"
class="dropdown-toggle" data-toggle="dropdown">About <b class="caret"></b></a>
- <ul
class="dropdown-menu">
- <li ><a
href="index.html" title="Overview">Overview</a></li>
- <li ><a
href="who_is_using.html" title="Who is Using">Who is Using</a></li>
- <li ><a
href="recent.html" title="Recent Improvements">Recent Improvements</a></li>
- <li ><a
href="roadmap.html" title="Roadmap">Roadmap</a></li>
- <li ><a
href="news.html" title="News">News</a></li>
- <li ><a
href="performance.html" title="Performance">Performance</a></li>
- <li ><a
href="team.html" title="Team">Team</a></li>
- <li ><a
href="tech_talks.html" title="Tech Talks">Tech Talks</a></li>
- <li ><a
href="resources.html" title="Presentations">Presentations</a></li>
- <li ><a
href="mailing_list.html" title="Mailing Lists">Mailing Lists</a></li>
- <li ><a
href="source.html" title="Source Repository">Source Repository</a></li>
- <li ><a
href="issues.html" title="Issue Tracking">Issue Tracking</a></li>
- <li ><a
href="download.html" title="Download">Download</a></li>
- <li ><a
href="installation.html" title="Installation">Installation</a></li>
- <li
class="divider"/>
- <li ><a
href="contributing.html" title="How to Contribute">How to Contribute</a></li>
- <li ><a
href="develop.html" title="How to Develop">How to Develop</a></li>
- <li ><a
href="building_website.html" title="How to Update Website">How to Update
Website</a></li>
- <li ><a
href="release.html" title="How to Release">How to Release</a></li>
- <li
class="divider"/>
- <li ><a
href="http://www.apache.org/licenses/"; title="License"
class="externalLink">License</a></li>
- </ul>
- </li>
- <li class="dropdown">
- <a href="#"
class="dropdown-toggle" data-toggle="dropdown">Using <b class="caret"></b></a>
- <ul
class="dropdown-menu">
- <li
class="active"><a href="" title="F.A.Q.">F.A.Q.</a></li>
- <li ><a
href="Phoenix-in-15-minutes-or-less.html" title="Quick Start">Quick
Start</a></li>
- <li ><a
href="building.html" title="Building">Building</a></li>
- <li ><a
href="tuning_guide.html" title="Tuning">Tuning</a></li>
- <li ><a
href="explainplan.html" title="Explain Plan">Explain Plan</a></li>
- <li ><a
href="tuning.html" title="Configuration">Configuration</a></li>
- <li ><a
href="upgrading.html" title="Backward Compatibility">Backward
Compatibility</a></li>
- <li ><a
href="release_notes.html" title="Release Notes">Release Notes</a></li>
- <li ><a
href="pherf.html" title="Performance Testing">Performance Testing</a></li>
- <li
class="divider"/>
- <li ><a
href="phoenix_spark.html" title="Apache Spark Integration">Apache Spark
Integration</a></li>
- <li ><a
href="hive_storage_handler.html" title="Phoenix Storage Handler for Apache
Hive">Phoenix Storage Handler for Apache Hive</a></li>
- <li ><a
href="pig_integration.html" title="Apache Pig Integration">Apache Pig
Integration</a></li>
- <li ><a
href="phoenix_mr.html" title="Map Reduce Integration">Map Reduce
Integration</a></li>
- <li ><a
href="flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a></li>
- <li ><a
href="kafka.html" title="Apache Kafka Plugin">Apache Kafka Plugin</a></li>
- <li ><a
href="python.html" title="Python Driver">Python Driver</a></li>
- </ul>
- </li>
- <li class="dropdown">
- <a href="#"
class="dropdown-toggle" data-toggle="dropdown">Addons <b class="caret"></b></a>
- <ul
class="dropdown-menu">
- <li ><a
href="http://docs.aws.amazon.com/ElasticMapReduce/latest/ReleaseGuide/emr-phoenix.html";
title="Phoenix on Amazon EMR" class="externalLink">Phoenix on Amazon
EMR</a></li>
- <li ><a
href="http://python-phoenixdb.readthedocs.io/en/latest"; title="Phoenix Adapter
for Python" class="externalLink">Phoenix Adapter for Python</a></li>
- <li ><a
href="phoenix_orm.html" title="Phoenix ORM Library">Phoenix ORM Library</a></li>
- <li ><a
href="https://trino.io/docs/current/connector/phoenix.html"; title="Phoenix
Connector for Trino" class="externalLink">Phoenix Connector for Trino</a></li>
- <li ><a
href="omid.html" title="Apache Phoenix Omid Transaction Manager">Apache Phoenix
Omid Transaction Manager</a></li>
- <li ><a
href="tephra.html" title="Apache Phoenix Tephra Transaction Manager">Apache
Phoenix Tephra Transaction Manager</a></li>
- </ul>
- </li>
- <li class="dropdown">
- <a href="#"
class="dropdown-toggle" data-toggle="dropdown">Features <b
class="caret"></b></a>
- <ul
class="dropdown-menu">
- <li ><a
href="transactions.html" title="Transactions">Transactions</a></li>
- <li ><a
href="udf.html" title="User-defined Functions">User-defined Functions</a></li>
- <li
class="divider"/>
- <li ><a
href="secondary_indexing.html" title="Secondary Indexes">Secondary
Indexes</a></li>
- <li ><a
href="columnencoding.html" title="Storage Formats">Storage Formats</a></li>
- <li ><a
href="atomic_upsert.html" title="Atomic Upsert">Atomic Upsert</a></li>
- <li ><a
href="namspace_mapping.html" title="Namespace Mapping">Namespace
Mapping</a></li>
- <li ><a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a></li>
- <li ><a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp
Column</a></li>
- <li ><a
href="paged.html" title="Paged Queries">Paged Queries</a></li>
- <li ><a
href="salted.html" title="Salted Tables">Salted Tables</a></li>
- <li ><a
href="skip_scan.html" title="Skip Scan">Skip Scan</a></li>
- <li ><a
href="tablesample.html" title="Table Sampling">Table Sampling</a></li>
- <li
class="divider"/>
- <li ><a
href="views.html" title="Views">Views</a></li>
- <li ><a
href="multi-tenancy.html" title="Multi tenancy">Multi tenancy</a></li>
- <li ><a
href="dynamic_columns.html" title="Dynamic Columns">Dynamic Columns</a></li>
- <li
class="divider"/>
- <li ><a
href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
- <li ><a
href="server.html" title="Query Server">Query Server</a></li>
- <li ><a
href="metrics.html" title="Metrics">Metrics</a></li>
- <li ><a
href="tracing.html" title="Tracing">Tracing</a></li>
- <li ><a
href="cursors.html" title="Cursor">Cursor</a></li>
- </ul>
- </li>
- <li class="dropdown">
- <a href="#"
class="dropdown-toggle" data-toggle="dropdown">Reference <b
class="caret"></b></a>
- <ul
class="dropdown-menu">
- <li ><a
href="language/index.html" title="Grammar">Grammar</a></li>
- <li ><a
href="language/functions.html" title="Functions">Functions</a></li>
- <li ><a
href="language/datatypes.html" title="Datatypes">Datatypes</a></li>
- <li ><a
href="array_type.html" title="ARRAY type">ARRAY type</a></li>
- <li
class="divider"/>
- <li ><a
href="sequences.html" title="Sequences">Sequences</a></li>
- <li ><a
href="joins.html" title="Joins">Joins</a></li>
- <li ><a
href="subqueries.html" title="Subqueries">Subqueries</a></li>
- <li ><a
href="explainplan.html" title="Explain Plan">Explain Plan</a></li>
- </ul>
- </li>
- </ul>
- </div><!--/.nav-collapse -->
- </div>
- </div>
- </div>
-
- <div class="container">
-
- <!-- Masthead
- ================================================== -->
-
- <header>
- </header>
-
- <div class="main-body">
- <div class="row">
- <div class="span12">
- <div class="body-content">
-<div class="page-header">
- <h1>F.A.Q.</h1>
-</div>
-<ul>
- <li><a href="#I_want_to_get_started_Is_there_a_Phoenix_Hello_World">I want to
get started. Is there a Phoenix Hello World?</a></li>
- <li><a href="#What_is_the_Phoenix_JDBC_URL_syntax">What is the Phoenix JDBC
URL syntax?</a></li>
- <li><a href="#Is_there_a_way_to_bulk_load_in_Phoenix">Is there a way to bulk
load in Phoenix?</a></li>
- <li><a href="#How_I_map_Phoenix_table_to_an_existing_HBase_table">How I map
Phoenix table to an existing HBase table?</a></li>
- <li><a href="#Are_there_any_tips_for_optimizing_Phoenix">Are there any tips
for optimizing Phoenix?</a></li>
- <li><a href="#How_do_I_create_Secondary_Index_on_a_table">How do I create
Secondary Index on a table?</a></li>
- <li><a href="#Why_isnt_my_secondary_index_being_used">Why isnât my
secondary index being used?</a></li>
- <li><a href="#How_fast_is_Phoenix_Why_is_it_so_fast">How fast is Phoenix? Why
is it so fast?</a></li>
- <li><a href="#How_do_I_connect_to_secure_HBase_cluster">How do I connect to
secure HBase cluster?</a></li>
- <li><a href="#How_do_I_connect_with_HBase_running_on_Hadoop-2">How do I
connect with HBase running on Hadoop-2?</a></li>
- <li><a
href="#Can_phoenix_work_on_tables_with_arbitrary_timestamp_as_flexible_as_HBase_API">Can
phoenix work on tables with arbitrary timestamp as flexible as HBase
API?</a></li>
- <li><a href="#Why_isnt_my_query_doing_a_RANGE_SCAN">Why isnât my query
doing a RANGE SCAN?</a></li>
- <li><a href="#Should_I_pool_Phoenix_JDBC_Connections">Should I pool Phoenix
JDBC Connections?</a></li>
- <li><a href="#Why_empty_key_value">Why does Phoenix add an empty or dummy
KeyValue when doing an upsert?</a></li>
-</ul>
-<div class="section">
- <div class="section">
- <h3 id="I_want_to_get_started._Is_there_a_Phoenix_Hello_World">I want to get
started. Is there a Phoenix <i>Hello World</i>?</h3>
- <p><i>Pre-requisite:</i> <a href="download.html">Download</a> and <a
href="installation.html">install</a> the latest Phoenix.</p>
- <p><b>1. Using console</b></p>
- <ol style="list-style-type: decimal">
- <li>Start Sqlline: <tt>$ sqlline.py [zookeeper quorum hosts]</tt></li>
- <li>Execute the following statements when Sqlline connects:</li>
- </ol>
- <div class="source">
- <pre>create table test (mykey integer not null primary key, mycolumn
varchar);
-upsert into test values (1,'Hello');
-upsert into test values (2,'World!');
-select * from test;
-</pre>
- </div>
- <ol style="list-style-type: decimal">
- <li>You should get the following output</li>
- </ol>
- <div class="source">
- <pre>+-------+------------+
-| MYKEY | MYCOLUMN |
-+-------+------------+
-| 1 | Hello |
-| 2 | World! |
-+-------+------------+
-</pre>
- </div>
- <p><b>2. Using java</b></p>
- <p>Create test.java file with the following content:</p>
- <div class="source">
- <pre>import java.sql.Connection;
-import java.sql.DriverManager;
-import java.sql.ResultSet;
-import java.sql.SQLException;
-import java.sql.PreparedStatement;
-import java.sql.Statement;
-
-public class test {
-
- public static void main(String[] args) throws SQLException {
- Statement stmt = null;
- ResultSet rset = null;
-
- Connection con =
DriverManager.getConnection("jdbc:phoenix:[zookeeper quorum hosts]");
- stmt = con.createStatement();
-
- stmt.executeUpdate("create table test (mykey integer not
null primary key, mycolumn varchar)");
- stmt.executeUpdate("upsert into test values
(1,'Hello')");
- stmt.executeUpdate("upsert into test values
(2,'World!')");
- con.commit();
-
- PreparedStatement statement = con.prepareStatement("select
* from test");
- rset = statement.executeQuery();
- while (rset.next()) {
-
System.out.println(rset.getString("mycolumn"));
- }
- statement.close();
- con.close();
- }
-}
-</pre>
- </div>
- <p>Compile and execute on command line</p>
- <p><tt>$ javac test.java</tt></p>
- <p><tt>$ java -cp "../phoenix-[version]-client.jar:."
test</tt></p>
- <p>You should get the following output</p>
- <p><tt>Hello</tt> <tt>World!</tt></p>
- </div>
- <div class="section">
- <h3 id="What_is_the_Phoenix_JDBC_URL_syntax">What is the Phoenix JDBC URL
syntax?</h3>
- <div class="section">
- <h4 id="Thick_Driver">Thick Driver</h4>
- <p>The Phoenix (Thick) Driver JDBC URL syntax is as follows (where elements
in square brackets are optional):</p>
- <p><tt>jdbc:phoenix:[comma-separated ZooKeeper Quorum Hosts [: ZK port
[:hbase root znode [:kerberos_principal [:path to kerberos keytab] ] ]
]</tt></p>
- <p>The simplest URL is:</p>
- <p><tt>jdbc:phoenix:localhost</tt></p>
- <p>Whereas the most complicated URL is:</p>
-
<p><tt>jdbc:phoenix:zookeeper1.domain,zookeeper2.domain,zookeeper3.domain:2181:/hbase-1:phoe...@example.com:/etc/security/keytabs/phoenix.keytab</tt></p>
- <p>Please note that each optional element in the URL requires all previous
optional elements. For example, to specify the HBase root ZNode, the ZooKeeper
port <i>must</i> also be specified.</p>
- <p>This information is initially covered on the <a href="/#connStr">index
page</a>.</p>
- </div>
- <div class="section">
- <h4 id="Thin_Driver">Thin Driver</h4>
- <p>The Phoenix Thin Driver (used with the Phoenix Query Server) JDBC URL
syntax is as follows:</p>
- <p><tt>jdbc:phoenix:thin:[key=value[;key=value...]]</tt></p>
- <p>There are a number of keys exposed for client-use. The most
commonly-used keys are: <tt>url</tt> and <tt>serialization</tt>. The
<tt>url</tt> key is required to interact with the Phoenix Query Server.</p>
- <p>The simplest URL is:</p>
- <p><tt>jdbc:phoenix:thin:url=http://localhost:8765</tt></p>
- <p>Where as very complicated URL is:</p>
-
<p><tt>jdbc:phoenix:thin:url=http://queryserver.domain:8765;serialization=PROTOBUF;authentication=SPENGO;principal=phoe...@example.com;keytab=/etc/security/keytabs/phoenix.keytab</tt></p>
- <p>Please refer to the <a class="externalLink"
href="https://calcite.apache.org/avatica/docs/client_reference.html";>Apache
Avatica documentation</a> for a full list of supported options in the Thin
client JDBC URL, or see the <a href="server.html">Query Server
documentation</a></p>
- </div>
- </div>
- <div class="section">
- <h3 id="Is_there_a_way_to_bulk_load_in_Phoenix">Is there a way to bulk load
in Phoenix?</h3>
- <p><b>Map Reduce</b></p>
- <p>See the example <a href="bulk_dataload.html">here</a></p>
- <p><b>CSV</b></p>
- <p>CSV data can be bulk loaded with built in utility named psql. Typical
upsert rates are 20K - 50K rows per second (depends on how wide are the
rows).</p>
- <p>Usage example:<br />Create table using psql <tt>$ psql.py [zookeeper]
../examples/web_stat.sql</tt> </p>
- <p>Upsert CSV bulk data <tt>$ psql.py [zookeeper]
../examples/web_stat.csv</tt></p>
- </div>
- <div class="section">
- <h3 id="How_I_map_Phoenix_table_to_an_existing_HBase_table">How I map
Phoenix table to an existing HBase table?</h3>
- <p>You can create both a Phoenix table or view through the CREATE
TABLE/CREATE VIEW DDL statement on a pre-existing HBase table. In both cases,
weâll leave the HBase metadata as-is. For CREATE TABLE, weâll create any
metadata (table, column families) that doesnât already exist. Weâll also
add an empty key value for each row so that queries behave as expected (without
requiring all columns to be projected during scans).</p>
- <p>The other caveat is that the way the bytes were serialized must match the
way the bytes are serialized by Phoenix. For VARCHAR,CHAR, and UNSIGNED_*
types, we use the HBase Bytes methods. The CHAR type expects only single-byte
characters and the UNSIGNED types expect values greater than or equal to zero.
For signed types(TINYINT, SMALLINT, INTEGER and BIGINT), Phoenix will flip the
first bit so that negative values will sort before positive values. Because
HBase sorts row keys in lexicographical order and negative valueâs first bit
is 1 while positive 0 so that negative value is âgreater thanâ positive
value if we donât flip the first bit. So if you stored integers by HBase
native API and want to access them by Phoenix, make sure that all your data
types are UNSIGNED types.</p>
- <p>Our composite row keys are formed by simply concatenating the values
together, with a zero byte character used as a separator after a variable
length type.</p>
- <p>If you create an HBase table like this:</p>
- <p><tt>create 't1', {NAME => 'f1', VERSIONS => 5}</tt></p>
- <p>then you have an HBase table with a name of ât1â and a column family
with a name of âf1â. Remember, in HBase, you donât model the possible
KeyValues or the structure of the row key. This is the information you specify
in Phoenix above and beyond the table and column family.</p>
- <p>So in Phoenix, youâd create a view like this:</p>
- <p><tt>CREATE VIEW "t1" ( pk VARCHAR PRIMARY KEY,
"f1".val VARCHAR )</tt></p>
- <p>The âpkâ column declares that your row key is a VARCHAR (i.e. a
string) while the âf1â.val column declares that your HBase table will
contain KeyValues with a column family and column qualifier of âf1â:VAL and
that their value will be a VARCHAR.</p>
- <p>Note that you donât need the double quotes if you create your HBase
table with all caps names (since this is how Phoenix normalizes strings, by
upper casing them). For example, with:</p>
- <p><tt>create 'T1', {NAME => 'F1', VERSIONS => 5}</tt></p>
- <p>you could create this Phoenix view:</p>
- <p><tt>CREATE VIEW t1 ( pk VARCHAR PRIMARY KEY, f1.val VARCHAR )</tt></p>
- <p>Or if youâre creating new HBase tables, just let Phoenix do everything
for you like this (No need to use the HBase shell at all.):</p>
- <p><tt>CREATE TABLE t1 ( pk VARCHAR PRIMARY KEY, val VARCHAR )</tt></p>
- </div>
- <div class="section">
- <h3 id="Are_there_any_tips_for_optimizing_Phoenix">Are there any tips for
optimizing Phoenix?</h3>
- <ul>
- <li>Use <b>Salting</b> to increase read/write performance Salting can
significantly increase read/write performance by pre-splitting the data into
multiple regions. Although Salting will yield better performance in most
scenarios.</li>
- </ul>
- <p>Example:</p>
- <p><tt>CREATE TABLE TEST (HOST VARCHAR NOT NULL PRIMARY KEY, DESCRIPTION
VARCHAR) SALT_BUCKETS=16</tt></p>
- <p>Note: Ideally for a 16 region server cluster with quad-core CPUs, choose
salt buckets between 32-64 for optimal performance.</p>
- <ul>
- <li><b>Pre-split</b> table Salting does automatic table splitting but in
case you want to exactly control where table split occurs with out adding extra
byte or change row key order then you can pre-split a table.</li>
- </ul>
- <p>Example: </p>
- <p><tt>CREATE TABLE TEST (HOST VARCHAR NOT NULL PRIMARY KEY, DESCRIPTION
VARCHAR) SPLIT ON ('CS','EU','NA')</tt></p>
- <ul>
- <li>Use <b>multiple column families</b></li>
- </ul>
- <p>Column family contains related data in separate files. If you query use
selected columns then it make sense to group those columns together in a column
family to improve read performance.</p>
- <p>Example:</p>
- <p>Following create table DDL will create two column faimiles A and B.</p>
- <p><tt>CREATE TABLE TEST (MYKEY VARCHAR NOT NULL PRIMARY KEY, A.COL1
VARCHAR, A.COL2 VARCHAR, B.COL3 VARCHAR)</tt></p>
- <ul>
- <li>Use <b>compression</b> On disk compression improves performance on
large tables</li>
- </ul>
- <p>Example: </p>
- <p><tt>CREATE TABLE TEST (HOST VARCHAR NOT NULL PRIMARY KEY, DESCRIPTION
VARCHAR) COMPRESSION='GZ'</tt></p>
- <ul>
- <li> <p>Create <b>indexes</b> See <a
href="#How_do_I_create_Secondary_Index_on_a_table">#How_do_I_create_Secondary_Index_on_a_table</a></p></li>
- <li> <p><b>Optimize cluster</b> parameters See <a class="externalLink"
href="http://hbase.apache.org/book/performance.html";>http://hbase.apache.org/book/performance.html</a></p></li>
- <li> <p><b>Optimize Phoenix</b> parameters See <a
href="tuning.html">tuning.html</a></p></li>
- </ul>
- </div>
- <div class="section">
- <h3 id="How_do_I_create_Secondary_Index_on_a_table">How do I create
Secondary Index on a table?</h3>
- <p>Starting with Phoenix version 2.1, Phoenix supports index over mutable
and immutable data. Note that Phoenix 2.0.x only supports Index over immutable
data. Index write performance index with immutable table is slightly faster
than mutable table however data in immutable table cannot be updated.</p>
- <p>Example</p>
- <ul>
- <li>Create table</li>
- </ul>
- <p>Immutable table: <tt>create table test (mykey varchar primary key, col1
varchar, col2 varchar) IMMUTABLE_ROWS=true;</tt></p>
- <p>Mutable table: <tt>create table test (mykey varchar primary key, col1
varchar, col2 varchar);</tt></p>
- <ul>
- <li>Creating index on col2</li>
- </ul>
- <p><tt>create index idx on test (col2)</tt></p>
- <ul>
- <li>Creating index on col1 and a covered index on col2</li>
- </ul>
- <p><tt>create index idx on test (col1) include (col2)</tt></p>
- <p>Upsert rows in this test table and Phoenix query optimizer will choose
correct index to use. You can see in <a
href="language/index.html#explain">explain plan</a> if Phoenix is using the
index table. You can also give a <a href="language/index.html#hint">hint</a> in
Phoenix query to use a specific index.</p>
- <p>See <a href="secondary_indexing.html">Secondary Indexing</a> for further
information</p>
- </div>
- <div class="section">
- <h3 id="Why_isnt_my_secondary_index_being_used">Why isnât my secondary
index being used?</h3>
- <p>The secondary index wonât be used unless all columns used in the query
are in it ( as indexed or covered columns). All columns making up the primary
key of the data table will automatically be included in the index.</p>
- <p>Example: DDL <tt>create table usertable (id varchar primary key,
firstname varchar, lastname varchar); create index idx_name on usertable
(firstname);</tt></p>
- <p>Query: DDL <tt>select id, firstname, lastname from usertable where
firstname = 'foo';</tt></p>
- <p>Index would not be used in this case as lastname is not part of indexed
or covered column. This can be verified by looking at the explain plan. To fix
this create index that has either lastname part of index or covered column.
Example: <tt>create idx_name on usertable (firstname) include
(lastname);</tt></p>
- <p>You can force Phoenix to use secondary for uncovered columns by
specifying an <a href="index.html#index_hint">index hint</a></p>
- </div>
- <div class="section">
- <h3 id="How_fast_is_Phoenix_Why_is_it_so_fast">How fast is Phoenix? Why is
it so fast?</h3>
- <p>Phoenix is fast. Full table scan of 100M rows usually completes in 20
seconds (narrow table on a medium sized cluster). This time come down to few
milliseconds if query contains filter on key columns. For filters on non-key
columns or non-leading key columns, you can add index on these columns which
leads to performance equivalent to filtering on key column by making copy of
table with indexed column(s) part of key.</p>
- <p>Why is Phoenix fast even when doing full scan:</p>
- <ol style="list-style-type: decimal">
- <li>Phoenix chunks up your query using the region boundaries and runs them
in parallel on the client using a configurable number of threads</li>
- <li>The aggregation will be done in a coprocessor on the server-side,
collapsing the amount of data that gets returned back to the client rather than
returning it all.</li>
- </ol>
- </div>
- <div class="section">
- <h3 id="How_do_I_connect_to_secure_HBase_cluster">How do I connect to secure
HBase cluster?</h3>
- <p>Specify the principal and corresponding keytab in the JDBC URL as show
above. For ancient Phoenix versions heck out the excellent <a
class="externalLink"
href="http://bigdatanoob.blogspot.com/2013/09/connect-phoenix-to-secure-hbase-cluster.html";>post</a>
by Anil Gupta </p>
- </div>
- <div class="section">
- <h3 id="What_HBase_and_Hadoop_versions_are_supported_">What HBase and Hadoop
versions are supported ?</h3>
- <p>Phoenix 4.x supports HBase 1.x running on Hadoop 2</p>
- <p>Phoenix 5.x supports HBase 2.x running on Hadoop 3</p>
- <p>See the release notes and BULDING.md in recent releases for the exact
versions supported, and on how to build Phoenix for specific HBase and Hadoop
versions</p>
- </div>
- <div class="section">
- <h3
id="Can_phoenix_work_on_tables_with_arbitrary_timestamp_as_flexible_as_HBase_API">Can
phoenix work on tables with arbitrary timestamp as flexible as HBase API?</h3>
- <p>By default, Phoenix letâs HBase manage the timestamps and just shows
you the latest values for everything. However, Phoenix also allows arbitrary
timestamps to be supplied by the user. To do that youâd specify a
âCurrentSCNâ at connection time, like this:</p>
- <div class="source">
- <pre>Properties props = new Properties();
-props.setProperty("CurrentSCN", Long.toString(ts));
-Connection conn = DriverManager.connect(myUrl, props);
-
-conn.createStatement().execute("UPSERT INTO myTable VALUES ('a')");
-conn.commit();
-</pre>
- </div>
- <p>The above is equivalent to doing this with the HBase API:</p>
- <div class="source">
- <pre>myTable.put(Bytes.toBytes('a'),ts);
-</pre>
- </div>
- <p>By specifying a CurrentSCN, youâre telling Phoenix that you want
everything for that connection to be done at that timestamp. Note that this
applies to queries done on the connection as well - for example, a query over
myTable above would not see the data it just upserted, since it only sees data
that was created before its CurrentSCN property. This provides a way of doing
snapshot, flashback, or point-in-time queries.</p>
- <p>Keep in mind that creating a new connection is <i>not</i> an expensive
operation. The same underlying HConnection is used for all connections to the
same cluster, so itâs more or less like instantiating a few objects.</p>
- </div>
- <div class="section">
- <h3 id="Why_isnt_my_query_doing_a_RANGE_SCAN">Why isnât my query doing a
RANGE SCAN?</h3>
- <p><tt>DDL: CREATE TABLE TEST (pk1 char(1) not null, pk2 char(1) not null,
pk3 char(1) not null, non-pk varchar CONSTRAINT PK PRIMARY KEY(pk1, pk2,
pk3));</tt></p>
- <p>RANGE SCAN means that only a subset of the rows in your table will be
scanned over. This occurs if you use one or more leading columns from your
primary key constraint. Query that is not filtering on leading PK columns ex.
<tt>select * from test where pk2='x' and pk3='y';</tt> will result in full scan
whereas the following query will result in range scan <tt>select * from test
where pk1='x' and pk2='y';</tt>. Note that you can add a secondary index on
your âpk2â and âpk3â columns and that would cause a range scan to be
done for the first query (over the index table).</p>
- <p>DEGENERATE SCAN means that a query canât possibly return any rows. If
we can determine that at compile time, then we donât bother to even run the
scan.</p>
- <p>FULL SCAN means that all rows of the table will be scanned over
(potentially with a filter applied if you have a WHERE clause)</p>
- <p>SKIP SCAN means that either a subset or all rows in your table will be
scanned over, however it will skip large groups of rows depending on the
conditions in your filter. See <a class="externalLink"
href="http://phoenix-hbase.blogspot.com/2013/05/demystifying-skip-scan-in-phoenix.html";>this</a>
blog for more detail. We donât do a SKIP SCAN if you have no filter on the
leading primary key columns, but you can force a SKIP SCAN by using the /<i>+
SKIP_SCAN </i>/ hint. Under some conditions, namely when the cardinality of
your leading primary key columns is low, it will be more efficient than a FULL
SCAN.</p>
- </div>
- <div class="section">
- <h3 id="Should_I_pool_Phoenix_JDBC_Connections">Should I pool Phoenix JDBC
Connections?</h3>
- <p>No, it is not necessary to pool Phoenix JDBC Connections.</p>
- <p>Phoenixâs Connection objects are different from most other JDBC
Connections due to the underlying HBase connection. The Phoenix Connection
object is designed to be a thin object that is inexpensive to create. If
Phoenix Connections are reused, it is possible that the underlying HBase
connection is not always left in a healthy state by the previous user. It is
better to create new Phoenix Connections to ensure that you avoid any potential
issues.</p>
- <p>Implementing pooling for Phoenix could be done simply by creating a
delegate Connection that instantiates a new Phoenix connection when retrieved
from the pool and then closes the connection when returning it to the pool (see
<a class="externalLink"
href="https://issues.apache.org/jira/browse/PHOENIX-2388";>PHOENIX-2388</a>).</p>
- </div>
- <div class="section">
- <h3 id="Why_empty_key_value">Why does Phoenix add an empty/dummy KeyValue
when doing an upsert?<a
name="Why_does_Phoenix_add_an_emptydummy_KeyValue_when_doing_an_upsert"></a></h3>
- <p>The empty or dummy KeyValue (with a column qualifier of _0) is needed to
ensure that a given column is available for all rows.</p>
- <p>As you may know, data is stored in HBase as KeyValues, meaning that the
full row key is stored for each column value. This also implies that the row
key is not stored at all unless there is at least one column stored.</p>
- <p>Now consider JDBC row which has an integer primary key, and several
columns which are all null. In order to be able to store the primary key, a
KeyValue needs to be stored to show that the row is present at all. This column
is represented by the empty column that youâve noticed. This allows doing a
âSELECT * FROM TABLEâ and receiving records for all rows, even those whose
non-pk columns are null.</p>
- <p>The same issue comes up even if only one column is null for some (or all)
records. A scan over Phoenix will include the empty column to ensure that rows
that only consist of the primary key (and have null for all non-key columns)
will be included in a scan result.</p>
- </div>
-</div>
- </div>
- </div>
- </div>
- </div>
-
- </div><!-- /container -->
-
- <!-- Footer
- ================================================== -->
- <footer class="well">
- <div class="container">
- <div class="row">
- <div class="span2 bottom-nav">
- <ul class="nav nav-list">
- <li
class="nav-header">About</li>
- <li >
- <a href="index.html"
title="Overview">Overview</a>
- </li>
- <li >
- <a
href="who_is_using.html" title="Who is Using">Who is Using</a>
- </li>
- <li >
- <a href="recent.html"
title="Recent Improvements">Recent Improvements</a>
- </li>
- <li >
- <a href="roadmap.html"
title="Roadmap">Roadmap</a>
- </li>
- <li >
- <a href="news.html"
title="News">News</a>
- </li>
- <li >
- <a
href="performance.html" title="Performance">Performance</a>
- </li>
- <li >
- <a href="team.html"
title="Team">Team</a>
- </li>
- <li >
- <a
href="tech_talks.html" title="Tech Talks">Tech Talks</a>
- </li>
- <li >
- <a
href="resources.html" title="Presentations">Presentations</a>
- </li>
- <li >
- <a
href="mailing_list.html" title="Mailing Lists">Mailing Lists</a>
- </li>
- <li >
- <a href="source.html"
title="Source Repository">Source Repository</a>
- </li>
- <li >
- <a href="issues.html"
title="Issue Tracking">Issue Tracking</a>
- </li>
- <li >
- <a href="download.html"
title="Download">Download</a>
- </li>
- <li >
- <a
href="installation.html" title="Installation">Installation</a>
- </li>
- <li >
- <a href="http:divider"
title=""></a>
- </li>
- <li >
- <a
href="contributing.html" title="How to Contribute">How to Contribute</a>
- </li>
- <li >
- <a href="develop.html"
title="How to Develop">How to Develop</a>
- </li>
- <li >
- <a
href="building_website.html" title="How to Update Website">How to Update
Website</a>
- </li>
- <li >
- <a href="release.html"
title="How to Release">How to Release</a>
- </li>
- <li >
- <a href="http:divider"
title=""></a>
- </li>
- <li >
- <a
href="http://www.apache.org/licenses/"; title="License"
class="externalLink">License</a>
- </li>
- </ul>
- </div>
- <div class="span2 bottom-nav">
- <ul class="nav nav-list">
- <li
class="nav-header">Using</li>
- <li class="active">
- <a href="#"
title="F.A.Q.">F.A.Q.</a>
- </li>
- <li >
- <a
href="Phoenix-in-15-minutes-or-less.html" title="Quick Start">Quick Start</a>
- </li>
- <li >
- <a href="building.html"
title="Building">Building</a>
- </li>
- <li >
- <a
href="tuning_guide.html" title="Tuning">Tuning</a>
- </li>
- <li >
- <a
href="explainplan.html" title="Explain Plan">Explain Plan</a>
- </li>
- <li >
- <a href="tuning.html"
title="Configuration">Configuration</a>
- </li>
- <li >
- <a
href="upgrading.html" title="Backward Compatibility">Backward Compatibility</a>
- </li>
- <li >
- <a
href="release_notes.html" title="Release Notes">Release Notes</a>
- </li>
- <li >
- <a href="pherf.html"
title="Performance Testing">Performance Testing</a>
- </li>
- <li >
- <a href="http:divider"
title=""></a>
- </li>
- <li >
- <a
href="phoenix_spark.html" title="Apache Spark Integration">Apache Spark
Integration</a>
- </li>
- <li >
- <a
href="hive_storage_handler.html" title="Phoenix Storage Handler for Apache
Hive">Phoenix Storage Handler for Apache Hive</a>
- </li>
- <li >
- <a
href="pig_integration.html" title="Apache Pig Integration">Apache Pig
Integration</a>
- </li>
- <li >
- <a
href="phoenix_mr.html" title="Map Reduce Integration">Map Reduce Integration</a>
- </li>
- <li >
- <a href="flume.html"
title="Apache Flume Plugin">Apache Flume Plugin</a>
- </li>
- <li >
- <a href="kafka.html"
title="Apache Kafka Plugin">Apache Kafka Plugin</a>
- </li>
- <li >
- <a href="python.html"
title="Python Driver">Python Driver</a>
- </li>
- </ul>
- </div>
- <div class="span2 bottom-nav">
- <ul class="nav nav-list">
- <li
class="nav-header">Features</li>
- <li >
- <a
href="transactions.html" title="Transactions">Transactions</a>
- </li>
- <li >
- <a href="udf.html"
title="User-defined Functions">User-defined Functions</a>
- </li>
- <li >
- <a href="http:divider"
title=""></a>
- </li>
- <li >
- <a
href="secondary_indexing.html" title="Secondary Indexes">Secondary Indexes</a>
- </li>
- <li >
- <a
href="columnencoding.html" title="Storage Formats">Storage Formats</a>
- </li>
- <li >
- <a
href="atomic_upsert.html" title="Atomic Upsert">Atomic Upsert</a>
- </li>
- <li >
- <a
href="namspace_mapping.html" title="Namespace Mapping">Namespace Mapping</a>
- </li>
- <li >
- <a
href="update_statistics.html" title="Statistics Collection">Statistics
Collection</a>
- </li>
- <li >
- <a
href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
- </li>
- <li >
- <a href="paged.html"
title="Paged Queries">Paged Queries</a>
- </li>
- <li >
- <a href="salted.html"
title="Salted Tables">Salted Tables</a>
- </li>
- <li >
- <a
href="skip_scan.html" title="Skip Scan">Skip Scan</a>
- </li>
- <li >
- <a
href="tablesample.html" title="Table Sampling">Table Sampling</a>
- </li>
- <li >
- <a href="http:divider"
title=""></a>
- </li>
- <li >
- <a href="views.html"
title="Views">Views</a>
- </li>
- <li >
- <a
href="multi-tenancy.html" title="Multi tenancy">Multi tenancy</a>
- </li>
- <li >
- <a
href="dynamic_columns.html" title="Dynamic Columns">Dynamic Columns</a>
- </li>
- <li >
- <a href="http:divider"
title=""></a>
- </li>
- <li >
- <a
href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a>
- </li>
- <li >
- <a href="server.html"
title="Query Server">Query Server</a>
- </li>
- <li >
- <a href="metrics.html"
title="Metrics">Metrics</a>
- </li>
- <li >
- <a href="tracing.html"
title="Tracing">Tracing</a>
- </li>
- <li >
- <a href="cursors.html"
title="Cursor">Cursor</a>
- </li>
- </ul>
- </div>
- <div class="span3 bottom-nav">
- <ul class="nav nav-list">
- <li
class="nav-header">Reference</li>
- <li >
- <a
href="language/index.html" title="Grammar">Grammar</a>
- </li>
- <li >
- <a
href="language/functions.html" title="Functions">Functions</a>
- </li>
- <li >
- <a
href="language/datatypes.html" title="Datatypes">Datatypes</a>
- </li>
- <li >
- <a
href="array_type.html" title="ARRAY type">ARRAY type</a>
- </li>
- <li >
- <a href="http:divider"
title=""></a>
- </li>
- <li >
- <a
href="sequences.html" title="Sequences">Sequences</a>
- </li>
- <li >
- <a href="joins.html"
title="Joins">Joins</a>
- </li>
- <li >
- <a
href="subqueries.html" title="Subqueries">Subqueries</a>
- </li>
- <li >
- <a
href="explainplan.html" title="Explain Plan">Explain Plan</a>
- </li>
- </ul>
- </div>
- </div>
- </div>
- </footer>
-
- <div class="container subfooter">
- <div class="row">
- <div class="span12">
- <p class="pull-right"><a href="#">Back to
top</a></p>
- <p class="copyright">Copyright ©2022 <a
href="http://www.apache.org";>Apache Software Foundation</a>. All Rights
Reserved.</p>
- </div>
- </div>
- </div>
-
- <!-- Le javascript
- ================================================== -->
- <!-- Placed at the end of the document so the pages load faster -->
- <script
src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
-
- <script
src="//netdna.bootstrapcdn.com/twitter-bootstrap/2.3.2/js/bootstrap.min.js"></script>
- <script src="./js/lightbox.js"></script>
- <script src="./js/jquery.smooth-scroll.min.js"></script>
- <!-- back button support for smooth scroll -->
- <script src="./js/jquery.ba-bbq.min.js"></script>
- <script src="//yandex.st/highlightjs/7.5/highlight.min.js"></script>
-
- <script src="./js/reflow-skin.js"></script>
-
- </body>
-</html>
Modified: phoenix/site/publish/flume.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/flume.html?rev=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/flume.html (original)
+++ phoenix/site/publish/flume.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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/hive_storage_handler.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/hive_storage_handler.html?rev=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/hive_storage_handler.html (original)
+++ phoenix/site/publish/hive_storage_handler.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/index.html (original)
+++ phoenix/site/publish/index.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/installation.html (original)
+++ phoenix/site/publish/installation.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/issues.html (original)
+++ phoenix/site/publish/issues.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/joins.html (original)
+++ phoenix/site/publish/joins.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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/kafka.html
URL:
http://svn.apache.org/viewvc/phoenix/site/publish/kafka.html?rev=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/kafka.html (original)
+++ phoenix/site/publish/kafka.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
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=1899733&r1=1899732&r2=1899733&view=diff
==============================================================================
--- phoenix/site/publish/language/datatypes.html (original)
+++ phoenix/site/publish/language/datatypes.html Mon Apr 11 08:21:54 2022
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2022-04-10
+ Generated by Apache Maven Doxia at 2022-04-11
Rendered using Reflow Maven Skin 1.1.0
(http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -168,7 +168,579 @@
<div class="body-content">
<div class="page-header">
<h1>Data Types</h1>
-</div>update_here
+</div>
+
+<!-- } -->
+<h2 id="dataTypes">Index</h2>
+<!-- syntax-start
+<p class="notranslate">
+
+ <a href="#integer_type" >INTEGER Type</a><br />
+
+ <a href="#unsigned_int_type" >UNSIGNED_INT Type</a><br />
+
+ <a href="#bigint_type" >BIGINT Type</a><br />
+
+ <a href="#unsigned_long_type" >UNSIGNED_LONG Type</a><br />
+
+ <a href="#tinyint_type" >TINYINT Type</a><br />
+
+ <a href="#unsigned_tinyint_type" >UNSIGNED_TINYINT Type</a><br />
+
+ <a href="#smallint_type" >SMALLINT Type</a><br />
+
+ <a href="#unsigned_smallint_type" >UNSIGNED_SMALLINT Type</a><br />
+
+ <a href="#float_type" >FLOAT Type</a><br />
+
+ <a href="#unsigned_float_type" >UNSIGNED_FLOAT Type</a><br />
+
+ <a href="#double_type" >DOUBLE Type</a><br />
+
+ <a href="#unsigned_double_type" >UNSIGNED_DOUBLE Type</a><br />
+
+ <a href="#decimal_type" >DECIMAL Type</a><br />
+
+ <a href="#boolean_type" >BOOLEAN Type</a><br />
+
+ <a href="#time_type" >TIME Type</a><br />
+
+ <a href="#date_type" >DATE Type</a><br />
+
+ <a href="#timestamp_type" >TIMESTAMP Type</a><br />
+
+ <a href="#unsigned_time_type" >UNSIGNED_TIME Type</a><br />
+
+ <a href="#unsigned_date_type" >UNSIGNED_DATE Type</a><br />
+
+ <a href="#unsigned_timestamp_type" >UNSIGNED_TIMESTAMP Type</a><br />
+
+ <a href="#varchar_type" >VARCHAR Type</a><br />
+
+ <a href="#char_type" >CHAR Type</a><br />
+
+ <a href="#binary_type" >BINARY Type</a><br />
+
+ <a href="#varbinary_type" >VARBINARY Type</a><br />
+
+ <a href="#array" >ARRAY</a><br />
+</p>
+syntax-end -->
+<!-- railroad-start -->
+<table class="notranslate index">
+ <tr>
+ <td class="index">
+
+ <a href="#integer_type" >INTEGER Type</a><br />
+
+ <a href="#unsigned_int_type" >UNSIGNED_INT Type</a><br />
+
+ <a href="#bigint_type" >BIGINT Type</a><br />
+
+ <a href="#unsigned_long_type" >UNSIGNED_LONG Type</a><br />
+
+ <a href="#tinyint_type" >TINYINT Type</a><br />
+
+ <a href="#unsigned_tinyint_type" >UNSIGNED_TINYINT Type</a><br
/>
+
+ <a href="#smallint_type" >SMALLINT Type</a><br />
+
+ <a href="#unsigned_smallint_type" >UNSIGNED_SMALLINT
Type</a><br />
+
+ <a href="#float_type" >FLOAT Type</a><br />
+ </td><td class="index">
+
+ <a href="#unsigned_float_type" >UNSIGNED_FLOAT Type</a><br />
+
+ <a href="#double_type" >DOUBLE Type</a><br />
+
+ <a href="#unsigned_double_type" >UNSIGNED_DOUBLE Type</a><br />
+
+ <a href="#decimal_type" >DECIMAL Type</a><br />
+
+ <a href="#boolean_type" >BOOLEAN Type</a><br />
+
+ <a href="#time_type" >TIME Type</a><br />
+
+ <a href="#date_type" >DATE Type</a><br />
+
+ <a href="#timestamp_type" >TIMESTAMP Type</a><br />
+
+ <a href="#unsigned_time_type" >UNSIGNED_TIME Type</a><br />
+ </td><td class="index">
+
+ <a href="#unsigned_date_type" >UNSIGNED_DATE Type</a><br />
+
+ <a href="#unsigned_timestamp_type" >UNSIGNED_TIMESTAMP
Type</a><br />
+
+ <a href="#varchar_type" >VARCHAR Type</a><br />
+
+ <a href="#char_type" >CHAR Type</a><br />
+
+ <a href="#binary_type" >BINARY Type</a><br />
+
+ <a href="#varbinary_type" >VARBINARY Type</a><br />
+
+ <a href="#array" >ARRAY</a><br />
+ </td>
+ </tr>
+</table>
+<!-- railroad-end -->
+
+
+<h3 id="integer_type" class="notranslate">INTEGER Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+INTEGER
+</pre>
+<div name="railroad">
+<code class="c">INTEGER</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+INTEGER
+</pre>
+syntax-end -->
+<p>Possible values: -2147483648 to 2147483647.</p><p>Mapped to
<code>java.lang.Integer</code>. The binary representation is a 4 byte integer
with the sign bit flipped (so that negative values sorts before positive
values).</p>
+<p>Example:</p>
+<p class="notranslate">INTEGER</p>
+
+<h3 id="unsigned_int_type" class="notranslate">UNSIGNED_INT Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+UNSIGNED_INT
+</pre>
+<div name="railroad">
+<code class="c">UNSIGNED_INT</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+UNSIGNED_INT
+</pre>
+syntax-end -->
+<p>Possible values: 0 to 2147483647. Mapped to <code>java.lang.Integer</code>.
The binary representation is a 4 byte integer, matching the <code>HBase</code>
Bytes.toBytes(int) method. The purpose of this type is to map to existing
<code>HBase</code> data that was serialized using this <code>HBase</code>
utility method. If that is not the case, use the regular signed type
instead.</p>
+<p>Example:</p>
+<p class="notranslate">UNSIGNED_INT</p>
+
+<h3 id="bigint_type" class="notranslate">BIGINT Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+BIGINT
+</pre>
+<div name="railroad">
+<code class="c">BIGINT</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+BIGINT
+</pre>
+syntax-end -->
+<p>Possible values: -9223372036854775808 to 9223372036854775807. Mapped to
<code>java.lang.Long</code>. The binary representation is an 8 byte long with
the sign bit flipped (so that negative values sorts before positive values).</p>
+<p>Example:</p>
+<p class="notranslate">BIGINT</p>
+
+<h3 id="unsigned_long_type" class="notranslate">UNSIGNED_LONG Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+UNSIGNED_LONG
+</pre>
+<div name="railroad">
+<code class="c">UNSIGNED_LONG</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+UNSIGNED_LONG
+</pre>
+syntax-end -->
+<p>Possible values: 0 to 9223372036854775807. Mapped to
<code>java.lang.Long</code>. The binary representation is an 8 byte integer,
matching the <code>HBase</code> Bytes.toBytes(long) method. The purpose of this
type is to map to existing <code>HBase</code> data that was serialized using
this <code>HBase</code> utility method. If that is not the case, use the
regular signed type instead.</p>
+<p>Example:</p>
+<p class="notranslate">UNSIGNED_LONG</p>
+
+<h3 id="tinyint_type" class="notranslate">TINYINT Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+TINYINT
+</pre>
+<div name="railroad">
+<code class="c">TINYINT</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+TINYINT
+</pre>
+syntax-end -->
+<p>Possible values: -128 to 127. Mapped to <code>java.lang.Byte</code>. The
binary representation is a single byte, with the sign bit flipped (so that
negative values sorts before positive values).</p>
+<p>Example:</p>
+<p class="notranslate">TINYINT</p>
+
+<h3 id="unsigned_tinyint_type" class="notranslate">UNSIGNED_TINYINT Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+UNSIGNED_TINYINT
+</pre>
+<div name="railroad">
+<code class="c">UNSIGNED_TINYINT</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+UNSIGNED_TINYINT
+</pre>
+syntax-end -->
+<p>Possible values: 0 to 127. Mapped to <code>java.lang.Byte</code>. The
binary representation is a single byte, matching the <code>HBase</code>
Bytes.toBytes(byte) method. The purpose of this type is to map to existing
<code>HBase</code> data that was serialized using this <code>HBase</code>
utility method. If that is not the case, use the regular signed type
instead.</p>
+<p>Example:</p>
+<p class="notranslate">UNSIGNED_TINYINT</p>
+
+<h3 id="smallint_type" class="notranslate">SMALLINT Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+SMALLINT
+</pre>
+<div name="railroad">
+<code class="c">SMALLINT</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+SMALLINT
+</pre>
+syntax-end -->
+<p>Possible values: -32768 to 32767. Mapped to <code>java.lang.Short</code>.
The binary representation is a 2 byte short with the sign bit flipped (so that
negative values sort before positive values).</p>
+<p>Example:</p>
+<p class="notranslate">SMALLINT</p>
+
+<h3 id="unsigned_smallint_type" class="notranslate">UNSIGNED_SMALLINT Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+UNSIGNED_SMALLINT
+</pre>
+<div name="railroad">
+<code class="c">UNSIGNED_SMALLINT</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+UNSIGNED_SMALLINT
+</pre>
+syntax-end -->
+<p>Possible values: 0 to 32767. Mapped to <code>java.lang.Short</code>. The
binary representation is an 2 byte integer, matching the <code>HBase</code>
Bytes.toBytes(short) method. The purpose of this type is to map to existing
<code>HBase</code> data that was serialized using this <code>HBase</code>
utility method. If that is not the case, use the regular signed type
instead.</p>
+<p>Example:</p>
+<p class="notranslate">UNSIGNED_SMALLINT</p>
+
+<h3 id="float_type" class="notranslate">FLOAT Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+FLOAT
+</pre>
+<div name="railroad">
+<code class="c">FLOAT</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+FLOAT
+</pre>
+syntax-end -->
+<p>Possible values: -3.402823466 E + 38 to 3.402823466 E + 38. Mapped to
<code>java.lang.Float</code>. The binary representation is an 4 byte float with
the sign bit flipped (so that negative values sort before positive values).</p>
+<p>Example:</p>
+<p class="notranslate">FLOAT</p>
+
+<h3 id="unsigned_float_type" class="notranslate">UNSIGNED_FLOAT Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+UNSIGNED_FLOAT
+</pre>
+<div name="railroad">
+<code class="c">UNSIGNED_FLOAT</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+UNSIGNED_FLOAT
+</pre>
+syntax-end -->
+<p>Possible values: 0 to 3.402823466 E + 38. Mapped to
<code>java.lang.Float</code>. The binary representation is an 4 byte float
matching the <code>HBase</code> Bytes.toBytes(float) method. The purpose of
this type is to map to existing <code>HBase</code> data that was serialized
using this <code>HBase</code> utility method. If that is not the case, use the
regular signed type instead.</p>
+<p>Example:</p>
+<p class="notranslate">UNSIGNED_FLOAT</p>
+
+<h3 id="double_type" class="notranslate">DOUBLE Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+DOUBLE
+</pre>
+<div name="railroad">
+<code class="c">DOUBLE</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+DOUBLE
+</pre>
+syntax-end -->
+<p>Possible values: -1.7976931348623158 E + 308 to 1.7976931348623158 E + 308.
Mapped to <code>java.lang.Double</code>. The binary representation is an 8 byte
double with the sign bit flipped (so that negative values sort before positive
value).</p>
+<p>Example:</p>
+<p class="notranslate">DOUBLE</p>
+
+<h3 id="unsigned_double_type" class="notranslate">UNSIGNED_DOUBLE Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+UNSIGNED_DOUBLE
+</pre>
+<div name="railroad">
+<code class="c">UNSIGNED_DOUBLE</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+UNSIGNED_DOUBLE
+</pre>
+syntax-end -->
+<p>Possible values: 0 to 1.7976931348623158 E + 308. Mapped to
<code>java.lang.Double</code>. The binary representation is an 8 byte double
matching the <code>HBase</code> Bytes.toBytes(double) method. The purpose of
this type is to map to existing <code>HBase</code> data that was serialized
using this <code>HBase</code> utility method. If that is not the case, use the
regular signed type instead.</p>
+<p>Example:</p>
+<p class="notranslate">UNSIGNED_DOUBLE</p>
+
+<h3 id="decimal_type" class="notranslate">DECIMAL Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+DECIMAL [ (<a href="index.html#int">precisionInt</a>, <a
href="index.html#int">scaleInt</a>) ]
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code
class="c">DECIMAL</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">( <a href="index.html#int">precisionInt</a> , <a
href="index.html#int">scaleInt</a> )</code></td></tr></table></td><td
class="le"></td></tr></table></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+DECIMAL [ (<a href="index.html#int">precisionInt</a>, <a
href="index.html#int">scaleInt</a>) ]
+</pre>
+syntax-end -->
+<p>Data type with fixed precision and scale. A user can specify precision and
scale by expression <code>DECIMAL</code>(precision,scale) in a <code>DDL</code>
statement, for example, <code>DECIMAL</code>(10,2). The maximum precision is 38
digits. Mapped to <code>java.math.BigDecimal</code>. The binary representation
is binary comparable, variable length format. When used in a row key, it is
terminated with a null byte unless it is the last column.</p>
+<p>Example:</p>
+<p class="notranslate">DECIMAL<br />DECIMAL(10,2)</p>
+
+<h3 id="boolean_type" class="notranslate">BOOLEAN Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+BOOLEAN
+</pre>
+<div name="railroad">
+<code class="c">BOOLEAN</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+BOOLEAN
+</pre>
+syntax-end -->
+<p>Possible values: <code>TRUE</code> and <code>FALSE</code>.</p><p>Mapped to
<code>java.lang.Boolean</code>. The binary representation is a single byte with
0 for false and 1 for true</p>
+<p>Example:</p>
+<p class="notranslate">BOOLEAN</p>
+
+<h3 id="time_type" class="notranslate">TIME Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+TIME
+</pre>
+<div name="railroad">
+<code class="c">TIME</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+TIME
+</pre>
+syntax-end -->
+<p>The time data type. The format is yyyy-<code>MM</code>-dd hh:mm:ss, with
both the date and time parts maintained. Mapped to <code>java.sql.Time</code>.
The binary representation is an 8 byte long (the number of milliseconds from
the epoch), making it possible (although not necessarily recommended) to store
more information within a <code>TIME</code> column than what is provided by
<code>java.sql.Time</code>. Note that the internal representation is based on a
number of milliseconds since the epoch (which is based on a time in
<code>GMT</code>), while <code>java.sql.Time</code> will format times based on
the client's local time zone. Please note that this <code>TIME</code> type
is different than the <code>TIME</code> type as defined by the SQL 92 standard
in that it includes year, month, and day components. As such, it is not in
compliance with the <code>JDBC APIs</code>. As the underlying data is still
stored as a long, only the presentation of the value is incorrect.</p>
+<p>Example:</p>
+<p class="notranslate">TIME</p>
+
+<h3 id="date_type" class="notranslate">DATE Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+DATE
+</pre>
+<div name="railroad">
+<code class="c">DATE</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+DATE
+</pre>
+syntax-end -->
+<p>The date data type. The format is yyyy-<code>MM</code>-dd hh:mm:ss, with
both the date and time parts maintained to a millisecond accuracy. Mapped to
<code>java.sql.Date</code>. The binary representation is an 8 byte long (the
number of milliseconds from the epoch), making it possible (although not
necessarily recommended) to store more information within a <code>DATE</code>
column than what is provided by <code>java.sql.Date</code>. Note that the
internal representation is based on a number of milliseconds since the epoch
(which is based on a time in <code>GMT</code>), while
<code>java.sql.Date</code> will format dates based on the client's local
time zone. Please note that this <code>DATE</code> type is different than the
<code>DATE</code> type as defined by the SQL 92 standard in that it includes a
time component. As such, it is not in compliance with the <code>JDBC
APIs</code>. As the underlying data is still stored as a long, only the
presentation of the value is incorre
ct.</p>
+<p>Example:</p>
+<p class="notranslate">DATE</p>
+
+<h3 id="timestamp_type" class="notranslate">TIMESTAMP Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+TIMESTAMP
+</pre>
+<div name="railroad">
+<code class="c">TIMESTAMP</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+TIMESTAMP
+</pre>
+syntax-end -->
+<p>The timestamp data type. The format is yyyy-<code>MM</code>-dd
hh:mm:ss[.nnnnnnnnn]. Mapped to <code>java.sql.Timestamp</code> with an
internal representation of the number of nanos from the epoch. The binary
representation is 12 bytes: an 8 byte long for the epoch time plus a 4 byte
integer for the nanos. Note that the internal representation is based on a
number of milliseconds since the epoch (which is based on a time in
<code>GMT</code>), while <code>java.sql.Timestamp</code> will format timestamps
based on the client's local time zone.</p>
+<p>Example:</p>
+<p class="notranslate">TIMESTAMP</p>
+
+<h3 id="unsigned_time_type" class="notranslate">UNSIGNED_TIME Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+UNSIGNED_TIME
+</pre>
+<div name="railroad">
+<code class="c">UNSIGNED_TIME</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+UNSIGNED_TIME
+</pre>
+syntax-end -->
+<p>The unsigned time data type. The format is yyyy-<code>MM</code>-dd
hh:mm:ss, with both the date and time parts maintained to the millisecond
accuracy. Mapped to <code>java.sql.Time</code>. The binary representation is an
8 byte long (the number of milliseconds from the epoch) matching the
<code>HBase.toBytes</code>(long) method. The purpose of this type is to map to
existing <code>HBase</code> data that was serialized using this
<code>HBase</code> utility method. If that is not the case, use the regular
signed type instead.</p>
+<p>Example:</p>
+<p class="notranslate">UNSIGNED_TIME</p>
+
+<h3 id="unsigned_date_type" class="notranslate">UNSIGNED_DATE Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+UNSIGNED_DATE
+</pre>
+<div name="railroad">
+<code class="c">UNSIGNED_DATE</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+UNSIGNED_DATE
+</pre>
+syntax-end -->
+<p>The unsigned date data type. The format is yyyy-<code>MM</code>-dd
hh:mm:ss, with both the date and time parts maintained to a millisecond
accuracy. Mapped to <code>java.sql.Date</code>. The binary representation is an
8 byte long (the number of milliseconds from the epoch) matching the
<code>HBase.toBytes</code>(long) method. The purpose of this type is to map to
existing <code>HBase</code> data that was serialized using this
<code>HBase</code> utility method. If that is not the case, use the regular
signed type instead.</p>
+<p>Example:</p>
+<p class="notranslate">UNSIGNED_DATE</p>
+
+<h3 id="unsigned_timestamp_type" class="notranslate">UNSIGNED_TIMESTAMP
Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+UNSIGNED_TIMESTAMP
+</pre>
+<div name="railroad">
+<code class="c">UNSIGNED_TIMESTAMP</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+UNSIGNED_TIMESTAMP
+</pre>
+syntax-end -->
+<p>The timestamp data type. The format is yyyy-<code>MM</code>-dd
hh:mm:ss[.nnnnnnnnn]. Mapped to <code>java.sql.Timestamp</code> with an
internal representation of the number of nanos from the epoch. The binary
representation is 12 bytes: an 8 byte long for the epoch time plus a 4 byte
integer for the nanos with the long serialized through the
<code>HBase.toBytes</code>(long) method. The purpose of this type is to map to
existing <code>HBase</code> data that was serialized using this
<code>HBase</code> utility method. If that is not the case, use the regular
signed type instead.</p>
+<p>Example:</p>
+<p class="notranslate">UNSIGNED_TIMESTAMP</p>
+
+<h3 id="varchar_type" class="notranslate">VARCHAR Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+VARCHAR [ ( <a href="index.html#int">precisionInt</a> ) ]
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code
class="c">VARCHAR</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">( <a href="index.html#int">precisionInt</a>
)</code></td></tr></table></td><td
class="le"></td></tr></table></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+VARCHAR [ ( <a href="index.html#int">precisionInt</a> ) ]
+</pre>
+syntax-end -->
+<p>A variable length String with an optional max byte length. The binary
representation is <code>UTF8</code> matching the <code>HBase</code>
Bytes.toBytes(String) method. When used in a row key, it is terminated with a
null byte unless it is the last column.</p><p>Mapped to
<code>java.lang.String</code>.</p>
+<p>Example:</p>
+<p class="notranslate">VARCHAR<br />VARCHAR(255)</p>
+
+<h3 id="char_type" class="notranslate">CHAR Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+CHAR ( <a href="index.html#int">precisionInt</a> )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code
class="c">CHAR ( <a href="index.html#int">precisionInt</a>
)</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+CHAR ( <a href="index.html#int">precisionInt</a> )
+</pre>
+syntax-end -->
+<p>A fixed length String with single-byte characters. The binary
representation is <code>UTF8</code> matching the <code>HBase</code>
Bytes.toBytes(String) method.</p><p>Mapped to <code>java.lang.String</code>.</p>
+<p>Example:</p>
+<p class="notranslate">CHAR(10)</p>
+
+<h3 id="binary_type" class="notranslate">BINARY Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+BINARY ( <a href="index.html#int">precisionInt</a> )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code
class="c">BINARY ( <a href="index.html#int">precisionInt</a>
)</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+BINARY ( <a href="index.html#int">precisionInt</a> )
+</pre>
+syntax-end -->
+<p>Raw fixed length byte array.</p><p>Mapped to <code>byte[]</code>.</p>
+<p>Example:</p>
+<p class="notranslate">BINARY</p>
+
+<h3 id="varbinary_type" class="notranslate">VARBINARY Type</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+VARBINARY
+</pre>
+<div name="railroad">
+<code class="c">VARBINARY</code>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+VARBINARY
+</pre>
+syntax-end -->
+<p>Raw variable length byte array.</p><p>Mapped to <code>byte[]</code>.</p>
+<p>Example:</p>
+<p class="notranslate">VARBINARY</p>
+
+<h3 id="array" class="notranslate">ARRAY</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+ARRAY [ '[' [ <a href="index.html#int">dimensionInt</a> ]
']' ]
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code
class="c">ARRAY</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">[</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"><a
href="index.html#int">dimensionInt</a></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
+<pre>
+ARRAY [ '[' [ <a href="index.html#int">dimensionInt</a> ]
']' ]
+</pre>
+syntax-end -->
+<p>Mapped to <code>java.sql.Array</code>. Every primitive type except for
<code>VARBINARY</code> may be declared as an <code>ARRAY</code>. Only single
dimensional arrays are supported.</p>
+<p>Example:</p>
+<p class="notranslate">VARCHAR ARRAY<br />CHAR(10) ARRAY [5]<br />INTEGER
[]<br />INTEGER [100]</p>
+
+<!-- [close] { -->
+
+<!-- } -->
</div>
</div>
</div>
