You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@phoenix.apache.org by mu...@apache.org on 2015/10/24 00:31:39 UTC
svn commit: r1710289 [1/3] - in /phoenix:
phoenix-docs/src/docsrc/html/datatypes.html
site/publish/language/datatypes.html site/publish/language/functions.html
site/publish/language/index.html
Author: mujtaba
Date: Fri Oct 23 22:31:39 2015
New Revision: 1710289
URL: http://svn.apache.org/viewvc?rev=1710289&view=rev
Log:
Revert datatypes.html
Modified:
phoenix/phoenix-docs/src/docsrc/html/datatypes.html
phoenix/site/publish/language/datatypes.html
phoenix/site/publish/language/functions.html
phoenix/site/publish/language/index.html
Modified: phoenix/phoenix-docs/src/docsrc/html/datatypes.html
URL: http://svn.apache.org/viewvc/phoenix/phoenix-docs/src/docsrc/html/datatypes.html?rev=1710289&r1=1710288&r2=1710289&view=diff
==============================================================================
--- phoenix/phoenix-docs/src/docsrc/html/datatypes.html (original)
+++ phoenix/phoenix-docs/src/docsrc/html/datatypes.html Fri Oct 23 22:31:39 2015
@@ -1,49 +1,60 @@
-<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
-<html>
-<head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <meta http-equiv="Content-Style-Type" content="text/css">
- <title>Data Types</title>
- <meta name="Generator" content="Cocoa HTML Writer">
- <meta name="CocoaVersion" content="1265.21">
- <style type="text/css">
- p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Times; color: #0000ee}
- p.p4 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Times}
- p.p5 {margin: 0.0px 0.0px 12.0px 0.0px; font: 12.0px Times}
- span.s1 {text-decoration: underline}
- td.td1 {width: 212.0px; margin: 0.5px 0.5px 0.5px 0.5px; padding: 1.0px 1.0px 1.0px 1.0px}
- td.td2 {width: 66.0px; margin: 0.5px 0.5px 0.5px 0.5px; padding: 1.0px 1.0px 1.0px 1.0px}
- </style>
-</head>
-<body>
-<table cellspacing="0" cellpadding="0">
- <tbody>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
+<head><meta http-equiv="Content-Type" content="text/html;charset=utf-8" /><title>
+Data Types
+</title><link rel="stylesheet" type="text/css" href="stylesheet.css" />
+<!-- [search] { -->
+<script type="text/javascript" src="navigation.js"></script>
+</head><body>
+<table class="content"><tr class="content"><td class="content"><div class="contentDiv">
+<!-- } -->
+<h2 id="dataTypes">Index</h2>
+<!-- syntax-start
+<p class="notranslate">
+<c:forEach var="item" items="dataTypes">
+ <a href="#${item.link}" >${item.topic}</a><br />
+</c:forEach>
+</p>
+syntax-end -->
+<!-- railroad-start -->
+<table class="notranslate index">
<tr>
- <td valign="middle" class="td1">
- <h2 style="margin: 0.0px 0.0px 14.9px 0.0px; font: 18.0px Times"><b>Index</b></h2>
- <table cellspacing="0" cellpadding="0">
- <tbody>
- <tr>
- <td valign="middle" class="td2">
- <p class="p2"><span class="s1">${item.topic}</span></p>
- </td>
- <td valign="middle" class="td2">
- <p class="p2"><span class="s1">${item.topic}</span></p>
- </td>
- <td valign="middle" class="td2">
- <p class="p2"><span class="s1">${item.topic}</span></p>
- </td>
- </tr>
- </tbody>
- </table>
- <h3 style="margin: 0.0px 0.0px 14.0px 0.0px; font: 14.0px Times"><b>${item.topic}</b></h3>
- <p class="p4">${item.railroad}</p>
- <p class="p5">${item.text}</p>
- <p class="p5">Example:</p>
- <p class="p5">${item.example}</p>
- </td>
+ <td class="index">
+ <c:forEach var="item" items="dataTypes-0">
+ <a href="#${item.link}" >${item.topic}</a><br />
+ </c:forEach>
+ </td><td class="index">
+ <c:forEach var="item" items="dataTypes-1">
+ <a href="#${item.link}" >${item.topic}</a><br />
+ </c:forEach>
+ </td><td class="index">
+ <c:forEach var="item" items="dataTypes-2">
+ <a href="#${item.link}" >${item.topic}</a><br />
+ </c:forEach>
+ </td>
</tr>
- </tbody>
</table>
-</body>
-</html>
+<!-- railroad-end -->
+
+<c:forEach var="item" items="dataTypes">
+<h3 id="${item.link}" class="notranslate">${item.topic}</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+${item.syntax}
+</pre>
+<div name="railroad">
+${item.railroad}
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+${item.syntax}
+</pre>
+syntax-end -->
+<p>${item.text}</p>
+<p>Example:</p>
+<p class="notranslate">${item.example}</p>
+</c:forEach>
+
+<!-- [close] { --></div></td></tr></table><!-- } --></body></html>
+
Modified: phoenix/site/publish/language/datatypes.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/datatypes.html?rev=1710289&r1=1710288&r2=1710289&view=diff
==============================================================================
--- phoenix/site/publish/language/datatypes.html (original)
+++ phoenix/site/publish/language/datatypes.html Fri Oct 23 22:31:39 2015
@@ -142,7 +142,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: -9223372036854775807 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.</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.</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>