date:20240611

svn commit: r1918253 [4/4] - in /phoenix/site/publish: ./ language/

2024-06-11 Thread richardantal

Modified: phoenix/site/publish/metrics.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/metrics.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/metrics.html (original)
+++ phoenix/site/publish/metrics.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/multi-tenancy.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/multi-tenancy.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/multi-tenancy.html (original)
+++ phoenix/site/publish/multi-tenancy.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/namspace_mapping.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/namspace_mapping.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/namspace_mapping.html (original)
+++ phoenix/site/publish/namspace_mapping.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/news.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/news.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/news.html (original)
+++ phoenix/site/publish/news.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/omid.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/omid.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/omid.html (original)
+++ phoenix/site/publish/omid.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/paged.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/paged.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/paged.html (original)
+++ phoenix/site/publish/paged.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/performance.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/performance.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/performance.html (original)
+++ phoenix/site/publish/performance.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/pherf.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/pherf.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/pherf.html (original)
+++ phoenix/site/publish/pherf.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/phoenix_mr.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_mr.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/phoenix_mr.html (original)
+++ phoenix/site/publish/phoenix_mr.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/phoenix_on_emr.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_on_emr.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/phoenix_on_emr.html (original)
+++ phoenix/site/publish/phoenix_on_emr.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/phoenix_orm.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_orm.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/phoenix_orm.html (original)
+++ phoenix/site/publish/phoenix_orm.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/phoenix_python.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_python.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/phoenix_python.html (original)
+++ phoenix/site/publish/phoenix_python.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/phoenix_spark.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_spark.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/phoenix_spark.html (original)
+++ phoenix/site/publish/phoenix_spark.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modifi

svn commit: r1918253 [2/4] - in /phoenix/site/publish: ./ language/

2024-06-11 Thread richardantal

Modified: phoenix/site/publish/language/functions.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/language/functions.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/language/functions.html (original)
+++ phoenix/site/publish/language/functions.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 
@@ -169,7 +169,1908 @@

 
  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
+
+CURRENT_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 us

svn commit: r1918253 [1/4] - in /phoenix/site/publish: ./ language/

2024-06-11 Thread richardantal

Author: richardantal
Date: Tue Jun 11 10:38:38 2024
New Revision: 1918253

URL: http://svn.apache.org/viewvc?rev=1918253&view=rev
Log:
Generate grammer page

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/classpath_and_url.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=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/Phoenix-in-15-minutes-or-less.html (original)
+++ phoenix/site/publish/Phoenix-in-15-minutes-or-less.html Tue Jun 11 10:38:38 
2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/array_type.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/array_type.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/array_type.html (original)
+++ phoenix/site/publish/array_type.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/atomic_upsert.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/atomic_upsert.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/atomic_upsert.html (original)
+++ phoenix/site/publish/atomic_upsert.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/building.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/building.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/building.html (original)
+++ phoenix/site/publish/building.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 

Modified: phoenix/site/publish/building_website.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/building_website.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/building_website.html (original)
+++ phoenix/site/publish/building_website.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@

svn commit: r1918253 [3/4] - in /phoenix/site/publish: ./ language/

2024-06-11 Thread richardantal

Modified: phoenix/site/publish/language/index.html
URL: 
http://svn.apache.org/viewvc/phoenix/site/publish/language/index.html?rev=1918253&r1=1918252&r2=1918253&view=diff
==
--- phoenix/site/publish/language/index.html (original)
+++ phoenix/site/publish/language/index.html Tue Jun 11 10:38:38 2024
@@ -1,7 +1,7 @@
 
 
 
 
@@ -169,7 +169,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 ]
+
+
+selectStatement UNION ALL selectStatement ... ORDER BY order , ... LIMITbindParameter<
 /td>number OFFSETbindParameternumber <
 /td>ROWROWS FETCHFIRSTNEXTbindParameternumberROWROWSONLY
+
+
+
+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

svn commit: r1918253 [4/4] - in /phoenix/site/publish: ./ language/

svn commit: r1918253 [2/4] - in /phoenix/site/publish: ./ language/

svn commit: r1918253 [1/4] - in /phoenix/site/publish: ./ language/

svn commit: r1918253 [3/4] - in /phoenix/site/publish: ./ language/

4 matches

Site Navigation

Mail list logo

Footer information