svn commit: r1860964 [1/3] - in /phoenix/site/publish/language: datatypes.html functions.html index.html

2019-06-10 Thread elserj
Author: elserj
Date: Mon Jun 10 16:37:05 2019
New Revision: 1860964

URL: http://svn.apache.org/viewvc?rev=1860964=rev
Log:
Regenerating broken docs

Modified:
phoenix/site/publish/language/datatypes.html
phoenix/site/publish/language/functions.html
phoenix/site/publish/language/index.html

Modified: phoenix/site/publish/language/datatypes.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/language/datatypes.html?rev=1860964=1860963=1860964=diff
==
--- phoenix/site/publish/language/datatypes.html (original)
+++ phoenix/site/publish/language/datatypes.html Mon Jun 10 16:37:05 2019
@@ -1,7 +1,7 @@
 
 
 
 
@@ -165,7 +165,579 @@

 
  Data Types
-update_here
+
+
+
+Index
+
+
+
+
+
+
+INTEGER Type
+
+UNSIGNED_INT Type
+
+BIGINT Type
+
+UNSIGNED_LONG Type
+
+TINYINT Type
+
+UNSIGNED_TINYINT Type
+
+SMALLINT Type
+
+UNSIGNED_SMALLINT 
Type
+
+FLOAT Type
+
+
+UNSIGNED_FLOAT Type
+
+DOUBLE Type
+
+UNSIGNED_DOUBLE Type
+
+DECIMAL Type
+
+BOOLEAN Type
+
+TIME Type
+
+DATE Type
+
+TIMESTAMP Type
+
+UNSIGNED_TIME Type
+
+
+UNSIGNED_DATE Type
+
+UNSIGNED_TIMESTAMP 
Type
+
+VARCHAR Type
+
+CHAR Type
+
+BINARY Type
+
+VARBINARY Type
+
+ARRAY
+
+
+
+
+
+
+INTEGER Type
+
+
+INTEGER
+
+
+INTEGER
+
+
+
+Possible values: -2147483648 to 2147483647.Mapped to 
java.lang.Integer. The binary representation is a 4 byte integer 
with the sign bit flipped (so that negative values sorts before positive 
values).
+Example:
+INTEGER
+
+UNSIGNED_INT Type
+
+
+UNSIGNED_INT
+
+
+UNSIGNED_INT
+
+
+
+Possible values: 0 to 2147483647. Mapped to java.lang.Integer. 
The binary representation is a 4 byte integer, matching the HBase 
Bytes.toBytes(int) method. The purpose of this type is to map to existing 
HBase data that was serialized using this HBase 
utility method. If that is not the case, use the regular signed type 
instead.
+Example:
+UNSIGNED_INT
+
+BIGINT Type
+
+
+BIGINT
+
+
+BIGINT
+
+
+
+Possible values: -9223372036854775808 to 9223372036854775807. Mapped to 
java.lang.Long. The binary representation is an 8 byte long with 
the sign bit flipped (so that negative values sorts before positive values).
+Example:
+BIGINT
+
+UNSIGNED_LONG Type
+
+
+UNSIGNED_LONG
+
+
+UNSIGNED_LONG
+
+
+
+Possible values: 0 to 9223372036854775807. Mapped to 
java.lang.Long. The binary representation is an 8 byte integer, 
matching the HBase Bytes.toBytes(long) method. The purpose of this 
type is to map to existing HBase data that was serialized using 
this HBase utility method. If that is not the case, use the 
regular signed type instead.
+Example:
+UNSIGNED_LONG
+
+TINYINT Type
+
+
+TINYINT
+
+
+TINYINT
+
+
+
+Possible values: -128 to 127. Mapped to java.lang.Byte. The 
binary representation is a single byte, with the sign bit flipped (so that 
negative values sorts before positive values).
+Example:
+TINYINT
+
+UNSIGNED_TINYINT Type
+
+
+UNSIGNED_TINYINT
+
+
+UNSIGNED_TINYINT
+
+
+
+Possible values: 0 to 127. Mapped to java.lang.Byte. The 
binary representation is a single byte, matching the HBase 
Bytes.toBytes(byte) method. The purpose of this type is to map to existing 
HBase data that was serialized using this HBase 
utility method. If that is not the case, use the regular signed type 
instead.
+Example:
+UNSIGNED_TINYINT
+
+SMALLINT Type
+
+
+SMALLINT
+
+
+SMALLINT
+
+
+
+Possible values: -32768 to 32767. Mapped to java.lang.Short. 
The binary representation is a 2 byte short with the sign bit flipped (so that 
negative values sort before positive values).
+Example:
+SMALLINT
+
+UNSIGNED_SMALLINT Type
+
+
+UNSIGNED_SMALLINT
+
+
+UNSIGNED_SMALLINT
+
+
+
+Possible values: 0 to 32767. Mapped to java.lang.Short. The 
binary representation is an 2 byte integer, matching the HBase 
Bytes.toBytes(short) method. The purpose of this type is to map to existing 
HBase data that was serialized using this HBase 
utility method. If that is not the case, use the regular signed type 
instead.
+Example:
+UNSIGNED_SMALLINT
+
+FLOAT Type
+
+
+FLOAT
+
+
+FLOAT
+
+
+
+Possible values: -3.402823466 E + 38 to 3.402823466 E + 38. Mapped to 
java.lang.Float. The binary representation is an 4 

svn commit: r1860964 [2/3] - in /phoenix/site/publish/language: datatypes.html functions.html index.html

2019-06-10 Thread elserj
Modified: phoenix/site/publish/language/functions.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/language/functions.html?rev=1860964=1860963=1860964=diff
==
--- phoenix/site/publish/language/functions.html (original)
+++ phoenix/site/publish/language/functions.html Mon Jun 10 16:37:05 2019
@@ -1,7 +1,7 @@
 
 
 
 
@@ -165,7 +165,1886 @@

 
  Functions
-update_here
+
+
+
+Aggregate Functions
+
+
+
+
+
+
+AVG
+
+COUNT
+
+APPROX_COUNT_DISTINCT
+
+MAX
+
+MIN
+
+SUM
+
+
+PERCENTILE_CONT
+
+PERCENTILE_DISC
+
+PERCENT_RANK
+
+FIRST_VALUE
+
+LAST_VALUE
+
+FIRST_VALUES
+
+
+LAST_VALUES
+
+NTH_VALUE
+
+STDDEV_POP
+
+STDDEV_SAMP
+
+
+
+
+
+String Functions
+
+
+
+
+
+
+SUBSTR
+
+INSTR
+
+TRIM
+
+LTRIM
+
+RTRIM
+
+
+LPAD
+
+LENGTH
+
+REGEXP_SUBSTR
+
+REGEXP_REPLACE
+
+REGEXP_SPLIT
+
+
+UPPER
+
+LOWER
+
+REVERSE
+
+TO_CHAR
+
+COLLATION_KEY
+
+
+
+
+
+Time and Date Functions
+
+
+
+
+
+
+TO_DATE
+
+TO_TIME
+
+TO_TIMESTAMP
+
+CURRENT_TIME
+
+CONVERT_TZ
+
+TIMEZONE_OFFSET
+
+
+NOW
+
+YEAR
+
+MONTH
+
+WEEK
+
+DAYOFYEAR
+
+DAYOFMONTH
+
+
+DAYOFWEEK
+
+HOUR
+
+MINUTE
+
+SECOND
+
+
+
+
+
+Numeric Functions
+
+
+
+
+
+
+ROUND
+
+CEIL
+
+
+FLOOR
+
+TRUNC
+
+
+TO_NUMBER
+
+RAND
+
+
+
+
+
+Array Functions
+
+
+
+
+
+
+ARRAY_ELEM
+
+ARRAY_LENGTH
+
+ARRAY_APPEND
+
+
+ARRAY_PREPEND
+
+ARRAY_CAT
+
+ARRAY_FILL
+
+
+ARRAY_TO_STRING
+
+ANY
+
+ALL
+
+
+
+
+
+Math Functions
+
+
+
+
+
+
+SIGN
+
+ABS
+
+SQRT
+
+
+CBRT
+
+EXP
+
+POWER
+
+
+LN
+
+LOG
+
+
+
+
+
+Other Functions
+
+
+
+
+
+
+MD5
+
+INVERT
+
+ENCODE
+
+DECODE
+
+
+COALESCE
+
+GET_BIT
+
+GET_BYTE
+
+OCTET_LENGTH
+
+
+SET_BIT
+
+SET_BYTE
+
+
+
+
+
+
+
+AVG
+
+
+AVG ( { numericTerm } )
+
+
+AVG 
( numericTerm )
+
+
+
+The average (mean) value. If no rows are selected, the result is 
NULL. Aggregates are only allowed in select statements. The 
returned value is of the same data type as the parameter.
+Example:
+AVG(X)
+
+COUNT
+
+
+COUNT( [ DISTINCT ] { * | { term } } )
+
+
+COUNT (DISTINCT*term)
+
+
+
+The count of all row, or of the non-null values. This method returns a 
long. When DISTINCT is used, it counts only distinct values. If no 
rows are 

svn commit: r1860964 [3/3] - in /phoenix/site/publish/language: datatypes.html functions.html index.html

2019-06-10 Thread elserj
Modified: phoenix/site/publish/language/index.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/language/index.html?rev=1860964=1860963=1860964=diff
==
--- phoenix/site/publish/language/index.html (original)
+++ phoenix/site/publish/language/index.html Mon Jun 10 16:37:05 2019
@@ -1,7 +1,7 @@
 
 
 
 
@@ -165,7 +165,1678 @@

 
  Grammar
-update_here
+
+
+
+Commands
+
+
+
+
+
+
+SELECT
+
+UPSERT VALUES
+
+UPSERT SELECT
+
+DELETE
+
+DECLARE CURSOR
+
+OPEN CURSOR
+
+FETCH NEXT
+
+CLOSE
+
+CREATE TABLE
+
+
+DROP TABLE
+
+CREATE FUNCTION
+
+DROP FUNCTION
+
+CREATE VIEW
+
+DROP VIEW
+
+CREATE SEQUENCE
+
+DROP SEQUENCE
+
+ALTER
+
+CREATE INDEX
+
+
+DROP INDEX
+
+ALTER INDEX
+
+EXPLAIN
+
+UPDATE STATISTICS
+
+CREATE SCHEMA
+
+USE
+
+DROP SCHEMA
+
+GRANT
+
+REVOKE
+
+
+
+
+
+Other Grammar
+
+
+
+
+
+
+Constraint
+
+Options
+
+Hint
+
+Scan Hint
+
+Cache Hint
+
+Index Hint
+
+Small Hint
+
+Seek To Column Hint
+
+Join Hint
+
+Serial Hint
+
+Column Def
+
+Table Ref
+
+Sequence Ref
+
+Column Ref
+
+Select Expression
+
+Select Statement
+
+Split Point
+
+Table Spec
+
+Aliased Table Ref
+
+
+Join Type
+
+Func Argument
+
+Class Name
+
+Jar Path
+
+Order
+
+Expression
+
+And Condition
+
+Boolean Condition
+
+Condition
+
+RHS Operand
+
+Operand
+
+Summand
+
+Factor
+
+Term
+
+Array Constructor
+
+Sequence
+
+Cast
+
+Row Value Constructor
+
+Bind Parameter
+
+
+Value
+
+Case
+
+Case When
+
+Name
+
+Quoted Name
+
+Alias
+
+Null
+
+Data Type
+
+SQL Data Type
+
+HBase Data Type
+
+String
+
+Boolean
+
+Numeric
+
+Int
+
+Long
+
+Decimal
+
+Number
+
+Comments
+
+
+
+
+
+
+SELECT
+
+
+selectStatement [ { UNION ALL selectStatement [...] } ]
+[ ORDER BY order [,...] ] [ LIMIT {bindParameter | number} ]
+[ OFFSET {bindParameter | number} [ ROW | ROWS ] ] [ FETCH { FIRST | NEXT } 
{bindParameter | number} { ROW | ROWS } ONLY ]
+
+
+selectStatementUNION ALL selectStatement...ORDER BY order, ...LIMITbindParameter<
 /td>numberOFFSETbindParameternumber<
 /td>ROWROWSFETCHFIRSTNEXTbindParameternumberROWROWSONLY
+
+
+
+Selects data from one or more tables. UNION ALL combines rows 
from multiple select statements. ORDER BY sorts the result based 
on the given expressions. LIMIT(or FETCH FIRST) 
limits the number of rows returned by the query with no limit applied if 
unspecified or specified as null or less than zero. The LIMIT(or 
FETCH FIRST) clause is executed after the ORDER BY 
clause to support top-N 

Build failed in Jenkins: Phoenix Compile Compatibility with HBase #1024

2019-06-10 Thread Apache Jenkins Server
See 


--
Started by timer
[EnvInject] - Loading node environment variables.
Building remotely on H37 (ubuntu xenial) in workspace 

[Phoenix_Compile_Compat_wHBase] $ /bin/bash /tmp/jenkins7168600293506713964.sh
core file size  (blocks, -c) 0
data seg size   (kbytes, -d) unlimited
scheduling priority (-e) 0
file size   (blocks, -f) unlimited
pending signals (-i) 386431
max locked memory   (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files  (-n) 6
pipe size(512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority  (-r) 0
stack size  (kbytes, -s) 8192
cpu time   (seconds, -t) unlimited
max user processes  (-u) 10240
virtual memory  (kbytes, -v) unlimited
file locks  (-x) unlimited
core id : 0
core id : 1
core id : 2
core id : 3
core id : 4
core id : 5
physical id : 0
physical id : 1
MemTotal:   98963744 kB
MemFree:47812408 kB
Filesystem  Size  Used Avail Use% Mounted on
udev 48G 0   48G   0% /dev
tmpfs   9.5G  930M  8.6G  10% /run
/dev/sda3   3.6T  464G  3.0T  14% /
tmpfs48G 0   48G   0% /dev/shm
tmpfs   5.0M 0  5.0M   0% /run/lock
tmpfs48G 0   48G   0% /sys/fs/cgroup
/dev/sda2   473M  236M  213M  53% /boot
tmpfs   9.5G  4.0K  9.5G   1% /run/user/910
tmpfs   9.5G 0  9.5G   0% /run/user/1000
/dev/loop9   90M   90M 0 100% /snap/core/6673
/dev/loop7   54M   54M 0 100% /snap/lxd/10526
/dev/loop12  54M   54M 0 100% /snap/lxd/10601
/dev/loop1   57M   57M 0 100% /snap/snapcraft/2832
/dev/loop8   90M   90M 0 100% /snap/core/6818
/dev/loop10  57M   57M 0 100% /snap/snapcraft/2900
/dev/loop13  55M   55M 0 100% /snap/lxd/10756
/dev/loop3   89M   89M 0 100% /snap/core/6964
/dev/loop5   57M   57M 0 100% /snap/snapcraft/2947
apache-maven-2.2.1
apache-maven-3.0.4
apache-maven-3.0.5
apache-maven-3.1.1
apache-maven-3.2.1
apache-maven-3.2.5
apache-maven-3.3.3
apache-maven-3.3.9
apache-maven-3.5.0
apache-maven-3.5.2
apache-maven-3.5.4
apache-maven-3.6.0
latest
latest2
latest3


===
Verifying compile level compatibility with HBase 0.98 with Phoenix 
4.x-HBase-0.98
===

Cloning into 'hbase'...
Switched to a new branch '0.98'
Branch 0.98 set up to track remote branch 0.98 from origin.
[ERROR] Plugin org.codehaus.mojo:findbugs-maven-plugin:2.5.2 or one of its 
dependencies could not be resolved: Failed to read artifact descriptor for 
org.codehaus.mojo:findbugs-maven-plugin:jar:2.5.2: Could not transfer artifact 
org.codehaus.mojo:findbugs-maven-plugin:pom:2.5.2 from/to central 
(https://repo.maven.apache.org/maven2): Received fatal alert: protocol_version 
-> [Help 1]
[ERROR] 
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e 
switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR] 
[ERROR] For more information about the errors and possible solutions, please 
read the following articles:
[ERROR] [Help 1] 
http://cwiki.apache.org/confluence/display/MAVEN/PluginResolutionException
Build step 'Execute shell' marked build as failure


Jenkins build is back to normal : Phoenix-4.x-HBase-1.5 #26

2019-06-10 Thread Apache Jenkins Server
See 



Apache-Phoenix | 4.x-HBase-1.3 | Build Successful

2019-06-10 Thread Apache Jenkins Server
4.x-HBase-1.3 branch build status Successful

Source repository https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=shortlog;h=refs/heads/4.x-HBase-1.3

Compiled Artifacts https://builds.apache.org/job/Phoenix-4.x-HBase-1.3/lastSuccessfulBuild/artifact/

Test Report https://builds.apache.org/job/Phoenix-4.x-HBase-1.3/lastCompletedBuild/testReport/

Changes
No changes


Build times for last couple of runsLatest build time is the right most | Legend blue: normal, red: test failure, gray: timeout


Build failed in Jenkins: Phoenix-4.x-HBase-1.3 #422

2019-06-10 Thread Apache Jenkins Server
See 


Changes:

[larsh] PHOENIX-5327 Disable PherfMainIT.

--
[...truncated 115.02 KB...]
[INFO] Tests run: 10, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 94.774 
s - in org.apache.phoenix.end2end.RegexBulkLoadToolIT
[INFO] Running 
org.apache.phoenix.end2end.SysTableNamespaceMappedStatsCollectorIT
[INFO] Running org.apache.phoenix.end2end.SystemCatalogIT
[INFO] Running org.apache.phoenix.end2end.TableSnapshotReadsMapReduceIT
[INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 42.264 s 
- in org.apache.phoenix.end2end.TableSnapshotReadsMapReduceIT
[INFO] Running org.apache.phoenix.end2end.UpdateCacheAcrossDifferentClientsIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 108.799 
s - in org.apache.phoenix.end2end.SystemCatalogIT
[INFO] Tests run: 18, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 198.537 
s - in org.apache.phoenix.end2end.StatsEnabledSplitSystemCatalogIT
[INFO] Running org.apache.phoenix.end2end.UserDefinedFunctionsIT
[INFO] Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 109.34 s 
- in org.apache.phoenix.end2end.UpdateCacheAcrossDifferentClientsIT
[WARNING] Tests run: 42, Failures: 0, Errors: 0, Skipped: 6, Time elapsed: 
246.728 s - in 
org.apache.phoenix.end2end.SysTableNamespaceMappedStatsCollectorIT
[INFO] Running org.apache.phoenix.end2end.index.ImmutableIndexIT
[INFO] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 370.457 
s - in org.apache.phoenix.end2end.SplitIT
[INFO] Running 
org.apache.phoenix.end2end.index.IndexRebuildIncrementDisableCountIT
[INFO] Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 15.537 s 
- in org.apache.phoenix.end2end.index.IndexRebuildIncrementDisableCountIT
[INFO] Running org.apache.phoenix.end2end.index.LocalIndexIT
[INFO] Running org.apache.phoenix.end2end.index.MutableIndexFailureIT
[INFO] Tests run: 16, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 168.525 
s - in org.apache.phoenix.end2end.UserDefinedFunctionsIT
[INFO] Running 
org.apache.phoenix.end2end.index.MutableIndexFailureWithNamespaceIT
[INFO] Running org.apache.phoenix.end2end.index.MutableIndexRebuilderIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 85.806 s 
- in org.apache.phoenix.end2end.index.MutableIndexRebuilderIT
[INFO] Running org.apache.phoenix.end2end.index.MutableIndexReplicationIT
[INFO] Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 206.23 s 
- in org.apache.phoenix.end2end.index.MutableIndexFailureWithNamespaceIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 39.265 s 
- in org.apache.phoenix.end2end.index.MutableIndexReplicationIT
[INFO] Tests run: 14, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 292.164 
s - in org.apache.phoenix.end2end.index.MutableIndexFailureIT
[INFO] Running org.apache.phoenix.end2end.index.PartialIndexRebuilderIT
[INFO] Running org.apache.phoenix.end2end.index.PhoenixMRJobSubmitterIT
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 11.467 s 
- in org.apache.phoenix.end2end.index.PhoenixMRJobSubmitterIT
[WARNING] Tests run: 45, Failures: 0, Errors: 0, Skipped: 18, Time elapsed: 
460.853 s - in org.apache.phoenix.end2end.index.ImmutableIndexIT
[INFO] Running org.apache.phoenix.end2end.index.txn.TxWriteFailureIT
[INFO] Running org.apache.phoenix.end2end.join.SortMergeJoinNoSpoolingIT
[INFO] Running org.apache.phoenix.execute.PartialCommitIT
[INFO] Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 92.081 
s - in org.apache.phoenix.end2end.index.txn.TxWriteFailureIT
[INFO] Running org.apache.phoenix.execute.UpsertSelectOverlappingBatchesIT
[ERROR] Tests run: 12, Failures: 0, Errors: 6, Skipped: 0, Time elapsed: 148.53 
s <<< FAILURE! - in org.apache.phoenix.execute.PartialCommitIT
[ERROR] 
testOrderOfMutationsIsPredicatable[PartialCommitIT_transactionProvider=OMID](org.apache.phoenix.execute.PartialCommitIT)
  Time elapsed: 14.323 s  <<< ERROR!
org.apache.phoenix.exception.PhoenixIOException: java.lang.NullPointerException
at 
org.apache.phoenix.execute.PartialCommitIT.testPartialCommit(PartialCommitIT.java:258)
at 
org.apache.phoenix.execute.PartialCommitIT.testOrderOfMutationsIsPredicatable(PartialCommitIT.java:200)
Caused by: java.util.concurrent.ExecutionException: 
java.lang.NullPointerException
at 
org.apache.phoenix.execute.PartialCommitIT.testPartialCommit(PartialCommitIT.java:258)
at 
org.apache.phoenix.execute.PartialCommitIT.testOrderOfMutationsIsPredicatable(PartialCommitIT.java:200)
Caused by: java.lang.NullPointerException

[ERROR] 
testNoFailure[PartialCommitIT_transactionProvider=OMID](org.apache.phoenix.execute.PartialCommitIT)
  Time elapsed: 9.272 s  <<< ERROR!
java.lang.NullPointerException
at