You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@phoenix.apache.org by el...@apache.org on 2018/08/28 18:34:05 UTC
svn commit: r1839492 - in /phoenix/site: publish/language/datatypes.html
publish/language/functions.html publish/language/index.html
publish/tuning.html source/src/site/markdown/tuning.md
Author: elserj
Date: Tue Aug 28 18:34:05 2018
New Revision: 1839492
URL: http://svn.apache.org/viewvc?rev=1839492&view=rev
Log:
PHOENIX-4873 Update tuning doc with time and timestamp format config properties
Modified:
phoenix/site/publish/language/datatypes.html
phoenix/site/publish/language/functions.html
phoenix/site/publish/language/index.html
phoenix/site/publish/tuning.html
phoenix/site/source/src/site/markdown/tuning.md
Modified: phoenix/site/publish/language/datatypes.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/datatypes.html?rev=1839492&r1=1839491&r2=1839492&view=diff
==============================================================================
--- phoenix/site/publish/language/datatypes.html (original)
+++ phoenix/site/publish/language/datatypes.html Tue Aug 28 18:34:05 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2018-08-08
+ Generated by Apache Maven Doxia at 2018-08-28
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/language/functions.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/functions.html?rev=1839492&r1=1839491&r2=1839492&view=diff
==============================================================================
--- phoenix/site/publish/language/functions.html (original)
+++ phoenix/site/publish/language/functions.html Tue Aug 28 18:34:05 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2018-08-08
+ Generated by Apache Maven Doxia at 2018-08-28
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/language/index.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/index.html?rev=1839492&r1=1839491&r2=1839492&view=diff
==============================================================================
--- phoenix/site/publish/language/index.html (original)
+++ phoenix/site/publish/language/index.html Tue Aug 28 18:34:05 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2018-08-08
+ Generated by Apache Maven Doxia at 2018-08-28
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/tuning.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/tuning.html?rev=1839492&r1=1839491&r2=1839492&view=diff
==============================================================================
--- phoenix/site/publish/tuning.html (original)
+++ phoenix/site/publish/tuning.html Tue Aug 28 18:34:05 2018
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2018-06-10
+ Generated by Apache Maven Doxia at 2018-08-28
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -260,8 +260,8 @@
</tr>
<tr class="a">
<td><small>phoenix.query.dateFormat</small></td>
- <td style="text-align: left;">Default pattern to use for conversion of a date to/from a string, whether through the <tt>TO_CHAR(<date>)</tt> or <tt>TO_DATE(<date-string>)</tt> functions, or through <tt>resultSet.getString(<date-column>)</tt>. Default is yyyy-MM-dd HH:mm:ss</td>
- <td>yyyy-MM-dd HH:mm:ss</td>
+ <td style="text-align: left;">Default pattern to use for conversion of a date to/from a string, whether through the <tt>TO_CHAR(<date>)</tt> or <tt>TO_DATE(<date-string>)</tt> functions, or through <tt>resultSet.getString(<date-column>)</tt>. Default is yyyy-MM-dd HH:mm:ss.SSS</td>
+ <td>yyyy-MM-dd HH:mm:ss.SSS</td>
</tr>
<tr class="b">
<td><small>phoenix.query.dateFormatTimeZone</small></td>
@@ -269,6 +269,16 @@
<td>GMT</td>
</tr>
<tr class="a">
+ <td><small>phoenix.query.timeFormat</small></td>
+ <td style="text-align: left;">Default pattern to use for conversion of TIME to/from a string, whether through the <tt>TO_CHAR(<time>)</tt> or <tt>TO_TIME(<time-string>)</tt> functions, or through <tt>resultSet.getString(<time-column>)</tt>. Default is yyyy-MM-dd HH:mm:ss.SSS</td>
+ <td>yyyy-MM-dd HH:mm:ss.SSS</td>
+ </tr>
+ <tr class="b">
+ <td><small>phoenix.query.timestampFormat</small></td>
+ <td style="text-align: left;">Default pattern to use for conversion of TIMESTAMP to/from a string, whether through the <tt>TO_CHAR(<timestamp>)</tt> or <tt>TO_TIMESTAMP(<timestamp-string>)</tt> functions, or through <tt>resultSet.getString(<timestamp-column>)</tt>. Default is yyyy-MM-dd HH:mm:ss.SSS</td>
+ <td>yyyy-MM-dd HH:mm:ss.SSS</td>
+ </tr>
+ <tr class="a">
<td><small>phoenix.query.numberFormat</small></td>
<td style="text-align: left;">Default pattern to use for conversion of a decimal number to/from a string, whether through the <tt>TO_CHAR(<decimal-number>)</tt> or <tt>TO_NUMBER(<decimal-string>)</tt> functions, or through <tt>resultSet.getString(<decimal-column>)</tt>. Default is #,##0.###</td>
<td>#,##0.###</td>
Modified: phoenix/site/source/src/site/markdown/tuning.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/tuning.md?rev=1839492&r1=1839491&r2=1839492&view=diff
==============================================================================
--- phoenix/site/source/src/site/markdown/tuning.md (original)
+++ phoenix/site/source/src/site/markdown/tuning.md Tue Aug 28 18:34:05 2018
@@ -78,8 +78,18 @@ any one tenant is allowed to consume. Af
for conversion of a date to/from a string, whether through the
<code>TO_CHAR(<date>)</code> or
<code>TO_DATE(<date-string>)</code> functions, or through
-<code>resultSet.getString(<date-column>)</code>. Default is yyyy-MM-dd HH:mm:ss</td><td>yyyy-MM-dd HH:mm:ss</td></tr>
+<code>resultSet.getString(<date-column>)</code>. Default is yyyy-MM-dd HH:mm:ss.SSS</td><td>yyyy-MM-dd HH:mm:ss.SSS</td></tr>
<tr><td><small>phoenix.query.dateFormatTimeZone</small></td><td style="text-align: left;">A timezone id that specifies the default time zone in which date, time, and timestamp literals should be interpreted when interpreting string literals or using the <code>TO_DATE</code> function. A time zone id can be a timezone abbreviation such as "PST", or a full name such as "America/Los_Angeles", or a custom offset such as "GMT-9:00". The time zone id "LOCAL" can also be used to interpret all date, time, and timestamp literals as being in the current timezone of the client.</td><td>GMT</td></tr>
+<tr><td><small>phoenix.query.timeFormat</small></td><td style="text-align: left;">Default pattern to use
+ for conversion of TIME to/from a string, whether through the
+ <code>TO_CHAR(<time>)</code> or
+<code>TO_TIME(<time-string>)</code> functions, or through
+<code>resultSet.getString(<time-column>)</code>. Default is yyyy-MM-dd HH:mm:ss.SSS</td><td>yyyy-MM-dd HH:mm:ss.SSS</td></tr>
+<tr><td><small>phoenix.query.timestampFormat</small></td><td style="text-align: left;">Default pattern to use
+ for conversion of TIMESTAMP to/from a string, whether through the
+ <code>TO_CHAR(<timestamp>)</code> or
+<code>TO_TIMESTAMP(<timestamp-string>)</code> functions, or through
+<code>resultSet.getString(<timestamp-column>)</code>. Default is yyyy-MM-dd HH:mm:ss.SSS</td><td>yyyy-MM-dd HH:mm:ss.SSS</td></tr>
<tr><td><small>phoenix.query.numberFormat</small></td><td style="text-align: left;">Default pattern to use
for conversion of a decimal number to/from a string, whether through the
<code>TO_CHAR(<decimal-number>)</code> or