You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@phoenix.apache.org by ja...@apache.org on 2016/09/12 17:08:15 UTC
svn commit: r1760410 - /phoenix/site/publish/hive_storage_handler.html
Author: jamestaylor
Date: Mon Sep 12 17:08:15 2016
New Revision: 1760410
URL: http://svn.apache.org/viewvc?rev=1760410&view=rev
Log:
Hive storage handler docs with new html page (Sergey Soldatov)
Added:
phoenix/site/publish/hive_storage_handler.html
Added: phoenix/site/publish/hive_storage_handler.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/hive_storage_handler.html?rev=1760410&view=auto
==============================================================================
--- phoenix/site/publish/hive_storage_handler.html (added)
+++ phoenix/site/publish/hive_storage_handler.html Mon Sep 12 17:08:15 2016
@@ -0,0 +1,618 @@
+
+<!DOCTYPE html>
+<!--
+ Generated by Apache Maven Doxia at 2016-09-12
+ Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
+-->
+<html xml:lang="en" lang="en">
+
+ <head>
+ <meta charset="UTF-8" />
+ <title>Hive Storage Handler | 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>
+
+ <body class="page-hive_storage_handler 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="New Features">New Features</a></li>
+ <li ><a href="roadmap.html" title="Roadmap">Roadmap</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="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="tuning.html" title="Tuning">Tuning</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 class="active"><a href="" title="Apache Hive Storage Handler">Apache Hive Storage Handler</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 class="divider"/>
+ <li ><a href="phoenix_on_emr.html" title="Phoenix on Amazon EMR">Phoenix on Amazon EMR</a></li>
+ <li ><a href="phoenix_python.html" title="Phoenix Adapter for Python">Phoenix Adapter for Python</a></li>
+ <li ><a href="phoenix_orm.html" title="Phoenix ORM Library">Phoenix ORM Library</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="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 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="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="metrics.html" title="Metrics">Metrics</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="language/index.html" title="Grammar">Grammar</a></li>
+ <li ><a href="language/functions.html" title="Functions">Functions</a></li>
+ <li ><a href="language/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>
+ </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">
+ <h1>Hive Storage Handler</h1>
+</div>
+<p>Hive Storage Handler is a Apache Phoenix plugin that allows access to Phoenix tables from Apache Hive CLI using HiveQL.</p>
+<div class="section">
+ <h2 id="Prerequisites">Prerequisites</h2>
+ <ul>
+ <li>Phoenix 4.8.0+</li>
+ <li>Hive 1.2.1+</li>
+ </ul>
+</div>
+<div class="section">
+ <h2 id="Hive_Setup">Hive Setup</h2>
+ <p>Make phoenix-version-hive.jar available for Hive:</p>
+ <ol style="list-style-type: decimal">
+ <li>Add to hive-env.sh:</li>
+ </ol>
+ <div class="source">
+ <pre>HIVE_AUX_JARS_PATH=<path to jar>
+</pre>
+ </div>
+ <ol style="list-style-type: decimal">
+ <li>Add property to hive-site.xml. That will allow Hive Map-Reduce jobs to use this jar:</li>
+ </ol>
+ <div class="source">
+ <pre><property>
+ <name>hive.aux.jars.path</name>
+ <value>file://<path></value>
+</property>
+</pre>
+ </div>
+</div>
+<div class="section">
+ <h2 id="Table_creation_and_deletion">Table creation and deletion</h2>
+ <p>Phoenix Storage Handler supports both INTERNAL and EXTERNAL Hive tables. </p>
+ <div class="section">
+ <h3 id="Create_INTERNAL_table.">Create INTERNAL table.</h3>
+ <p>For internal tables Hive manages the lifecycle of the table and data. When hive table is created, a corresponding Phoenix table will be created as well. Once the hive table is dropped, the Phoenix table will be deleted too. </p>
+ <div class="source">
+ <pre> create table phoenix_table (
+ s1 string,
+ i1 int,
+ f1 float,
+ d1 double
+ )
+ STORED BY 'org.apache.phoenix.hive.PhoenixStorageHandler'
+ TBLPROPERTIES (
+ "phoenix.table.name" = "phoenix_table",
+ "phoenix.zookeeper.quorum" = "localhost",
+ "phoenix.zookeeper.znode.parent" = "/hbase",
+ "phoenix.zookeeper.client.port" = "2181",
+ "phoenix.rowkeys" = "s1, i1",
+ "phoenix.column.mapping" = "s1:s1, i1:i1, f1:f1, d1:d1",
+ "phoenix.table.options" = "SALT_BUCKETS=10, DATA_BLOCK_ENCODING='DIFF'"
+ );
+</pre>
+ </div>
+ </div>
+ <div class="section">
+ <h3 id="Create_EXTERNAL_table">Create EXTERNAL table</h3>
+ <p>For external tables Hive works with an existing Phoenix table and manages only Hive metadata. Deleting an external table from Hive only deletes Hive metadata and keeps Phoenix table </p>
+ <div class="source">
+ <pre>create external table ext_table (
+ i1 int,
+ s1 string,
+ f1 float,
+ d1 decimal
+)
+STORED BY 'org.apache.phoenix.hive.PhoenixStorageHandler'
+TBLPROPERTIES (
+ "phoenix.table.name" = "ext_table",
+ "phoenix.zookeeper.quorum" = "localhost",
+ "phoenix.zookeeper.znode.parent" = "/hbase",
+ "phoenix.zookeeper.client.port" = "2181",
+ "phoenix.rowkeys" = "i1",
+ "phoenix.column.mapping" = "i1:i1, s1:s1, f1:f1, d1:d1"
+);
+</pre>
+ </div>
+ </div>
+ <div class="section">
+ <h3 id="Properties">Properties</h3>
+ <ol style="list-style-type: decimal">
+ <li>phoenix.table.name
+ <ul>
+ <li>Specified the Phoenix table name</li>
+ <li>Default : the same as hive table</li>
+ </ul></li>
+ <li>phoenix.zookeeper.quorum
+ <ul>
+ <li>Specified the ZK quorum for HBase</li>
+ <li>Default : localhost</li>
+ </ul></li>
+ <li>phoenix.zookeeper.znode.parent
+ <ul>
+ <li>Specified the ZK parent node for HBase</li>
+ <li>Default : /hbase</li>
+ </ul></li>
+ <li>phoenix.zookeeper.client.port
+ <ul>
+ <li>Specified the ZK port</li>
+ <li>Default : 2181</li>
+ </ul></li>
+ <li>phoenix.rowkeys
+ <ul>
+ <li>The list of columns that would match the RowKey in Phoenix table</li>
+ <li>Required</li>
+ </ul></li>
+ <li>phoenix.column.mapping
+ <ul>
+ <li>mappings between column names for hive and phoenix. See Limitations for details.</li>
+ </ul></li>
+ </ol>
+ </div>
+</div>
+<div class="section">
+ <h2 id="Data_ingestiondeleteupdate">Data ingestion/delete/update</h2>
+ <p>Data ingestion can be done by all ways that supported by Hive or Phoenix: Hive: </p>
+ <div class="source">
+ <pre> insert into table T values (....);
+ inseet into table T select c1,c2,c3 from source_table;
+</pre>
+ </div>
+ <p>Phoenix: </p>
+ <div class="source">
+ <pre> upsert into table T values (.....);
+ Phoenix CSV BulkLoad tools
+</pre>
+ </div>
+ <p>All delete/update should be performed on Phoenix side. See <i>Limitation</i> for more details</p>
+</div>
+<div class="section">
+ <h2 id="Additinal_configuration_options">Additinal configuration options</h2>
+ <p>Those options can be set in Hive CLI </p>
+ <div class="section">
+ <h3 id="Performance_tuning">Performance tuning</h3>
+ <table border="0" class="bodyTable table table-striped table-hover">
+ <thead>
+ <tr class="a">
+ <th>Parameters </th>
+ <th>Default Value </th>
+ <th>Description</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr class="b">
+ <td>phoenix.upsert.batch.size </td>
+ <td>1000 </td>
+ <td>Batch size for upsert.</td>
+ </tr>
+ <tr class="a">
+ <td>[phoenix-table-name].disable.wal </td>
+ <td>false </td>
+ <td>It temporarily sets table attribute <tt>DISABLE_WAL = true</tt>. May be used to improve the performance</td>
+ </tr>
+ <tr class="b">
+ <td>[phoenix-table-name].auto.flush </td>
+ <td>false </td>
+ <td>When WAL is disabled and if this value is true. Then flush memstore to hfile.</td>
+ </tr>
+ </tbody>
+ </table>
+ </div>
+ <div class="section">
+ <h3 id="Query_Data">Query Data</h3>
+ <p>You can use HiveQL for querying data on phoenix table. A single table query as fast as Phoenix CLI when <tt>hive.fetch.task.conversion=more</tt> and <tt>hive.exec.parallel=true</tt>.</p>
+ <table border="0" class="bodyTable table table-striped table-hover">
+ <thead>
+ <tr class="a">
+ <th>Parameters </th>
+ <th>Default Value </th>
+ <th>Description</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr class="b">
+ <td>hbase.scan.cache </td>
+ <td>100 </td>
+ <td>Read row size for an unit request.</td>
+ </tr>
+ <tr class="a">
+ <td>hbase.scan.cacheblock </td>
+ <td>false </td>
+ <td>Whether or not cache block.</td>
+ </tr>
+ <tr class="b">
+ <td>split.by.stats </td>
+ <td>false </td>
+ <td>If true, mappers will use table statistics. One mapper per guide post.</td>
+ </tr>
+ <tr class="a">
+ <td>[hive-table-name].reducer.count </td>
+ <td>1 </td>
+ <td>Number of reducer. In tez mode is affected only single-table query. See Limitations</td>
+ </tr>
+ <tr class="b">
+ <td>[phoenix-table-name].query.hint </td>
+ <td> </td>
+ <td>Hint for phoenix query (like NO_INDEX)</td>
+ </tr>
+ </tbody>
+ </table>
+ </div>
+</div>
+<div class="section">
+ <h2 id="Limitations">Limitations</h2>
+ <ol style="list-style-type: decimal">
+ <li>Hive update/delete requires transaction manager support on Hive side as well as using transaction engine on Phoenix side. Futher Hive/Phoenix JIRAs will be listed in <i>Resource</i> section.</li>
+ <li>Column mapping doesn’t work correctly with mapping row key columns</li>
+ <li>Currently MR and Tez jobs always have a single reducer.</li>
+ </ol>
+</div>
+<div class="section">
+ <h2 id="Resources">Resources</h2>
+ <ul>
+ <li><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-2743">PHOENIX-2743</a> : Implementation, accepted by Apache Phoenix community. Original pull request contains modification for Hive classes.</li>
+ <li><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-331">PHOENIX-331</a> : Another implementation with support of Hive 0.98. Outdated</li>
+ </ul>
+</div>
+ </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="New Features">New Features</a>
+ </li>
+ <li >
+ <a href="roadmap.html" title="Roadmap">Roadmap</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="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="tuning.html" title="Tuning">Tuning</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 class="active">
+ <a href="#" title="Apache Hive Storage Handler">Apache Hive Storage Handler</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="http:divider" title=""></a>
+ </li>
+ <li >
+ <a href="phoenix_on_emr.html" title="Phoenix on Amazon EMR">Phoenix on Amazon EMR</a>
+ </li>
+ <li >
+ <a href="phoenix_python.html" title="Phoenix Adapter for Python">Phoenix Adapter for Python</a>
+ </li>
+ <li >
+ <a href="phoenix_orm.html" title="Phoenix ORM Library">Phoenix ORM Library</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="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="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="tracing.html" title="Tracing">Tracing</a>
+ </li>
+ <li >
+ <a href="metrics.html" title="Metrics">Metrics</a>
+ </li>
+ </ul>
+ </div>
+ <div class="span3 bottom-nav">
+ <ul class="nav nav-list">
+ <li class="nav-header">Reference</li>
+ <li >
+ <a href="language/index.html" title="Grammar">Grammar</a>
+ </li>
+ <li >
+ <a href="language/functions.html" title="Functions">Functions</a>
+ </li>
+ <li >
+ <a href="language/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>
+ </ul>
+ </div>
+ <div class="span3 bottom-description">
+ <form action="http://search-hadoop.com/?" method="get"><input value="Phoenix" name="fc_project" type="hidden"><input placeholder="Search Phoenix…" required="required" style="width:170px;" size="18" name="q" id="query" type="search"></form>
+ </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 ©2016 <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>
+</html>