342/genindex.html



<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta charset="utf-8" />
  <meta name="viewport" content="width=device-width,initial-scale=1">
  <meta http-equiv="x-ua-compatible" content="ie=edge">
  <meta name="lang:clipboard.copy" content="Copy to clipboard">
  <meta name="lang:clipboard.copied" content="Copied to clipboard">
  <meta name="lang:search.language" content="en">
  <meta name="lang:search.pipeline.stopwords" content="True">
  <meta name="lang:search.pipeline.trimmer" content="True">
  <meta name="lang:search.result.none" content="No matching documents">
  <meta name="lang:search.result.one" content="1 matching document">
  <meta name="lang:search.result.other" content="# matching documents">
  <meta name="lang:search.tokenizer" content="[\s\-]+">

  
    <link href="https://fonts.gstatic.com/" rel="preconnect" crossorigin>
    <link href="https://fonts.googleapis.com/css?family=Roboto+Mono:400,500,700|Roboto:300,400,400i,700&display=fallback" rel="stylesheet">

    <style>
      body,
      input {
        font-family: "Roboto", "Helvetica Neue", Helvetica, Arial, sans-serif
      }

      code,
      kbd,
      pre {
        font-family: "Roboto Mono", "Courier New", Courier, monospace
      }
    </style>
  

  <link rel="stylesheet" href="_static/stylesheets/application.css"/>
  <link rel="stylesheet" href="_static/stylesheets/application-palette.css"/>
  <link rel="stylesheet" href="_static/stylesheets/application-fixes.css"/>
  
  <link rel="stylesheet" href="_static/fonts/material-icons.css"/>
  
  <meta name="theme-color" content="2196f3">
  <script src="_static/javascripts/modernizr.js"></script>
  
  
    <title>Index &#8212; Presto 342 Documentation</title>
    <link rel="stylesheet" href="_static/material.css" type="text/css" />
    <link rel="stylesheet" href="_static/pygments.css" type="text/css" />
    <link rel="stylesheet" type="text/css" href="_static/presto.css" />
    <script id="documentation_options" data-url_root="./" src="_static/documentation_options.js"></script>
    <script src="_static/jquery.js"></script>
    <script src="_static/underscore.js"></script>
    <script src="_static/doctools.js"></script>
    <script src="_static/language_data.js"></script>
    <link rel="index" title="Index" href="#" />
    <link rel="search" title="Search" href="search.html" />
  
   
    <script async src="https://www.googletagmanager.com/gtag/js?id=UA-133457846-1"></script>
    <script>
      window.dataLayer = window.dataLayer || [];
      function gtag(){dataLayer.push(arguments);}
      gtag('js', new Date());
      gtag('config', 'UA-133457846-1');
    </script>
  </head>
  <body dir=ltr
        data-md-color-primary=blue-grey data-md-color-accent=light-blue>
  
  <svg class="md-svg">
    <defs data-children-count="0">
      
      <svg xmlns="http://www.w3.org/2000/svg" width="416" height="448" viewBox="0 0 416 448" id="__github"><path fill="currentColor" d="M160 304q0 10-3.125 20.5t-10.75 19T128 352t-18.125-8.5-10.75-19T96 304t3.125-20.5 10.75-19T128 256t18.125 8.5 10.75 19T160 304zm160 0q0 10-3.125 20.5t-10.75 19T288 352t-18.125-8.5-10.75-19T256 304t3.125-20.5 10.75-19T288 256t18.125 8.5 10.75 19T320 304zm40 0q0-30-17.25-51T296 232q-10.25 0-48.75 5.25Q229.5 240 208 240t-39.25-2.75Q130.75 232 120 232q-29.5 0-46.75 21T56 304q0 22 8 38.375t20.25 25.75 30.5 15 35 7.375 37.25 1.75h42q20.5 0 37.25-1.75t35-7.375 30.5-15 20.25-25.75T360 304zm56-44q0 51.75-15.25 82.75-9.5 19.25-26.375 33.25t-35.25 21.5-42.5 11.875-42.875 5.5T212 416q-19.5 0-35.5-.75t-36.875-3.125-38.125-7.5-34.25-12.875T37 371.5t-21.5-28.75Q0 312 0 260q0-59.25 34-99-6.75-20.5-6.75-42.5 0-29 12.75-54.5 27 0 47.5 9.875t47.25 30.875Q171.5 96 212 96q37 0 70 8 26.25-20.5 46.75-30.25T376 64q12.75 25.5 12.75 54.5 0 21.75-6.75 42 34 40 34 99.5z"/></svg>
      
    </defs>
  </svg>
  
  <input class="md-toggle" data-md-toggle="drawer" type="checkbox" id="__drawer">
  <input class="md-toggle" data-md-toggle="search" type="checkbox" id="__search">
  <label class="md-overlay" data-md-component="overlay" for="__drawer"></label>
  <a href="#genindex" tabindex="1" class="md-skip"> Skip to content </a>
  <header class="md-header" data-md-component="header">
  <nav class="md-header-nav md-grid">
    <div class="md-flex navheader">
      <div class="md-flex__cell md-flex__cell--shrink">
        <a href="index.html" title="Presto 342 Documentation"
           class="md-header-nav__button md-logo">
          
              <img src="_static/presto.svg" height="26"
                   alt="Presto 342 Documentation logo">
          
        </a>
      </div>
      <div class="md-flex__cell md-flex__cell--shrink">
        <label class="md-icon md-icon--menu md-header-nav__button" for="__drawer"></label>
      </div>
      <div class="md-flex__cell md-flex__cell--stretch">
        <div class="md-flex__ellipsis md-header-nav__title" data-md-component="title">
          <span class="md-header-nav__topic">Presto 342 Documentation</span>
          <span class="md-header-nav__topic"> Index </span>
        </div>
      </div>
      <div class="md-flex__cell md-flex__cell--shrink">
        <label class="md-icon md-icon--search md-header-nav__button" for="__search"></label>
        
<div class="md-search" data-md-component="search" role="dialog">
  <label class="md-search__overlay" for="__search"></label>
  <div class="md-search__inner" role="search">
    <form class="md-search__form" action="search.html" method="GET" name="search">
      <input type="text" class="md-search__input" name="q" placeholder="Search"
             autocapitalize="off" autocomplete="off" spellcheck="false"
             data-md-component="query" data-md-state="active">
      <label class="md-icon md-search__icon" for="__search"></label>
      <button type="reset" class="md-icon md-search__icon" data-md-component="reset" tabindex="-1">
        &#xE5CD;
      </button>
    </form>
    <div class="md-search__output">
      <div class="md-search__scrollwrap" data-md-scrollfix>
        <div class="md-search-result" data-md-component="result">
          <div class="md-search-result__meta">
            Type to start searching
          </div>
          <ol class="md-search-result__list"></ol>
        </div>
      </div>
    </div>
  </div>
</div>

      </div>
      
        <div class="md-flex__cell md-flex__cell--shrink">
          <div class="md-header-nav__source">
            <a href="https://github.com/prestosql/presto" title="Go to repository" class="md-source" data-md-source="github">

    <div class="md-source__icon">
      <svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" viewBox="0 0 24 24" width="28" height="28">
        <use xlink:href="#__github" width="24" height="24"></use>
      </svg>
    </div>
  
  <div class="md-source__repository">
    Presto
  </div>
</a>
          </div>
        </div>
      
      
  <script src="_static/javascripts/version_dropdown.js"></script>
  <script>
    var json_loc = "../versions.json",
        target_loc = "../",
        text = "Versions";
    $( document ).ready( add_version_dropdown(json_loc, target_loc, text));
  </script>
  

    </div>
  </nav>
</header>

  
  <div class="md-container">
    
    
    <!-- empty -->
    <main class="md-main">
      <div class="md-main__inner md-grid" data-md-component="container">
        
          <div class="md-sidebar md-sidebar--primary" data-md-component="navigation">
            <div class="md-sidebar__scrollwrap">
              <div class="md-sidebar__inner">
                <nav class="md-nav md-nav--primary" data-md-level="0">
  <label class="md-nav__title md-nav__title--site" for="__drawer">
    <a href="index.html" title="Presto 342 Documentation" class="md-nav__button md-logo">
      
        <img src="_static/presto.svg" alt=" logo" width="48" height="48">
      
    </a>
    <a href="index.html"
       title="Presto 342 Documentation">Presto 342 Documentation</a>
  </label>
    <div class="md-nav__source">
      <a href="https://github.com/prestosql/presto" title="Go to repository" class="md-source" data-md-source="github">

    <div class="md-source__icon">
      <svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" viewBox="0 0 24 24" width="28" height="28">
        <use xlink:href="#__github" width="24" height="24"></use>
      </svg>
    </div>
  
  <div class="md-source__repository">
    Presto
  </div>
</a>
    </div>
  
  
  <ul class="md-nav__list">
    <li class="md-nav__item">
    
    
      <a href="overview.html" class="md-nav__link">Overview</a>
      
    
    </li>
    <li class="md-nav__item">
    
    
      <a href="installation.html" class="md-nav__link">Installation</a>
      
    
    </li>
    <li class="md-nav__item">
    
    
      <a href="client.html" class="md-nav__link">Clients</a>
      
    
    </li>
    <li class="md-nav__item">
    
    
      <a href="security.html" class="md-nav__link">Security</a>
      
    
    </li>
    <li class="md-nav__item">
    
    
      <a href="admin.html" class="md-nav__link">Administration</a>
      
    
    </li>
    <li class="md-nav__item">
    
    
      <a href="optimizer.html" class="md-nav__link">Query Optimizer</a>
      
    
    </li>
    <li class="md-nav__item">
    
    
      <a href="connector.html" class="md-nav__link">Connectors</a>
      
    
    </li>
    <li class="md-nav__item">
    
    
      <a href="functions.html" class="md-nav__link">Functions and Operators</a>
      
    
    </li>
    <li class="md-nav__item">
    
    
      <a href="language.html" class="md-nav__link">SQL Language</a>
      
    
    </li>
    <li class="md-nav__item">
    
    
      <a href="sql.html" class="md-nav__link">SQL Statement Syntax</a>
      
    
    </li>
    <li class="md-nav__item">
    
    
      <a href="migration.html" class="md-nav__link">Migration</a>
      
    
    </li>
    <li class="md-nav__item">
    
    
      <a href="develop.html" class="md-nav__link">Developer Guide</a>
      
    
    </li>
    <li class="md-nav__item">
    
    
      <a href="release.html" class="md-nav__link">Release Notes</a>
      
    
    </li>
  </ul>
  

</nav>
              </div>
            </div>
          </div>
          <div class="md-sidebar md-sidebar--secondary" data-md-component="toc">
            <div class="md-sidebar__scrollwrap">
              <div class="md-sidebar__inner">
                
<nav class="md-nav md-nav--secondary">
    <ul class="md-nav__list" data-md-scrollfix="">
    </ul>
</nav>
              </div>
            </div>
          </div>
        
        <div class="md-content">
          <article class="md-content__inner md-typeset" role="main">
            

<h1 id="index">Index</h1>

<div class="genindex-jumpbox">
 <a href="#A"><strong>A</strong></a>
 | <a href="#B"><strong>B</strong></a>
 | <a href="#C"><strong>C</strong></a>
 | <a href="#D"><strong>D</strong></a>
 | <a href="#E"><strong>E</strong></a>
 | <a href="#F"><strong>F</strong></a>
 | <a href="#G"><strong>G</strong></a>
 | <a href="#H"><strong>H</strong></a>
 | <a href="#I"><strong>I</strong></a>
 | <a href="#J"><strong>J</strong></a>
 | <a href="#K"><strong>K</strong></a>
 | <a href="#L"><strong>L</strong></a>
 | <a href="#M"><strong>M</strong></a>
 | <a href="#N"><strong>N</strong></a>
 | <a href="#P"><strong>P</strong></a>
 | <a href="#Q"><strong>Q</strong></a>
 | <a href="#R"><strong>R</strong></a>
 | <a href="#S"><strong>S</strong></a>
 | <a href="#T"><strong>T</strong></a>
 | <a href="#U"><strong>U</strong></a>
 | <a href="#V"><strong>V</strong></a>
 | <a href="#W"><strong>W</strong></a>
 | <a href="#X"><strong>X</strong></a>
 | <a href="#Y"><strong>Y</strong></a>
 | <a href="#Z"><strong>Z</strong></a>
 
</div>
<h2 id="A">A</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/math.html#abs">abs() (built-in function)</a>
</li>
      <li><a href="functions/math.html#acos">acos() (built-in function)</a>
</li>
      <li><a href="functions/array.html#all_match">all_match() (built-in function)</a>
</li>
      <li><a href="functions/array.html#any_match">any_match() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#approx_distinct">approx_distinct() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#approx_most_frequent">approx_most_frequent() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#approx_percentile">approx_percentile() (built-in function)</a>
</li>
      <li><a href="functions/hyperloglog.html#approx_set">approx_set() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#arbitrary">arbitrary() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#array_agg">array_agg() (built-in function)</a>
</li>
      <li><a href="functions/array.html#array_distinct">array_distinct() (built-in function)</a>
</li>
      <li><a href="functions/array.html#array_except">array_except() (built-in function)</a>
</li>
      <li><a href="functions/array.html#array_intersect">array_intersect() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/array.html#array_join">array_join() (built-in function)</a>
</li>
      <li><a href="functions/array.html#array_max">array_max() (built-in function)</a>
</li>
      <li><a href="functions/array.html#array_min">array_min() (built-in function)</a>
</li>
      <li><a href="functions/array.html#array_position">array_position() (built-in function)</a>
</li>
      <li><a href="functions/array.html#array_remove">array_remove() (built-in function)</a>
</li>
      <li><a href="functions/array.html#array_sort">array_sort() (built-in function)</a>
</li>
      <li><a href="functions/array.html#array_union">array_union() (built-in function)</a>
</li>
      <li><a href="functions/array.html#arrays_overlap">arrays_overlap() (built-in function)</a>
</li>
      <li><a href="functions/math.html#asin">asin() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#at_timezone">at_timezone() (built-in function)</a>
</li>
      <li><a href="functions/math.html#atan">atan() (built-in function)</a>
</li>
      <li><a href="functions/math.html#atan2">atan2() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#avg">avg() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="B">B</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/color.html#bar">bar() (built-in function)</a>
</li>
      <li><a href="functions/math.html#beta_cdf">beta_cdf() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#bing_tile">bing_tile() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#bing_tile_at">bing_tile_at() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#bing_tile_coordinates">bing_tile_coordinates() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#bing_tile_polygon">bing_tile_polygon() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#bing_tile_quadkey">bing_tile_quadkey() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#bing_tile_zoom_level">bing_tile_zoom_level() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#bing_tiles_around">bing_tiles_around() (built-in function)</a>
</li>
      <li><a href="functions/bitwise.html#bit_count">bit_count() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/bitwise.html#bitwise_and">bitwise_and() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#bitwise_and_agg">bitwise_and_agg() (built-in function)</a>
</li>
      <li><a href="functions/bitwise.html#bitwise_left_shift">bitwise_left_shift() (built-in function)</a>
</li>
      <li><a href="functions/bitwise.html#bitwise_not">bitwise_not() (built-in function)</a>
</li>
      <li><a href="functions/bitwise.html#bitwise_or">bitwise_or() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#bitwise_or_agg">bitwise_or_agg() (built-in function)</a>
</li>
      <li><a href="functions/bitwise.html#bitwise_right_shift">bitwise_right_shift() (built-in function)</a>
</li>
      <li><a href="functions/bitwise.html#bitwise_right_shift_arithmetic">bitwise_right_shift_arithmetic() (built-in function)</a>
</li>
      <li><a href="functions/bitwise.html#bitwise_xor">bitwise_xor() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#bool_and">bool_and() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#bool_or">bool_or() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="C">C</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/array.html#cardinality">cardinality() (built-in function)</a>
</li>
      <li><a href="functions/conversion.html#cast">cast() (built-in function)</a>
</li>
      <li><a href="functions/math.html#cbrt">cbrt() (built-in function)</a>
</li>
      <li><a href="functions/math.html#ceil">ceil() (built-in function)</a>
</li>
      <li><a href="functions/math.html#ceiling">ceiling() (built-in function)</a>
</li>
      <li><a href="functions/teradata.html#char2hexint">char2hexint() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#checksum">checksum() (built-in function)</a>
</li>
      <li><a href="functions/string.html#chr">chr() (built-in function)</a>
</li>
      <li><a href="functions/ml.html#classify">classify() (built-in function)</a>
</li>
      <li><a href="functions/conditional.html#coalesce">coalesce() (built-in function)</a>
</li>
      <li><a href="functions/string.html#codepoint">codepoint() (built-in function)</a>
</li>
      <li><a href="functions/color.html#color">color() (built-in function)</a>
</li>
      <li><a href="functions/array.html#combinations">combinations() (built-in function)</a>
</li>
      <li><a href="functions/string.html#concat">concat() (built-in function)</a>
</li>
      <li><a href="functions/array.html#contains">contains() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/geospatial.html#convex_hull_agg">convex_hull_agg() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#corr">corr() (built-in function)</a>
</li>
      <li><a href="functions/math.html#cos">cos() (built-in function)</a>
</li>
      <li><a href="functions/math.html#cosh">cosh() (built-in function)</a>
</li>
      <li><a href="functions/math.html#cosine_similarity">cosine_similarity() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#count">count() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#count_if">count_if() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#covar_pop">covar_pop() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#covar_samp">covar_samp() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#crc32">crc32() (built-in function)</a>
</li>
      <li><a href="functions/window.html#cume_dist">cume_dist() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#current_date">current_date (built-in variable)</a>
</li>
      <li><a href="functions/datetime.html#current_time">current_time (built-in variable)</a>
</li>
      <li><a href="functions/datetime.html#current_timestamp">current_timestamp (built-in variable)</a>
</li>
      <li><a href="functions/datetime.html#current_timezone">current_timezone() (built-in function)</a>
</li>
      <li><a href="functions/session.html#current_user">current_user (built-in variable)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="D">D</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/datetime.html#date">date() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#date_add">date_add() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#date_diff">date_diff() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#date_format">date_format() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#date_parse">date_parse() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#date_trunc">date_trunc() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#day">day() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/datetime.html#day_of_month">day_of_month() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#day_of_week">day_of_week() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#day_of_year">day_of_year() (built-in function)</a>
</li>
      <li><a href="functions/math.html#degrees">degrees() (built-in function)</a>
</li>
      <li><a href="functions/window.html#dense_rank">dense_rank() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#dow">dow() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#doy">doy() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="E">E</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/math.html#e">e() (built-in function)</a>
</li>
      <li><a href="functions/array.html#element_at">element_at() (built-in function)</a>
</li>
      <li><a href="functions/hyperloglog.html#empty_approx_set">empty_approx_set() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/aggregate.html#every">every() (built-in function)</a>
</li>
      <li><a href="functions/math.html#exp">exp() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#extract">extract() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="F">F</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/ml.html#features">features() (built-in function)</a>
</li>
      <li><a href="functions/array.html#filter">filter() (built-in function)</a>
</li>
      <li><a href="functions/window.html#first_value">first_value() (built-in function)</a>
</li>
      <li><a href="functions/array.html#flatten">flatten() (built-in function)</a>
</li>
      <li><a href="functions/math.html#floor">floor() (built-in function)</a>
</li>
      <li><a href="functions/conversion.html#format">format() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#format_datetime">format_datetime() (built-in function)</a>
</li>
      <li><a href="functions/math.html#from_base">from_base() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#from_base64">from_base64() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#from_base64url">from_base64url() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/binary.html#from_big_endian_32">from_big_endian_32() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#from_big_endian_64">from_big_endian_64() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#from_encoded_polyline">from_encoded_polyline() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#from_hex">from_hex() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#from_ieee754_32">from_ieee754_32() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#from_ieee754_64">from_ieee754_64() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#from_iso8601_date">from_iso8601_date() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#from_iso8601_timestamp">from_iso8601_timestamp() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#from_iso8601_timestamp_nanos">from_iso8601_timestamp_nanos() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#from_unixtime">from_unixtime() (built-in function)</a>
</li>
      <li><a href="functions/string.html#from_utf8">from_utf8() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="G">G</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/aggregate.html#geometric_mean">geometric_mean() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#geometry_from_hadoop_shape">geometry_from_hadoop_shape() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#geometry_invalid_reason">geometry_invalid_reason() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#geometry_to_bing_tiles">geometry_to_bing_tiles() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/geospatial.html#geometry_union">geometry_union() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#geometry_union_agg">geometry_union_agg() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#great_circle_distance">great_circle_distance() (built-in function)</a>
</li>
      <li><a href="functions/comparison.html#greatest">greatest() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="H">H</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/string.html#hamming_distance">hamming_distance() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#histogram">histogram() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#hmac_md5">hmac_md5() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#hmac_sha1">hmac_sha1() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/binary.html#hmac_sha256">hmac_sha256() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#hmac_sha512">hmac_sha512() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#hour">hour() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#human_readable_seconds">human_readable_seconds() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="I">I</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/conditional.html#if">if() (built-in function)</a>
</li>
      <li><a href="functions/teradata.html#index">index() (built-in function)</a>
</li>
      <li><a href="functions/math.html#infinity">infinity() (built-in function)</a>
</li>
      <li><a href="functions/math.html#inverse_beta_cdf">inverse_beta_cdf() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/math.html#inverse_normal_cdf">inverse_normal_cdf() (built-in function)</a>
</li>
      <li><a href="functions/math.html#is_finite">is_finite() (built-in function)</a>
</li>
      <li><a href="functions/math.html#is_infinite">is_infinite() (built-in function)</a>
</li>
      <li><a href="functions/json.html#is_json_scalar">is_json_scalar() (built-in function)</a>
</li>
      <li><a href="functions/math.html#is_nan">is_nan() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="J">J</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/json.html#json_array_contains">json_array_contains() (built-in function)</a>
</li>
      <li><a href="functions/json.html#json_array_get">json_array_get() (built-in function)</a>
</li>
      <li><a href="functions/json.html#json_array_length">json_array_length() (built-in function)</a>
</li>
      <li><a href="functions/json.html#json_extract">json_extract() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/json.html#json_extract_scalar">json_extract_scalar() (built-in function)</a>
</li>
      <li><a href="functions/json.html#json_format">json_format() (built-in function)</a>
</li>
      <li><a href="functions/json.html#json_parse">json_parse() (built-in function)</a>
</li>
      <li><a href="functions/json.html#json_size">json_size() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="K">K</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/aggregate.html#kurtosis">kurtosis() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="L">L</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/window.html#lag">lag() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#last_day_of_month">last_day_of_month() (built-in function)</a>
</li>
      <li><a href="functions/window.html#last_value">last_value() (built-in function)</a>
</li>
      <li><a href="functions/window.html#lead">lead() (built-in function)</a>
</li>
      <li><a href="functions/ml.html#learn_classifier">learn_classifier() (built-in function)</a>
</li>
      <li><a href="functions/ml.html#learn_libsvm_classifier">learn_libsvm_classifier() (built-in function)</a>
</li>
      <li><a href="functions/ml.html#learn_libsvm_regressor">learn_libsvm_regressor() (built-in function)</a>
</li>
      <li><a href="functions/ml.html#learn_regressor">learn_regressor() (built-in function)</a>
</li>
      <li><a href="functions/comparison.html#least">least() (built-in function)</a>
</li>
      <li><a href="functions/string.html#length">length() (built-in function)</a>
</li>
      <li><a href="functions/string.html#levenshtein_distance">levenshtein_distance() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#line_interpolate_point">line_interpolate_point() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/geospatial.html#line_interpolate_points">line_interpolate_points() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#line_locate_point">line_locate_point() (built-in function)</a>
</li>
      <li><a href="functions/math.html#ln">ln() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#localtime">localtime (built-in variable)</a>
</li>
      <li><a href="functions/datetime.html#localtimestamp">localtimestamp (built-in variable)</a>
</li>
      <li><a href="functions/math.html#log">log() (built-in function)</a>
</li>
      <li><a href="functions/math.html#log10">log10() (built-in function)</a>
</li>
      <li><a href="functions/math.html#log2">log2() (built-in function)</a>
</li>
      <li><a href="functions/string.html#lower">lower() (built-in function)</a>
</li>
      <li><a href="functions/string.html#lpad">lpad() (built-in function)</a>
</li>
      <li><a href="functions/string.html#ltrim">ltrim() (built-in function)</a>
</li>
      <li><a href="functions/string.html#luhn_check">luhn_check() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="M">M</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/map.html#map">map() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#map_agg">map_agg() (built-in function)</a>
</li>
      <li><a href="functions/map.html#map_concat">map_concat() (built-in function)</a>
</li>
      <li><a href="functions/map.html#map_entries">map_entries() (built-in function)</a>
</li>
      <li><a href="functions/map.html#map_filter">map_filter() (built-in function)</a>
</li>
      <li><a href="functions/map.html#map_from_entries">map_from_entries() (built-in function)</a>
</li>
      <li><a href="functions/map.html#map_keys">map_keys() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#map_union">map_union() (built-in function)</a>
</li>
      <li><a href="functions/map.html#map_values">map_values() (built-in function)</a>
</li>
      <li><a href="functions/map.html#map_zip_with">map_zip_with() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#max">max() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/aggregate.html#max_by">max_by() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#md5">md5() (built-in function)</a>
</li>
      <li><a href="functions/hyperloglog.html#merge">merge() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#millisecond">millisecond() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#min">min() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#min_by">min_by() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#minute">minute() (built-in function)</a>
</li>
      <li><a href="functions/math.html#mod">mod() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#month">month() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#multimap_agg">multimap_agg() (built-in function)</a>
</li>
      <li><a href="functions/map.html#multimap_from_entries">multimap_from_entries() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="N">N</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/math.html#nan">nan() (built-in function)</a>
</li>
      <li><a href="functions/array.html#ngrams">ngrams() (built-in function)</a>
</li>
      <li><a href="functions/array.html#none_match">none_match() (built-in function)</a>
</li>
      <li><a href="functions/math.html#normal_cdf">normal_cdf() (built-in function)</a>
</li>
      <li><a href="functions/string.html#normalize">normalize() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/datetime.html#now">now() (built-in function)</a>
</li>
      <li><a href="functions/window.html#nth_value">nth_value() (built-in function)</a>
</li>
      <li><a href="functions/window.html#ntile">ntile() (built-in function)</a>
</li>
      <li><a href="functions/conditional.html#nullif">nullif() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#numeric_histogram">numeric_histogram() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="P">P</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/datetime.html#parse_datetime">parse_datetime() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#parse_duration">parse_duration() (built-in function)</a>
</li>
      <li><a href="functions/conversion.html#parse_presto_data_size">parse_presto_data_size() (built-in function)</a>
</li>
      <li><a href="functions/window.html#percent_rank">percent_rank() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/math.html#pi">pi() (built-in function)</a>
</li>
      <li><a href="functions/string.html#position">position() (built-in function)</a>
</li>
      <li><a href="functions/math.html#pow">pow() (built-in function)</a>
</li>
      <li><a href="functions/math.html#power">power() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="Q">Q</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/qdigest.html#qdigest_agg">qdigest_agg() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/datetime.html#quarter">quarter() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="R">R</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/math.html#radians">radians() (built-in function)</a>
</li>
      <li><a href="functions/math.html#rand">rand() (built-in function)</a>
</li>
      <li><a href="functions/math.html#random">random() (built-in function)</a>
</li>
      <li><a href="functions/window.html#rank">rank() (built-in function)</a>
</li>
      <li><a href="functions/array.html#reduce">reduce() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#reduce_agg">reduce_agg() (built-in function)</a>
</li>
      <li><a href="functions/regexp.html#regexp_count">regexp_count() (built-in function)</a>
</li>
      <li><a href="functions/regexp.html#regexp_extract">regexp_extract() (built-in function)</a>
</li>
      <li><a href="functions/regexp.html#regexp_extract_all">regexp_extract_all() (built-in function)</a>
</li>
      <li><a href="functions/regexp.html#regexp_like">regexp_like() (built-in function)</a>
</li>
      <li><a href="functions/regexp.html#regexp_position">regexp_position() (built-in function)</a>
</li>
      <li><a href="functions/regexp.html#regexp_replace">regexp_replace() (built-in function)</a>
</li>
      <li><a href="functions/regexp.html#regexp_split">regexp_split() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#regr_intercept">regr_intercept() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#regr_slope">regr_slope() (built-in function)</a>
</li>
      <li><a href="functions/ml.html#regress">regress() (built-in function)</a>
</li>
      <li><a href="functions/color.html#render">render() (built-in function)</a>
</li>
      <li><a href="functions/array.html#repeat">repeat() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/string.html#replace">replace() (built-in function)</a>
</li>
      <li><a href="functions/string.html#reverse">reverse() (built-in function)</a>
</li>
      <li>
    RFC

      <ul>
        <li><a href="functions/url.html#index-1">RFC 1866#section-8.2.1</a>
</li>
        <li><a href="functions/url.html#index-0">RFC 2396</a>
</li>
        <li><a href="connector/kafka.html#index-2">RFC 2822</a>
</li>
        <li><a href="language/types.html#index-2">RFC 4122</a>
</li>
        <li><a href="language/types.html#index-0">RFC 4291#section-2.5.5.2</a>
</li>
        <li><a href="connector/kafka.html#index-0">RFC 4627</a>, <a href="connector/kafka.html#index-1">[1]</a>
</li>
        <li><a href="functions/binary.html#index-0">RFC 4648</a>
</li>
        <li><a href="language/types.html#index-1">RFC 5952</a>
</li>
        <li><a href="functions/json.html#index-0">RFC 7159</a>, <a href="functions/json.html#index-1">[1]</a>
</li>
        <li><a href="release/release-334.html#index-0">RFC 7239</a>
</li>
      </ul></li>
      <li><a href="functions/color.html#rgb">rgb() (built-in function)</a>
</li>
      <li><a href="functions/math.html#round">round() (built-in function)</a>
</li>
      <li><a href="functions/window.html#row_number">row_number() (built-in function)</a>
</li>
      <li><a href="functions/string.html#rpad">rpad() (built-in function)</a>
</li>
      <li><a href="functions/string.html#rtrim">rtrim() (built-in function)</a>
</li>
      <li><a href="connector/system.html#runtime.kill_query">runtime.kill_query() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="S">S</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/datetime.html#second">second() (built-in function)</a>
</li>
      <li><a href="functions/array.html#sequence">sequence() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#sha1">sha1() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#sha256">sha256() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#sha512">sha512() (built-in function)</a>
</li>
      <li><a href="functions/array.html#shuffle">shuffle() (built-in function)</a>
</li>
      <li><a href="functions/math.html#sign">sign() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#simplify_geometry">simplify_geometry() (built-in function)</a>
</li>
      <li><a href="functions/math.html#sin">sin() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#skewness">skewness() (built-in function)</a>
</li>
      <li><a href="functions/array.html#slice">slice() (built-in function)</a>
</li>
      <li><a href="functions/string.html#split">split() (built-in function)</a>
</li>
      <li><a href="functions/string.html#split_part">split_part() (built-in function)</a>
</li>
      <li><a href="functions/string.html#split_to_map">split_to_map() (built-in function)</a>
</li>
      <li><a href="functions/string.html#split_to_multimap">split_to_multimap() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#spooky_hash_v2_32">spooky_hash_v2_32() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#spooky_hash_v2_64">spooky_hash_v2_64() (built-in function)</a>
</li>
      <li><a href="functions/math.html#sqrt">sqrt() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Area">ST_Area() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_AsBinary">ST_AsBinary() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_AsText">ST_AsText() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Boundary">ST_Boundary() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Buffer">ST_Buffer() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Centroid">ST_Centroid() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Contains">ST_Contains() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_ConvexHull">ST_ConvexHull() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_CoordDim">ST_CoordDim() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Crosses">ST_Crosses() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Difference">ST_Difference() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Dimension">ST_Dimension() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Disjoint">ST_Disjoint() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Distance">ST_Distance() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_EndPoint">ST_EndPoint() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Envelope">ST_Envelope() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_EnvelopeAsPts">ST_EnvelopeAsPts() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Equals">ST_Equals() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_ExteriorRing">ST_ExteriorRing() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Geometries">ST_Geometries() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_GeometryFromText">ST_GeometryFromText() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_GeometryN">ST_GeometryN() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_GeometryType">ST_GeometryType() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/geospatial.html#ST_GeomFromBinary">ST_GeomFromBinary() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_InteriorRingN">ST_InteriorRingN() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_InteriorRings">ST_InteriorRings() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Intersection">ST_Intersection() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Intersects">ST_Intersects() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_IsClosed">ST_IsClosed() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_IsEmpty">ST_IsEmpty() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_IsRing">ST_IsRing() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_IsSimple">ST_IsSimple() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_IsValid">ST_IsValid() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Length">ST_Length() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_LineFromText">ST_LineFromText() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_LineString">ST_LineString() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_MultiPoint">ST_MultiPoint() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_NumGeometries">ST_NumGeometries() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_NumInteriorRing">ST_NumInteriorRing() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_NumPoints">ST_NumPoints() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Overlaps">ST_Overlaps() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Point">ST_Point() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_PointN">ST_PointN() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Points">ST_Points() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Polygon">ST_Polygon() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Relate">ST_Relate() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_StartPoint">ST_StartPoint() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_SymDifference">ST_SymDifference() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Touches">ST_Touches() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Union">ST_Union() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Within">ST_Within() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_X">ST_X() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_XMax">ST_XMax() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_XMin">ST_XMin() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_Y">ST_Y() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_YMax">ST_YMax() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#ST_YMin">ST_YMin() (built-in function)</a>
</li>
      <li><a href="functions/string.html#starts_with">starts_with() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#stddev">stddev() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#stddev_pop">stddev_pop() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#stddev_samp">stddev_samp() (built-in function)</a>
</li>
      <li><a href="functions/string.html#strpos">strpos() (built-in function)</a>
</li>
      <li><a href="functions/string.html#substr">substr() (built-in function)</a>
</li>
      <li><a href="functions/string.html#substring">substring() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#sum">sum() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="T">T</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/math.html#tan">tan() (built-in function)</a>
</li>
      <li><a href="functions/math.html#tanh">tanh() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#timezone_hour">timezone_hour() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#timezone_minute">timezone_minute() (built-in function)</a>
</li>
      <li><a href="functions/math.html#to_base">to_base() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#to_base64">to_base64() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#to_base64url">to_base64url() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#to_big_endian_32">to_big_endian_32() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#to_big_endian_64">to_big_endian_64() (built-in function)</a>
</li>
      <li><a href="functions/teradata.html#to_char">to_char() (built-in function)</a>
</li>
      <li><a href="functions/teradata.html#to_date">to_date() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#to_encoded_polyline">to_encoded_polyline() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#to_geometry">to_geometry() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#to_hex">to_hex() (built-in function)</a>
</li>
      <li><a href="functions/binary.html#to_ieee754_32">to_ieee754_32() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/binary.html#to_ieee754_64">to_ieee754_64() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#to_iso8601">to_iso8601() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#to_milliseconds">to_milliseconds() (built-in function)</a>
</li>
      <li><a href="functions/geospatial.html#to_spherical_geography">to_spherical_geography() (built-in function)</a>
</li>
      <li><a href="functions/teradata.html#to_timestamp">to_timestamp() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#to_unixtime">to_unixtime() (built-in function)</a>
</li>
      <li><a href="functions/string.html#to_utf8">to_utf8() (built-in function)</a>
</li>
      <li><a href="functions/array.html#transform">transform() (built-in function)</a>
</li>
      <li><a href="functions/map.html#transform_keys">transform_keys() (built-in function)</a>
</li>
      <li><a href="functions/map.html#transform_values">transform_values() (built-in function)</a>
</li>
      <li><a href="functions/string.html#translate">translate() (built-in function)</a>
</li>
      <li><a href="functions/string.html#trim">trim() (built-in function)</a>
</li>
      <li><a href="functions/math.html#truncate">truncate() (built-in function)</a>
</li>
      <li><a href="functions/conditional.html#try">try() (built-in function)</a>
</li>
      <li><a href="functions/conversion.html#try_cast">try_cast() (built-in function)</a>
</li>
      <li><a href="functions/conversion.html#typeof">typeof() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="U">U</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/string.html#upper">upper() (built-in function)</a>
</li>
      <li><a href="functions/url.html#url_decode">url_decode() (built-in function)</a>
</li>
      <li><a href="functions/url.html#url_encode">url_encode() (built-in function)</a>
</li>
      <li><a href="functions/url.html#url_extract_fragment">url_extract_fragment() (built-in function)</a>
</li>
      <li><a href="functions/url.html#url_extract_host">url_extract_host() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/url.html#url_extract_parameter">url_extract_parameter() (built-in function)</a>
</li>
      <li><a href="functions/url.html#url_extract_path">url_extract_path() (built-in function)</a>
</li>
      <li><a href="functions/url.html#url_extract_port">url_extract_port() (built-in function)</a>
</li>
      <li><a href="functions/url.html#url_extract_protocol">url_extract_protocol() (built-in function)</a>
</li>
      <li><a href="functions/url.html#url_extract_query">url_extract_query() (built-in function)</a>
</li>
      <li><a href="functions/uuid.html#uuid">uuid() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="V">V</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/qdigest.html#value_at_quantile">value_at_quantile() (built-in function)</a>
</li>
      <li><a href="functions/qdigest.html#values_at_quantiles">values_at_quantiles() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/aggregate.html#var_pop">var_pop() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#var_samp">var_samp() (built-in function)</a>
</li>
      <li><a href="functions/aggregate.html#variance">variance() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="W">W</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/datetime.html#week">week() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#week_of_year">week_of_year() (built-in function)</a>
</li>
      <li><a href="functions/math.html#width_bucket">width_bucket() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/math.html#wilson_interval_lower">wilson_interval_lower() (built-in function)</a>
</li>
      <li><a href="functions/math.html#wilson_interval_upper">wilson_interval_upper() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#with_timezone">with_timezone() (built-in function)</a>
</li>
      <li><a href="functions/string.html#word_stem">word_stem() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="X">X</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/binary.html#xxhash64">xxhash64() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="Y">Y</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/datetime.html#year">year() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/datetime.html#year_of_week">year_of_week() (built-in function)</a>
</li>
      <li><a href="functions/datetime.html#yow">yow() (built-in function)</a>
</li>
  </ul></td>
</tr></table>

<h2 id="Z">Z</h2>
<table style="width: 100%" class="indextable genindextable"><tr>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/array.html#zip">zip() (built-in function)</a>
</li>
  </ul></td>
  <td style="width: 33%; vertical-align: top;"><ul>
      <li><a href="functions/array.html#zip_with">zip_with() (built-in function)</a>
</li>
  </ul></td>
</tr></table>


          </article>
        </div>
      </div>
    </main>
  </div>
  <footer class="md-footer">
    <div class="md-footer-nav">
      <nav class="md-footer-nav__inner md-grid">
          
          
        </a>
        
      </nav>
    </div>
    <div class="md-footer-meta md-typeset">
      <div class="md-footer-meta__inner md-grid">
        <div class="md-footer-copyright">
        </div>
      </div>
    </div>
  </footer>
  <script src="_static/javascripts/application.js"></script>
  <script>app.initialize({version: "1.0.4", url: {base: ".."}})</script>
  </body>
</html>