Modified: phoenix/site/publish/language/functions.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/functions.html?rev=1922071&r1=1922070&r2=1922071&view=diff ============================================================================== --- phoenix/site/publish/language/functions.html (original) +++ phoenix/site/publish/language/functions.html Mon Nov 25 08:36:43 2024 @@ -1,173 +1,167 @@ -<!DOCTYPE html> + + + <!doctype html> <!-- - Generated by Apache Maven Doxia at 2024-11-15 - Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin) +Generated by Apache Maven Doxia +, Rendered using Reflow Maven Skin 2.3.3 (http://devacfr.github.io/reflow-maven-skin) --> <html xml:lang="en" lang="en"> - <head> - <meta charset="UTF-8" /> - <title>Functions | Apache Phoenix</title> - <meta name="viewport" content="width=device-width, initial-scale=1.0" /> - <meta name="description" content="" /> - <meta http-equiv="content-language" content="en" /> - - <link href="//netdna.bootstrapcdn.com/bootswatch/2.3.2/flatly/bootstrap.min.css" rel="stylesheet" /> - <link href="//netdna.bootstrapcdn.com/twitter-bootstrap/2.3.1/css/bootstrap-responsive.min.css" rel="stylesheet" /> - <link href="../css/bootswatch.css" rel="stylesheet" /> - <link href="../css/reflow-skin.css" rel="stylesheet" /> - - <link href="//yandex.st/highlightjs/7.5/styles/default.min.css" rel="stylesheet" /> - - <link href="../css/lightbox.css" rel="stylesheet" /> - - <link href="../css/site.css" rel="stylesheet" /> - <link href="../css/print.css" rel="stylesheet" media="print" /> - - <!-- Le HTML5 shim, for IE6-8 support of HTML5 elements --> - <!--[if lt IE 9]> - <script src="http://html5shim.googlecode.com/svn/trunk/html5.js";></script> - <![endif]--> + <head> + <meta charset="UTF-8" /> + <title>Functions | Apache Phoenix</title> + <meta name="viewport" content="width=device-width, initial-scale=1.0" /> + <meta name="description" content="" /> + <meta http-equiv="content-language" content="en" /> -<link href="stylesheet.css" rel="stylesheet" /> - </head> + + + <link href="https://netdna.bootstrapcdn.com/bootswatch/4.4.1/flatly/bootstrap.min.css"; rel="stylesheet" /> + + + <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.12.1/css/all.css"; crossorigin="anonymous"> + + <link href="$resourcePath/css/reflow-skin.css" rel="stylesheet" /> - <body class="page-language-functions project-phoenix-site" data-spy="scroll" data-offset="60" data-target="#toc-scroll-target"> - <div class="navbar navbar-fixed-top"> - <div class="navbar-inner"> - <div class="container"> - <a class="btn btn-navbar" data-toggle="collapse" data-target="#top-nav-collapse"> - <span class="icon-bar"></span> - <span class="icon-bar"></span> - <span class="icon-bar"></span> - </a> - <a class="brand" href="index.html"><div class="xtoplogo"></div></a> - <div class="nav-collapse collapse" id="top-nav-collapse"> - <ul class="nav pull-right"> - <li class="dropdown"> - <a href="#" class="dropdown-toggle" data-toggle="dropdown">About <b class="caret"></b></a> - <ul class="dropdown-menu"> - <li ><a href="../index.html" title="Overview">Overview</a></li> - <li ><a href="../who_is_using.html" title="Who is Using">Who is Using</a></li> - <li ><a href="../recent.html" title="Recent Improvements">Recent Improvements</a></li> - <li ><a href="../roadmap.html" title="Roadmap">Roadmap</a></li> - <li ><a href="../news.html" title="News">News</a></li> - <li ><a href="../performance.html" title="Performance">Performance</a></li> - <li ><a href="../team.html" title="Team">Team</a></li> - <li ><a href="../tech_talks.html" title="Tech Talks">Tech Talks</a></li> - <li ><a href="../resources.html" title="Presentations">Presentations</a></li> - <li ><a href="../mailing_list.html" title="Mailing Lists">Mailing Lists</a></li> - <li ><a href="../source.html" title="Source Repository">Source Repository</a></li> - <li ><a href="../issues.html" title="Issue Tracking">Issue Tracking</a></li> - <li ><a href="../download.html" title="Download">Download</a></li> - <li ><a href="../installation.html" title="Installation">Installation</a></li> - <li class="divider"/> - <li ><a href="../contributing.html" title="How to Contribute">How to Contribute</a></li> - <li ><a href="../develop.html" title="How to Develop">How to Develop</a></li> - <li ><a href="../building_website.html" title="How to Update Website">How to Update Website</a></li> - <li ><a href="../release.html" title="How to Release">How to Release</a></li> - <li class="divider"/> - <li ><a href="http://www.apache.org/licenses/"; title="License" class="externalLink">License</a></li> - </ul> - </li> - <li class="dropdown"> - <a href="#" class="dropdown-toggle" data-toggle="dropdown">Using <b class="caret"></b></a> - <ul class="dropdown-menu"> - <li ><a href="../faq.html" title="F.A.Q.">F.A.Q.</a></li> - <li ><a href="../Phoenix-in-15-minutes-or-less.html" title="Quick Start">Quick Start</a></li> - <li ><a href="../building.html" title="Building">Building</a></li> - <li ><a href="../classpath_and_url.html" title="Client classpath and JDBC URL">Client classpath and JDBC URL</a></li> - <li ><a href="../tuning_guide.html" title="Tuning">Tuning</a></li> - <li ><a href="../explainplan.html" title="Explain Plan">Explain Plan</a></li> - <li ><a href="../tuning.html" title="Configuration">Configuration</a></li> - <li ><a href="../upgrading.html" title="Backward Compatibility">Backward Compatibility</a></li> - <li ><a href="../release_notes.html" title="Release Notes">Release Notes</a></li> - <li ><a href="../pherf.html" title="Performance Testing">Performance Testing</a></li> - <li class="divider"/> - <li ><a href="../phoenix_spark.html" title="Apache Spark Integration">Apache Spark Integration</a></li> - <li ><a href="../hive_storage_handler.html" title="Phoenix Storage Handler for Apache Hive">Phoenix Storage Handler for Apache Hive</a></li> - <li ><a href="../pig_integration.html" title="Apache Pig Integration">Apache Pig Integration</a></li> - <li ><a href="../phoenix_mr.html" title="Map Reduce Integration">Map Reduce Integration</a></li> - <li ><a href="../flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a></li> - <li ><a href="../kafka.html" title="Apache Kafka Plugin">Apache Kafka Plugin</a></li> - <li ><a href="../python.html" title="Python Driver">Python Driver</a></li> - </ul> - </li> - <li class="dropdown"> - <a href="#" class="dropdown-toggle" data-toggle="dropdown">Addons <b class="caret"></b></a> - <ul class="dropdown-menu"> - <li ><a href="http://docs.aws.amazon.com/ElasticMapReduce/latest/ReleaseGuide/emr-phoenix.html"; title="Phoenix on Amazon EMR" class="externalLink">Phoenix on Amazon EMR</a></li> - <li ><a href="http://python-phoenixdb.readthedocs.io/en/latest"; title="Phoenix Adapter for Python" class="externalLink">Phoenix Adapter for Python</a></li> - <li ><a href="../phoenix_orm.html" title="Phoenix ORM Library">Phoenix ORM Library</a></li> - <li ><a href="https://trino.io/docs/current/connector/phoenix.html"; title="Phoenix Connector for Trino" class="externalLink">Phoenix Connector for Trino</a></li> - <li ><a href="../omid.html" title="Apache Phoenix Omid Transaction Manager">Apache Phoenix Omid Transaction Manager</a></li> - <li ><a href="../tephra.html" title="Apache Phoenix Tephra Transaction Manager">Apache Phoenix Tephra Transaction Manager</a></li> - </ul> - </li> - <li class="dropdown"> - <a href="#" class="dropdown-toggle" data-toggle="dropdown">Features <b class="caret"></b></a> - <ul class="dropdown-menu"> - <li ><a href="../transactions.html" title="Transactions">Transactions</a></li> - <li ><a href="../udf.html" title="User-defined Functions">User-defined Functions</a></li> - <li class="divider"/> - <li ><a href="../secondary_indexing.html" title="Secondary Indexes">Secondary Indexes</a></li> - <li ><a href="../columnencoding.html" title="Storage Formats">Storage Formats</a></li> - <li ><a href="../atomic_upsert.html" title="Atomic Upsert">Atomic Upsert</a></li> - <li ><a href="../namspace_mapping.html" title="Namespace Mapping">Namespace Mapping</a></li> - <li ><a href="../update_statistics.html" title="Statistics Collection">Statistics Collection</a></li> - <li ><a href="../rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li> - <li ><a href="../paged.html" title="Paged Queries">Paged Queries</a></li> - <li ><a href="../salted.html" title="Salted Tables">Salted Tables</a></li> - <li ><a href="../skip_scan.html" title="Skip Scan">Skip Scan</a></li> - <li ><a href="../tablesample.html" title="Table Sampling">Table Sampling</a></li> - <li class="divider"/> - <li ><a href="../views.html" title="Views">Views</a></li> - <li ><a href="../multi-tenancy.html" title="Multi tenancy">Multi tenancy</a></li> - <li ><a href="../dynamic_columns.html" title="Dynamic Columns">Dynamic Columns</a></li> - <li class="divider"/> - <li ><a href="../bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li> - <li ><a href="../server.html" title="Query Server">Query Server</a></li> - <li ><a href="../metrics.html" title="Metrics">Metrics</a></li> - <li ><a href="../tracing.html" title="Tracing">Tracing</a></li> - <li ><a href="../cursors.html" title="Cursor">Cursor</a></li> - </ul> - </li> - <li class="dropdown"> - <a href="#" class="dropdown-toggle" data-toggle="dropdown">Reference <b class="caret"></b></a> - <ul class="dropdown-menu"> - <li ><a href="index.html" title="Grammar">Grammar</a></li> - <li class="active"><a href="" title="Functions">Functions</a></li> - <li ><a href="datatypes.html" title="Datatypes">Datatypes</a></li> - <li ><a href="../array_type.html" title="ARRAY type">ARRAY type</a></li> - <li class="divider"/> - <li ><a href="../sequences.html" title="Sequences">Sequences</a></li> - <li ><a href="../joins.html" title="Joins">Joins</a></li> - <li ><a href="../subqueries.html" title="Subqueries">Subqueries</a></li> - <li ><a href="../explainplan.html" title="Explain Plan">Explain Plan</a></li> - </ul> - </li> - </ul> - </div><!--/.nav-collapse --> - </div> - </div> - </div> - - <div class="container"> - - <!-- Masthead - ================================================== --> - - <header> - </header> - - <div class="main-body"> - <div class="row"> - <div class="span12"> - <div class="body-content"> -<div class="page-header"> + + <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/9.15.7/styles/default.min.css"; /> + + + <link href="$resourcePath/css/lightbox.css" rel="stylesheet" /> + <link href="$resourcePath/css/site.css" rel="stylesheet" /> + <link href="$resourcePath/css/print.css" rel="stylesheet" media="print" /> +<link href="stylesheet.css" rel="stylesheet" /> + </head> <!-- end : head --> +<body class="page-language-functions project-phoenix-site anchorjs-enabled scrolltop-smooth-enabled"> + <nav id="m-top-navbar" class="navbar navbar-expand-lg fixed-top navbar-light bg-light"> +<div class="container"> <a class="navbar-brand mb-0 h1" href="../index.html"> + <div class="xtoplogo"></div> + </a> + <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#top-navbar-collapse-1" aria-controls="top-navbar-collapse-1" aria-expanded="false" aria-label="Toggle navigation"> + <span class="navbar-toggler-icon"></span> + </button> + <div class="collapse navbar-collapse" id="top-navbar-collapse-1"> + <ul class="nav navbar-nav ml-auto"> + <li class="nav-item dropdown"> + <a href="#" class="nav-link dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">About <b class="caret"></b></a> + <div class="dropdown-menu"> + <a href="../index.html" title="Overview" class="dropdown-item ">Overview</a> + <a href="../who_is_using.html" title="Who is Using" class="dropdown-item ">Who is Using</a> + <a href="../recent.html" title="Recent Improvements" class="dropdown-item ">Recent Improvements</a> + <a href="../roadmap.html" title="Roadmap" class="dropdown-item ">Roadmap</a> + <a href="../news.html" title="News" class="dropdown-item ">News</a> + <a href="../performance.html" title="Performance" class="dropdown-item ">Performance</a> + <a href="../team.html" title="Team" class="dropdown-item ">Team</a> + <a href="../tech_talks.html" title="Tech Talks" class="dropdown-item ">Tech Talks</a> + <a href="../resources.html" title="Presentations" class="dropdown-item ">Presentations</a> + <a href="../mailing_list.html" title="Mailing Lists" class="dropdown-item ">Mailing Lists</a> + <a href="../source.html" title="Source Repository" class="dropdown-item ">Source Repository</a> + <a href="../issues.html" title="Issue Tracking" class="dropdown-item ">Issue Tracking</a> + <a href="../download.html" title="Download" class="dropdown-item ">Download</a> + <a href="../installation.html" title="Installation" class="dropdown-item ">Installation</a> + <a href="http:divider" title="" class="dropdown-item "></a> + <a href="../contributing.html" title="How to Contribute" class="dropdown-item ">How to Contribute</a> + <a href="../develop.html" title="How to Develop" class="dropdown-item ">How to Develop</a> + <a href="../building_website.html" title="How to Update Website" class="dropdown-item ">How to Update Website</a> + <a href="../release.html" title="How to Release" class="dropdown-item ">How to Release</a> + <a href="http:divider" title="" class="dropdown-item "></a> + <a href="http://www.apache.org/licenses/"; title="License" class="dropdown-item ">License</a> + </div> + </li> + <li class="nav-item dropdown"> + <a href="#" class="nav-link dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Using <b class="caret"></b></a> + <div class="dropdown-menu"> + <a href="../faq.html" title="F.A.Q." class="dropdown-item ">F.A.Q.</a> + <a href="../Phoenix-in-15-minutes-or-less.html" title="Quick Start" class="dropdown-item ">Quick Start</a> + <a href="../building.html" title="Building" class="dropdown-item ">Building</a> + <a href="../classpath_and_url.html" title="Client classpath and JDBC URL" class="dropdown-item ">Client classpath and JDBC URL</a> + <a href="../tuning_guide.html" title="Tuning" class="dropdown-item ">Tuning</a> + <a href="../explainplan.html" title="Explain Plan" class="dropdown-item ">Explain Plan</a> + <a href="../tuning.html" title="Configuration" class="dropdown-item ">Configuration</a> + <a href="../upgrading.html" title="Backward Compatibility" class="dropdown-item ">Backward Compatibility</a> + <a href="../release_notes.html" title="Release Notes" class="dropdown-item ">Release Notes</a> + <a href="../pherf.html" title="Performance Testing" class="dropdown-item ">Performance Testing</a> + <a href="http:divider" title="" class="dropdown-item "></a> + <a href="../phoenix_spark.html" title="Apache Spark Integration" class="dropdown-item ">Apache Spark Integration</a> + <a href="../hive_storage_handler.html" title="Phoenix Storage Handler for Apache Hive" class="dropdown-item ">Phoenix Storage Handler for Apache Hive</a> + <a href="../pig_integration.html" title="Apache Pig Integration" class="dropdown-item ">Apache Pig Integration</a> + <a href="../phoenix_mr.html" title="Map Reduce Integration" class="dropdown-item ">Map Reduce Integration</a> + <a href="../flume.html" title="Apache Flume Plugin" class="dropdown-item ">Apache Flume Plugin</a> + <a href="../kafka.html" title="Apache Kafka Plugin" class="dropdown-item ">Apache Kafka Plugin</a> + <a href="../python.html" title="Python Driver" class="dropdown-item ">Python Driver</a> + </div> + </li> + <li class="nav-item dropdown"> + <a href="#" class="nav-link dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Addons <b class="caret"></b></a> + <div class="dropdown-menu"> + <a href="http://docs.aws.amazon.com/ElasticMapReduce/latest/ReleaseGuide/emr-phoenix.html"; title="Phoenix on Amazon EMR" class="dropdown-item ">Phoenix on Amazon EMR</a> + <a href="http://python-phoenixdb.readthedocs.io/en/latest"; title="Phoenix Adapter for Python" class="dropdown-item ">Phoenix Adapter for Python</a> + <a href="../phoenix_orm.html" title="Phoenix ORM Library" class="dropdown-item ">Phoenix ORM Library</a> + <a href="https://trino.io/docs/current/connector/phoenix.html"; title="Phoenix Connector for Trino" class="dropdown-item ">Phoenix Connector for Trino</a> + <a href="../omid.html" title="Apache Phoenix Omid Transaction Manager" class="dropdown-item ">Apache Phoenix Omid Transaction Manager</a> + <a href="../tephra.html" title="Apache Phoenix Tephra Transaction Manager" class="dropdown-item ">Apache Phoenix Tephra Transaction Manager</a> + </div> + </li> + <li class="nav-item dropdown"> + <a href="#" class="nav-link dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Features <b class="caret"></b></a> + <div class="dropdown-menu"> + <a href="../transactions.html" title="Transactions" class="dropdown-item ">Transactions</a> + <a href="../udf.html" title="User-defined Functions" class="dropdown-item ">User-defined Functions</a> + <a href="http:divider" title="" class="dropdown-item "></a> + <a href="../secondary_indexing.html" title="Secondary Indexes" class="dropdown-item ">Secondary Indexes</a> + <a href="../columnencoding.html" title="Storage Formats" class="dropdown-item ">Storage Formats</a> + <a href="../atomic_upsert.html" title="Atomic Upsert" class="dropdown-item ">Atomic Upsert</a> + <a href="../namspace_mapping.html" title="Namespace Mapping" class="dropdown-item ">Namespace Mapping</a> + <a href="../update_statistics.html" title="Statistics Collection" class="dropdown-item ">Statistics Collection</a> + <a href="../rowtimestamp.html" title="Row Timestamp Column" class="dropdown-item ">Row Timestamp Column</a> + <a href="../paged.html" title="Paged Queries" class="dropdown-item ">Paged Queries</a> + <a href="../salted.html" title="Salted Tables" class="dropdown-item ">Salted Tables</a> + <a href="../skip_scan.html" title="Skip Scan" class="dropdown-item ">Skip Scan</a> + <a href="../tablesample.html" title="Table Sampling" class="dropdown-item ">Table Sampling</a> + <a href="http:divider" title="" class="dropdown-item "></a> + <a href="../views.html" title="Views" class="dropdown-item ">Views</a> + <a href="../multi-tenancy.html" title="Multi tenancy" class="dropdown-item ">Multi tenancy</a> + <a href="../dynamic_columns.html" title="Dynamic Columns" class="dropdown-item ">Dynamic Columns</a> + <a href="http:divider" title="" class="dropdown-item "></a> + <a href="../bulk_dataload.html" title="Bulk Loading" class="dropdown-item ">Bulk Loading</a> + <a href="../server.html" title="Query Server" class="dropdown-item ">Query Server</a> + <a href="../metrics.html" title="Metrics" class="dropdown-item ">Metrics</a> + <a href="../tracing.html" title="Tracing" class="dropdown-item ">Tracing</a> + <a href="../cursors.html" title="Cursor" class="dropdown-item ">Cursor</a> + </div> + </li> + <li class="nav-item dropdown"> + <a href="#" class="nav-link dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Reference <b class="caret"></b></a> + <div class="dropdown-menu"> + <a href="index.html" title="Grammar" class="dropdown-item ">Grammar</a> + <a href="" title="Functions" class="dropdown-item active">Functions</a> + <a href="datatypes.html" title="Datatypes" class="dropdown-item ">Datatypes</a> + <a href="../array_type.html" title="ARRAY type" class="dropdown-item ">ARRAY type</a> + <a href="http:divider" title="" class="dropdown-item "></a> + <a href="../sequences.html" title="Sequences" class="dropdown-item ">Sequences</a> + <a href="../joins.html" title="Joins" class="dropdown-item ">Joins</a> + <a href="../subqueries.html" title="Subqueries" class="dropdown-item ">Subqueries</a> + <a href="../explainplan.html" title="Explain Plan" class="dropdown-item ">Explain Plan</a> + </div> + </li> + </ul><!--/ul.navbar-nav --> + </div><!--/.nav-collapse --> +</div> <!--/.container --> </nav> <!--/.navbar --> +<div class="main-body"> + <div class="header " role="main"> + <div class="container container-fluid"> + + </div> + </div> <!-- end : header --> + + <div class="row mt-5"> + <div class="d-xs-none d-sm-none d-md-none d-lg-block col-lg-2"> + </div> + <main class="col-xs-12 col-sm-12 col-md-12 col-lg-12 col-xl-8" role="main"> + <div class="page-header"> <h1>Functions</h1> </div> @@ -2071,277 +2065,592 @@ syntax-end --> <!-- [close] { --> <!-- } --> - </div> - </div> - </div> - </div> - - </div><!-- /container --> - - <!-- Footer - ================================================== --> - <footer class="well"> - <div class="container"> - <div class="row"> - <div class="span2 bottom-nav"> - <ul class="nav nav-list"> - <li class="nav-header">About</li> - <li > - <a href="../index.html" title="Overview">Overview</a> - </li> - <li > - <a href="../who_is_using.html" title="Who is Using">Who is Using</a> - </li> - <li > - <a href="../recent.html" title="Recent Improvements">Recent Improvements</a> - </li> - <li > - <a href="../roadmap.html" title="Roadmap">Roadmap</a> - </li> - <li > - <a href="../news.html" title="News">News</a> - </li> - <li > - <a href="../performance.html" title="Performance">Performance</a> - </li> - <li > - <a href="../team.html" title="Team">Team</a> - </li> - <li > - <a href="../tech_talks.html" title="Tech Talks">Tech Talks</a> - </li> - <li > - <a href="../resources.html" title="Presentations">Presentations</a> - </li> - <li > - <a href="../mailing_list.html" title="Mailing Lists">Mailing Lists</a> - </li> - <li > - <a href="../source.html" title="Source Repository">Source Repository</a> - </li> - <li > - <a href="../issues.html" title="Issue Tracking">Issue Tracking</a> - </li> - <li > - <a href="../download.html" title="Download">Download</a> - </li> - <li > - <a href="../installation.html" title="Installation">Installation</a> - </li> - <li > - <a href="http:divider" title=""></a> - </li> - <li > - <a href="../contributing.html" title="How to Contribute">How to Contribute</a> - </li> - <li > - <a href="../develop.html" title="How to Develop">How to Develop</a> - </li> - <li > - <a href="../building_website.html" title="How to Update Website">How to Update Website</a> - </li> - <li > - <a href="../release.html" title="How to Release">How to Release</a> - </li> - <li > - <a href="http:divider" title=""></a> - </li> - <li > - <a href="http://www.apache.org/licenses/"; title="License" class="externalLink">License</a> - </li> - </ul> - </div> - <div class="span2 bottom-nav"> - <ul class="nav nav-list"> - <li class="nav-header">Using</li> - <li > - <a href="../faq.html" title="F.A.Q.">F.A.Q.</a> - </li> - <li > - <a href="../Phoenix-in-15-minutes-or-less.html" title="Quick Start">Quick Start</a> - </li> - <li > - <a href="../building.html" title="Building">Building</a> - </li> - <li > - <a href="../classpath_and_url.html" title="Client classpath and JDBC URL">Client classpath and JDBC URL</a> - </li> - <li > - <a href="../tuning_guide.html" title="Tuning">Tuning</a> - </li> - <li > - <a href="../explainplan.html" title="Explain Plan">Explain Plan</a> - </li> - <li > - <a href="../tuning.html" title="Configuration">Configuration</a> - </li> - <li > - <a href="../upgrading.html" title="Backward Compatibility">Backward Compatibility</a> - </li> - <li > - <a href="../release_notes.html" title="Release Notes">Release Notes</a> - </li> - <li > - <a href="../pherf.html" title="Performance Testing">Performance Testing</a> - </li> - <li > - <a href="http:divider" title=""></a> - </li> - <li > - <a href="../phoenix_spark.html" title="Apache Spark Integration">Apache Spark Integration</a> - </li> - <li > - <a href="../hive_storage_handler.html" title="Phoenix Storage Handler for Apache Hive">Phoenix Storage Handler for Apache Hive</a> - </li> - <li > - <a href="../pig_integration.html" title="Apache Pig Integration">Apache Pig Integration</a> - </li> - <li > - <a href="../phoenix_mr.html" title="Map Reduce Integration">Map Reduce Integration</a> - </li> - <li > - <a href="../flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a> - </li> - <li > - <a href="../kafka.html" title="Apache Kafka Plugin">Apache Kafka Plugin</a> - </li> - <li > - <a href="../python.html" title="Python Driver">Python Driver</a> - </li> - </ul> - </div> - <div class="span2 bottom-nav"> - <ul class="nav nav-list"> - <li class="nav-header">Features</li> - <li > - <a href="../transactions.html" title="Transactions">Transactions</a> - </li> - <li > - <a href="../udf.html" title="User-defined Functions">User-defined Functions</a> - </li> - <li > - <a href="http:divider" title=""></a> - </li> - <li > - <a href="../secondary_indexing.html" title="Secondary Indexes">Secondary Indexes</a> - </li> - <li > - <a href="../columnencoding.html" title="Storage Formats">Storage Formats</a> - </li> - <li > - <a href="../atomic_upsert.html" title="Atomic Upsert">Atomic Upsert</a> - </li> - <li > - <a href="../namspace_mapping.html" title="Namespace Mapping">Namespace Mapping</a> - </li> - <li > - <a href="../update_statistics.html" title="Statistics Collection">Statistics Collection</a> - </li> - <li > - <a href="../rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a> - </li> - <li > - <a href="../paged.html" title="Paged Queries">Paged Queries</a> - </li> - <li > - <a href="../salted.html" title="Salted Tables">Salted Tables</a> - </li> - <li > - <a href="../skip_scan.html" title="Skip Scan">Skip Scan</a> - </li> - <li > - <a href="../tablesample.html" title="Table Sampling">Table Sampling</a> - </li> - <li > - <a href="http:divider" title=""></a> - </li> - <li > - <a href="../views.html" title="Views">Views</a> - </li> - <li > - <a href="../multi-tenancy.html" title="Multi tenancy">Multi tenancy</a> - </li> - <li > - <a href="../dynamic_columns.html" title="Dynamic Columns">Dynamic Columns</a> - </li> - <li > - <a href="http:divider" title=""></a> - </li> - <li > - <a href="../bulk_dataload.html" title="Bulk Loading">Bulk Loading</a> - </li> - <li > - <a href="../server.html" title="Query Server">Query Server</a> - </li> - <li > - <a href="../metrics.html" title="Metrics">Metrics</a> - </li> - <li > - <a href="../tracing.html" title="Tracing">Tracing</a> - </li> - <li > - <a href="../cursors.html" title="Cursor">Cursor</a> - </li> - </ul> - </div> - <div class="span3 bottom-nav"> - <ul class="nav nav-list"> - <li class="nav-header">Reference</li> - <li > - <a href="index.html" title="Grammar">Grammar</a> - </li> - <li class="active"> - <a href="#" title="Functions">Functions</a> - </li> - <li > - <a href="datatypes.html" title="Datatypes">Datatypes</a> - </li> - <li > - <a href="../array_type.html" title="ARRAY type">ARRAY type</a> - </li> - <li > - <a href="http:divider" title=""></a> - </li> - <li > - <a href="../sequences.html" title="Sequences">Sequences</a> - </li> - <li > - <a href="../joins.html" title="Joins">Joins</a> - </li> - <li > - <a href="../subqueries.html" title="Subqueries">Subqueries</a> - </li> - <li > - <a href="../explainplan.html" title="Explain Plan">Explain Plan</a> - </li> - </ul> - </div> - </div> - </div> - </footer> - - <div class="container subfooter"> - <div class="row"> - <div class="span12"> - <p class="pull-right"><a href="#">Back to top</a></p> - <p class="copyright">Copyright ©2024 <a href="http://www.apache.org";>Apache Software Foundation</a>. All Rights Reserved.</p> - </div> - </div> - </div> - - <!-- Le javascript - ================================================== --> - <!-- Placed at the end of the document so the pages load faster --> - <script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script> - - <script src="//netdna.bootstrapcdn.com/twitter-bootstrap/2.3.2/js/bootstrap.min.js"></script> - <script src="../js/lightbox.js"></script> - <script src="../js/jquery.smooth-scroll.min.js"></script> - <!-- back button support for smooth scroll --> - <script src="../js/jquery.ba-bbq.min.js"></script> - <script src="//yandex.st/highlightjs/7.5/highlight.min.js"></script> - - <script src="../js/reflow-skin.js"></script> - - </body> + </main> + <div class="d-none d-sm-none d-md-none d-lg-none d-xl-block col-xl-2"> + </div> + </div> <!-- row: end --> +</div> <!-- .main-body: end --> + <div id="m_scrolltop" class="m-scrolltop"> + <i class="fa fa-arrow-up"></i> + </div> + <!-- Footer --> +<footer class="footer-light bg-light"> + <div class="container"> + <div class="row"> + <div class="col bottom-nav"> + <ul class="nav flex-column nav-list"> + <li class="nav-header"> +About + </li> + + + + + <li class="nav-item "><a href="../index.html" title="Overview" class="nav-link" >Overview</a> + +</li> + + + + + <li class="nav-item "><a href="../who_is_using.html" title="Who is Using" class="nav-link" >Who is Using</a> + +</li> + + + + + <li class="nav-item "><a href="../recent.html" title="Recent Improvements" class="nav-link" >Recent Improvements</a> + +</li> + + + + + <li class="nav-item "><a href="../roadmap.html" title="Roadmap" class="nav-link" >Roadmap</a> + +</li> + + + + + <li class="nav-item "><a href="../news.html" title="News" class="nav-link" >News</a> + +</li> + + + + + <li class="nav-item "><a href="../performance.html" title="Performance" class="nav-link" >Performance</a> + +</li> + + + + + <li class="nav-item "><a href="../team.html" title="Team" class="nav-link" >Team</a> + +</li> + + + + + <li class="nav-item "><a href="../tech_talks.html" title="Tech Talks" class="nav-link" >Tech Talks</a> + +</li> + + + + + <li class="nav-item "><a href="../resources.html" title="Presentations" class="nav-link" >Presentations</a> + +</li> + + + + + <li class="nav-item "><a href="../mailing_list.html" title="Mailing Lists" class="nav-link" >Mailing Lists</a> + +</li> + + + + + <li class="nav-item "><a href="../source.html" title="Source Repository" class="nav-link" >Source Repository</a> + +</li> + + + + + <li class="nav-item "><a href="../issues.html" title="Issue Tracking" class="nav-link" >Issue Tracking</a> + +</li> + + + + + <li class="nav-item "><a href="../download.html" title="Download" class="nav-link" >Download</a> + +</li> + + + + + <li class="nav-item "><a href="../installation.html" title="Installation" class="nav-link" >Installation</a> + +</li> + + + + + <li class="nav-item "><a href="http:divider" class="nav-link" ></a> + +</li> + + + + + <li class="nav-item "><a href="../contributing.html" title="How to Contribute" class="nav-link" >How to Contribute</a> + +</li> + + + + + <li class="nav-item "><a href="../develop.html" title="How to Develop" class="nav-link" >How to Develop</a> + +</li> + + + + + <li class="nav-item "><a href="../building_website.html" title="How to Update Website" class="nav-link" >How to Update Website</a> + +</li> + + + + + <li class="nav-item "><a href="../release.html" title="How to Release" class="nav-link" >How to Release</a> + +</li> + + + + + <li class="nav-item "><a href="http:divider" class="nav-link" ></a> + +</li> + + + + + <li class="nav-item "><a href="http://www.apache.org/licenses/"; title="License" class="externalLink nav-link" >License</a> + +</li> + + + + </ul> + + </div> + <div class="col bottom-nav"> + <ul class="nav flex-column nav-list"> + <li class="nav-header"> +Using + </li> + + + + + <li class="nav-item "><a href="../faq.html" title="F.A.Q." class="nav-link" >F.A.Q.</a> + +</li> + + + + + <li class="nav-item "><a href="../Phoenix-in-15-minutes-or-less.html" title="Quick Start" class="nav-link" >Quick Start</a> + +</li> + + + + + <li class="nav-item "><a href="../building.html" title="Building" class="nav-link" >Building</a> + +</li> + + + + + <li class="nav-item "><a href="../classpath_and_url.html" title="Client classpath and JDBC URL" class="nav-link" >Client classpath and JDBC URL</a> + +</li> + + + + + <li class="nav-item "><a href="../tuning_guide.html" title="Tuning" class="nav-link" >Tuning</a> + +</li> + + + + + <li class="nav-item "><a href="../explainplan.html" title="Explain Plan" class="nav-link" >Explain Plan</a> + +</li> + + + + + <li class="nav-item "><a href="../tuning.html" title="Configuration" class="nav-link" >Configuration</a> + +</li> + + + + + <li class="nav-item "><a href="../upgrading.html" title="Backward Compatibility" class="nav-link" >Backward Compatibility</a> + +</li> + + + + + <li class="nav-item "><a href="../release_notes.html" title="Release Notes" class="nav-link" >Release Notes</a> + +</li> + + + + + <li class="nav-item "><a href="../pherf.html" title="Performance Testing" class="nav-link" >Performance Testing</a> + +</li> + + + + + <li class="nav-item "><a href="http:divider" class="nav-link" ></a> + +</li> + + + + + <li class="nav-item "><a href="../phoenix_spark.html" title="Apache Spark Integration" class="nav-link" >Apache Spark Integration</a> + +</li> + + + + + <li class="nav-item "><a href="../hive_storage_handler.html" title="Phoenix Storage Handler for Apache Hive" class="nav-link" >Phoenix Storage Handler for Apache Hive</a> + +</li> + + + + + <li class="nav-item "><a href="../pig_integration.html" title="Apache Pig Integration" class="nav-link" >Apache Pig Integration</a> + +</li> + + + + + <li class="nav-item "><a href="../phoenix_mr.html" title="Map Reduce Integration" class="nav-link" >Map Reduce Integration</a> + +</li> + + + + + <li class="nav-item "><a href="../flume.html" title="Apache Flume Plugin" class="nav-link" >Apache Flume Plugin</a> + +</li> + + + + + <li class="nav-item "><a href="../kafka.html" title="Apache Kafka Plugin" class="nav-link" >Apache Kafka Plugin</a> + +</li> + + + + + <li class="nav-item "><a href="../python.html" title="Python Driver" class="nav-link" >Python Driver</a> + +</li> + + + + </ul> + + </div> + <div class="col bottom-nav"> + <ul class="nav flex-column nav-list"> + <li class="nav-header"> +Features + </li> + + + + + <li class="nav-item "><a href="../transactions.html" title="Transactions" class="nav-link" >Transactions</a> + +</li> + + + + + <li class="nav-item "><a href="../udf.html" title="User-defined Functions" class="nav-link" >User-defined Functions</a> + +</li> + + + + + <li class="nav-item "><a href="http:divider" class="nav-link" ></a> + +</li> + + + + + <li class="nav-item "><a href="../secondary_indexing.html" title="Secondary Indexes" class="nav-link" >Secondary Indexes</a> + +</li> + + + + + <li class="nav-item "><a href="../columnencoding.html" title="Storage Formats" class="nav-link" >Storage Formats</a> + +</li> + + + + + <li class="nav-item "><a href="../atomic_upsert.html" title="Atomic Upsert" class="nav-link" >Atomic Upsert</a> + +</li> + + + + + <li class="nav-item "><a href="../namspace_mapping.html" title="Namespace Mapping" class="nav-link" >Namespace Mapping</a> + +</li> + + + + + <li class="nav-item "><a href="../update_statistics.html" title="Statistics Collection" class="nav-link" >Statistics Collection</a> + +</li> + + + + + <li class="nav-item "><a href="../rowtimestamp.html" title="Row Timestamp Column" class="nav-link" >Row Timestamp Column</a> + +</li> + + + + + <li class="nav-item "><a href="../paged.html" title="Paged Queries" class="nav-link" >Paged Queries</a> + +</li> + + + + + <li class="nav-item "><a href="../salted.html" title="Salted Tables" class="nav-link" >Salted Tables</a> + +</li> + + + + + <li class="nav-item "><a href="../skip_scan.html" title="Skip Scan" class="nav-link" >Skip Scan</a> + +</li> + + + + + <li class="nav-item "><a href="../tablesample.html" title="Table Sampling" class="nav-link" >Table Sampling</a> + +</li> + + + + + <li class="nav-item "><a href="http:divider" class="nav-link" ></a> + +</li> + + + + + <li class="nav-item "><a href="../views.html" title="Views" class="nav-link" >Views</a> + +</li> + + + + + <li class="nav-item "><a href="../multi-tenancy.html" title="Multi tenancy" class="nav-link" >Multi tenancy</a> + +</li> + + + + + <li class="nav-item "><a href="../dynamic_columns.html" title="Dynamic Columns" class="nav-link" >Dynamic Columns</a> + +</li> + + + + + <li class="nav-item "><a href="http:divider" class="nav-link" ></a> + +</li> + + + + + <li class="nav-item "><a href="../bulk_dataload.html" title="Bulk Loading" class="nav-link" >Bulk Loading</a> + +</li> + + + + + <li class="nav-item "><a href="../server.html" title="Query Server" class="nav-link" >Query Server</a> + +</li> + + + + + <li class="nav-item "><a href="../metrics.html" title="Metrics" class="nav-link" >Metrics</a> + +</li> + + + + + <li class="nav-item "><a href="../tracing.html" title="Tracing" class="nav-link" >Tracing</a> + +</li> + + + + + <li class="nav-item "><a href="../cursors.html" title="Cursor" class="nav-link" >Cursor</a> + +</li> + + + + </ul> + + </div> + <div class="col bottom-nav"> + <ul class="nav flex-column nav-list"> + <li class="nav-header"> +Reference + </li> + + + + + <li class="nav-item "><a href="index.html" title="Grammar" class="nav-link" >Grammar</a> + +</li> + + + + + <li class="nav-item active"><a title="Functions" class="nav-link" >Functions</a> + +</li> + + + + + <li class="nav-item "><a href="datatypes.html" title="Datatypes" class="nav-link" >Datatypes</a> + +</li> + + + + + <li class="nav-item "><a href="../array_type.html" title="ARRAY type" class="nav-link" >ARRAY type</a> + +</li> + + + + + <li class="nav-item "><a href="http:divider" class="nav-link" ></a> + +</li> + + + + + <li class="nav-item "><a href="../sequences.html" title="Sequences" class="nav-link" >Sequences</a> + +</li> + + + + + <li class="nav-item "><a href="../joins.html" title="Joins" class="nav-link" >Joins</a> + +</li> + + + + + <li class="nav-item "><a href="../subqueries.html" title="Subqueries" class="nav-link" >Subqueries</a> + +</li> + + + + + <li class="nav-item "><a href="../explainplan.html" title="Explain Plan" class="nav-link" >Explain Plan</a> + +</li> + + + + </ul> + + </div> + + + </div> <!-- END: .row --> + </div> <!-- END: .container --> +</footer> + <div class="container subfooter text-center"> + <div class="row"> + <div class="col-md-12"> + <p class="copyright">Copyright © +2024 + + <a href="http://www.apache.org";>Apache Software Foundation</a> + + + +. All Rights Reserved.</p> + + + + </div> + </div> + </div> + + <!-- Le javascript + ================================================== --> + <!-- Placed at the end of the document so the pages load faster --> + <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"; crossorigin="anonymous"></script> + <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd//popper.min.js"; crossorigin="anonymous"></script> + <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js"; crossorigin="anonymous"></script> + + <script src="$resourcePath/js/lightbox.min.js" crossorigin="anonymous"></script> + <script src="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/9.15.7/highlight.min.js"; crossorigin="anonymous"></script> + <script src="$resourcePath/js/reflow-skin.js" crossorigin="anonymous"></script> + <script src="https://cdnjs.cloudflare.com/ajax/libs/anchor-js/3.2.2/anchor.min.js"; crossorigin="anonymous"></script> + </body> </html>
