svn commit: r1918253 [4/4] - in /phoenix/site/publish: ./ language/
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/
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/
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/
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