You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@phoenix.apache.org by st...@apache.org on 2021/09/09 05:55:05 UTC
svn commit: r1893163 [1/2] - in /phoenix/site: publish/ publish/language/
source/src/site/markdown/
Author: stoty
Date: Thu Sep 9 05:55:04 2021
New Revision: 1893163
URL: http://svn.apache.org/viewvc?rev=1893163&view=rev
Log:
PHOENIX-6535 Update obsolete information on website
also replace absolute links with relative ones in wiki links
Modified:
phoenix/site/publish/Phoenix-in-15-minutes-or-less.html
phoenix/site/publish/building.html
phoenix/site/publish/contributing.html
phoenix/site/publish/develop.html
phoenix/site/publish/faq.html
phoenix/site/publish/index.html
phoenix/site/publish/installation.html
phoenix/site/publish/issues.html
phoenix/site/publish/language/datatypes.html
phoenix/site/publish/language/functions.html
phoenix/site/publish/language/index.html
phoenix/site/publish/multi-tenancy.html
phoenix/site/publish/namspace_mapping.html
phoenix/site/publish/news.html
phoenix/site/publish/performance.html
phoenix/site/publish/phoenix_spark.html
phoenix/site/publish/python.html
phoenix/site/publish/recent.html
phoenix/site/publish/release.html
phoenix/site/publish/release_notes.html
phoenix/site/publish/resources.html
phoenix/site/publish/roadmap.html
phoenix/site/publish/secondary_indexing.html
phoenix/site/publish/sequences.html
phoenix/site/publish/server.html
phoenix/site/publish/tuning_guide.html
phoenix/site/source/src/site/markdown/Phoenix-in-15-minutes-or-less.md
phoenix/site/source/src/site/markdown/building.md
phoenix/site/source/src/site/markdown/contributing.md
phoenix/site/source/src/site/markdown/develop.md
phoenix/site/source/src/site/markdown/faq.md
phoenix/site/source/src/site/markdown/index.md
phoenix/site/source/src/site/markdown/installation.md
phoenix/site/source/src/site/markdown/issues.md
phoenix/site/source/src/site/markdown/multi-tenancy.md
phoenix/site/source/src/site/markdown/namspace_mapping.md
phoenix/site/source/src/site/markdown/news.md
phoenix/site/source/src/site/markdown/performance.md
phoenix/site/source/src/site/markdown/phoenix_spark.md
phoenix/site/source/src/site/markdown/python.md
phoenix/site/source/src/site/markdown/recent.md
phoenix/site/source/src/site/markdown/release.md
phoenix/site/source/src/site/markdown/release_notes.md
phoenix/site/source/src/site/markdown/resources.md
phoenix/site/source/src/site/markdown/roadmap.md
phoenix/site/source/src/site/markdown/secondary_indexing.md
phoenix/site/source/src/site/markdown/sequences.md
phoenix/site/source/src/site/markdown/server.md
phoenix/site/source/src/site/markdown/tuning_guide.md
Modified: phoenix/site/publish/Phoenix-in-15-minutes-or-less.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/Phoenix-in-15-minutes-or-less.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/Phoenix-in-15-minutes-or-less.html (original)
+++ phoenix/site/publish/Phoenix-in-15-minutes-or-less.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -178,9 +178,6 @@
<li>bringing the computation to the data by</li>
<li>pushing the predicates in your where clause to a server-side filter</li>
<li>executing aggregate queries through server-side hooks (called co-processors)</li>
-</ul>
-<p>In addition to these items, weâve got some interesting enhancements in the works to further optimize performance:</p>
-<ul>
<li>secondary indexes to improve performance for queries on non row key columns</li>
<li>stats gathering to improve parallelization and guide choices between optimizations</li>
<li>skip scan filter to optimize IN, LIKE, and OR queries</li>
@@ -195,13 +192,13 @@
<p><i><b>But how can SQL support my favorite HBase technique of x,y,z</b></i><br /> Didnât make it to the last HBase Meetup did you? SQL is just a way of expressing <i><b>what you want to get</b></i> not <i><b>how you want to get it</b></i>. Check out my <a class="externalLink" href="http://files.meetup.com/1350427/IntelPhoenixHBaseMeetup.ppt">presentation</a> for various existing and to-be-done Phoenix features to support your favorite HBase trick. Have ideas of your own? Weâd love to hear about them: file an <a href="issues.html">issue</a> for us and/or join our <a href="mailing_list.html">mailing list</a>.</p>
<p><i><b>Blah, blah, blah - I just want to get started!</b></i><br /> Ok, great! Just follow our <a href="installation.html">install instructions</a>:</p>
<ul>
- <li><a href="download.html">download</a> and expand our installation tar</li>
- <li>copy the phoenix server jar that is compatible with your HBase installation into the lib directory of every region server</li>
- <li>restart the region servers</li>
- <li>add the phoenix client jar to the classpath of your HBase client</li>
- <li>download and <a href="installation.html#SQL_Client">setup SQuirrel</a> as your SQL client so you can issue adhoc SQL against your HBase cluster</li>
+ <li><a href="download.html">download</a> and expand our installation binary tar corresponding to your HBase version</li>
+ <li>copy the phoenix server jar into the lib directory of every region server and master</li>
+ <li>restart HBase</li>
+ <li>add the phoenix client jar to the classpath of your JDBC client or application</li>
+ <li>We have detailed instructions for <a href="installation.html#SQL_Client">setting up SQuirreL SQL</a> as your SQL client</li>
</ul>
-<p><i><b>I donât want to download and setup anything else!</b></i><br /> Ok, fair enough - you can create your own SQL scripts and execute them using our command line tool instead. Letâs walk through an example now. Begin by navigating to the <tt>bin/</tt> directory of your Phoenix install location.</p>
+<p><i><b>I donât want to download and setup anything else!</b></i><br /> Ok, fair enough - you can create your own SQL scripts and execute them using our command line tools instead. Letâs walk through an example now. Begin by navigating to the <tt>bin/</tt> directory of your Phoenix install location.</p>
<ul>
<li>First, letâs create a <tt>us_population.sql</tt> file, containing a table definition:</li>
</ul>
@@ -230,20 +227,25 @@ CA,San Jose,912332
</pre>
</div>
<ul>
- <li>And finally, letâs create a <tt>us_population_queries.sql</tt> file containing a query weâd like to run on that data.</li>
+ <li>Execute the following command from a command terminal to create and populate the table</li>
</ul>
<div class="source">
- <pre>SELECT state as "State",count(city) as "City Count",sum(population) as "Population Sum"
-FROM us_population
-GROUP BY state
-ORDER BY sum(population) DESC;
+ <pre>./psql.py <your_zookeeper_quorum> us_population.sql us_population.csv
</pre>
</div>
<ul>
- <li>Execute the following command from a command terminal</li>
+ <li>Start the interactive sql client</li>
</ul>
<div class="source">
- <pre>./psql.py <your_zookeeper_quorum> us_population.sql us_population.csv us_population_queries.sql
+ <pre>./sqlline.py <your_zookeeper_quorum>
+</pre>
+</div>
+<p>and issue a query </p>
+<div class="source">
+ <pre>SELECT state as "State",count(city) as "City Count",sum(population) as "Population Sum"
+FROM us_population
+GROUP BY state
+ORDER BY sum(population) DESC;
</pre>
</div>
<p>Congratulations! Youâve just created your first Phoenix table, inserted data into it, and executed an aggregate query with just a few lines of code in 15 minutes or less! </p>
Modified: phoenix/site/publish/building.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/building.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/building.html (original)
+++ phoenix/site/publish/building.html Thu Sep 9 05:55:04 2021
@@ -1,14 +1,14 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
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>Building Phoenix Project | Apache Phoenix</title>
+ <title>Building the Main Phoenix Project | 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" />
@@ -167,65 +167,31 @@
<div class="span12">
<div class="body-content">
<div class="page-header">
- <h1>Building Phoenix Project</h1>
+ <h1>Building the Main Phoenix Project</h1>
</div>
-<p>Phoenix is a fully mavenized project. Download <a href="source.html">source</a> and build simply by doing:</p>
+<p>Phoenix consists of several subprojects.</p>
+<p>The core of the project is the <tt>phoenix</tt> project, which depends on the <tt>phoenix-thirdparty</tt>, <tt>phoenix-omid</tt> and <tt>phoenix-tephra</tt> projects.</p>
+<p><tt>phoenix-queryserver</tt> and <tt>phoenix-connectors</tt> are optional packages that depend on the <tt>phoenix</tt> project.</p>
+<p>Check out the <a href="source.html">source</a> and follow the build instructions in BUILDING.md (or README.md) in the root directory.</p>
+<h1>Using Phoenix in a Maven Project</h1>
+<p>Phoenix is also hosted at Apache Maven Repository and Maven Central. You can add it to your mavenized project by adding the following to your pom:</p>
<div class="source">
- <pre>$ mvn package
-</pre>
-</div>
-<p>builds, runs fast unit tests and package Phoenix and put the resulting jars (phoenix-[version].jar and phoenix-[version]-client.jar) in the generated phoenix-core/target/ and phoenix-assembly/target/ directories respectively.</p>
-<p>To build, but skip running the fast unit tests, you can do:</p>
-<div class="source">
- <pre> $ mvn package -DskipTests
-</pre>
-</div>
-<p>To build against hadoop2, you can do:</p>
-<div class="source">
- <pre> $ mvn package -DskipTests -Dhadoop.profile=2
-</pre>
-</div>
-<p>To run all tests including long running integration tests</p>
-<div class="source">
- <pre> $ mvn install
-</pre>
-</div>
-<p>To only build the generated parser (i.e. <tt>PhoenixSQLLexer</tt> and <tt>PhoenixSQLParser</tt>), you can do:</p>
-<div class="source">
- <pre> $ mvn install -DskipTests
- $ mvn process-sources
-</pre>
-</div>
-<p>To build an Eclipse project, install the m2e plugin and do an File->Importâ¦->Import Existing Maven Projects selecting the root directory of Phoenix.</p>
-<div class="section">
- <h2 id="Maven">Maven</h2>
- <p>Phoenix is also hosted at Apache Maven Repository. You can add it to your mavenized project by adding the following to your pom:</p>
- <div class="source">
- <pre> <repositories>
- ...
- <repository>
- <id>apache release</id>
- <url>https://repository.apache.org/content/repositories/releases/</url>
- </repository>
- ...
- </repositories>
-
- <dependencies>
+ <pre> <dependencies>
...
<dependency>
<groupId>org.apache.phoenix</groupId>
- <artifactId>phoenix-core</artifactId>
- <version>[version]</version>
+ <artifactId>phoenix-client-hbase-[hbase.profile]</artifactId>
+ <version>[phoenix.version]</version>
</dependency>
...
</dependencies>
</pre>
- </div>
- <p>Note: [version] can be replaced by 3.1.0, 4.1.0, 3.0.0-incubating, 4.0.0-incubating, etc.</p>
</div>
+<p>Where [phoenix.version] is the phoenix release i.e 5.1.2 or 4.16.1, and [hbase.profile] is the supported HBase version, which you can see listed on the <a href="download.html">download</a> page.</p>
<div class="section">
<h2 id="Branches">Branches</h2>
- <p>Phoenix 3.0 is running against hbase0.94+, Phoenix 4.0 is running against hbase0.98.1+ and Phoenix master branch is running against hbase trunk branch.</p>
+ <p>The main Phoenix project currently has two active branches.</p>
+ <p>The 4.x branch works with HBase 1 and Hadoop 2, while the 5.x branch works with HBase 2 and Hadoop 3. See the <a href="download.html">download</a> page and BUILDING.md for the HBase versions supported by each release.</p>
<hr />
<p>See also: </p>
<p><a href="building_website.html">Building Project Web Site</a></p>
Modified: phoenix/site/publish/contributing.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/contributing.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/contributing.html (original)
+++ phoenix/site/publish/contributing.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -180,6 +180,7 @@
<li>Submit the patch</li>
</ol>
<p>These steps are explained in greater detail below.</p>
+ <p>Note that the instructions below are for the main Phoenix project. Use the corresponding <a href="source.html">repository</a> for the other subprojects. Tephra and Omid also have their own <a href="issues.html">JIRA project</a></p>
<div class="section">
<h3 id="Discuss_on_the_mailing_list">Discuss on the mailing list</h3>
<p>Itâs often best to discuss a change on the public mailing lists before creating and submitting a patch.</p>
Modified: phoenix/site/publish/develop.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/develop.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/develop.html (original)
+++ phoenix/site/publish/develop.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -172,6 +172,7 @@
<p>Below are the steps necessary to setup your development environment so that you may contribute to Apache Phoenix.</p>
<ul>
<li><a href="#gettingStarted">Getting Started</a></li>
+ <li><a href="#otherProjects">Other Phoenix subprojects</a></li>
<li><a href="#localGit">Setup local Git Repository</a></li>
<li><a href="#eclipse">Eclipse</a>
<ul>
@@ -216,6 +217,12 @@ export PATH=$M2_HOME/bin:$PATH
</pre>
</div></li>
</ol>
+ <p><a name="otherProjects" id="otherProjects"></a></p>
+</div>
+<div class="section">
+ <h2 id="Other_Phoenix_Subprojects">Other Phoenix Subprojects</h2>
+ <p>The instructions here are for the main Phoenix project. For the other subprojects, use the corresponding <a href="source.html">repository</a> and <a href="issues.html">JIRA project</a>.</p>
+ <p>The Eclipse and IntelliJ setup instructions may not necessarily work well for the other projects.</p>
<p><a name="localGit" id="localGit"></a></p>
</div>
<div class="section">
Modified: phoenix/site/publish/faq.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/faq.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/faq.html (original)
+++ phoenix/site/publish/faq.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -188,10 +188,10 @@
<div class="section">
<div class="section">
<h3 id="I_want_to_get_started._Is_there_a_Phoenix_Hello_World">I want to get started. Is there a Phoenix <i>Hello World</i>?</h3>
- <p><i>Pre-requisite:</i> Download latest Phoenix from <a href="download.html">here</a> and copy phoenix-*.jar to HBase lib folder and restart HBase.</p>
+ <p><i>Pre-requisite:</i> <a href="download.html">Download</a> and <a href="installation.html">install</a> the latest Phoenix.</p>
<p><b>1. Using console</b></p>
<ol style="list-style-type: decimal">
- <li>Start Sqlline: <tt>$ sqlline.py [zookeeper]</tt></li>
+ <li>Start Sqlline: <tt>$ sqlline.py [zookeeper quorum hosts]</tt></li>
<li>Execute the following statements when Sqlline connects:</li>
</ol>
<div class="source">
@@ -229,7 +229,7 @@ public class test {
Statement stmt = null;
ResultSet rset = null;
- Connection con = DriverManager.getConnection("jdbc:phoenix:[zookeeper]");
+ Connection con = DriverManager.getConnection("jdbc:phoenix:[zookeeper quorum hosts]");
stmt = con.createStatement();
stmt.executeUpdate("create table test (mykey integer not null primary key, mycolumn varchar)");
@@ -259,7 +259,7 @@ public class test {
<div class="section">
<h4 id="Thick_Driver">Thick Driver</h4>
<p>The Phoenix (Thick) Driver JDBC URL syntax is as follows (where elements in square brackets are optional):</p>
- <p><tt>jdbc:phoenix:[comma-separated ZooKeeper Quorum [:port [:hbase root znode [:kerberos_principal [:path to kerberos keytab] ] ] ]</tt></p>
+ <p><tt>jdbc:phoenix:[comma-separated ZooKeeper Quorum Hosts [: ZK port [:hbase root znode [:kerberos_principal [:path to kerberos keytab] ] ] ]</tt></p>
<p>The simplest URL is:</p>
<p><tt>jdbc:phoenix:localhost</tt></p>
<p>Whereas the most complicated URL is:</p>
@@ -315,7 +315,7 @@ public class test {
<p><tt>CREATE TABLE TEST (HOST VARCHAR NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR) SALT_BUCKETS=16</tt></p>
<p>Note: Ideally for a 16 region server cluster with quad-core CPUs, choose salt buckets between 32-64 for optimal performance.</p>
<ul>
- <li><b>Per-split</b> table Salting does automatic table splitting but in case you want to exactly control where table split occurs with out adding extra byte or change row key order then you can pre-split a table.</li>
+ <li><b>Pre-split</b> table Salting does automatic table splitting but in case you want to exactly control where table split occurs with out adding extra byte or change row key order then you can pre-split a table.</li>
</ul>
<p>Example: </p>
<p><tt>CREATE TABLE TEST (HOST VARCHAR NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR) SPLIT ON ('CS','EU','NA')</tt></p>
@@ -355,6 +355,7 @@ public class test {
</ul>
<p><tt>create index idx on test (col1) include (col2)</tt></p>
<p>Upsert rows in this test table and Phoenix query optimizer will choose correct index to use. You can see in <a href="language/index.html#explain">explain plan</a> if Phoenix is using the index table. You can also give a <a href="language/index.html#hint">hint</a> in Phoenix query to use a specific index.</p>
+ <p>See <a href="secondary_indexing.html">Secondary Indexing</a> for further information</p>
</div>
<div class="section">
<h3 id="Why_isnt_my_secondary_index_being_used">Why isnât my secondary index being used?</h3>
@@ -362,6 +363,7 @@ public class test {
<p>Example: DDL <tt>create table usertable (id varchar primary key, firstname varchar, lastname varchar); create index idx_name on usertable (firstname);</tt></p>
<p>Query: DDL <tt>select id, firstname, lastname from usertable where firstname = 'foo';</tt></p>
<p>Index would not be used in this case as lastname is not part of indexed or covered column. This can be verified by looking at the explain plan. To fix this create index that has either lastname part of index or covered column. Example: <tt>create idx_name on usertable (firstname) include (lastname);</tt></p>
+ <p>You can force Phoenix to use secondary for uncovered columns by specifying an <a href="index.html#index_hint">index hint</a></p>
</div>
<div class="section">
<h3 id="How_fast_is_Phoenix_Why_is_it_so_fast">How fast is Phoenix? Why is it so fast?</h3>
@@ -374,11 +376,13 @@ public class test {
</div>
<div class="section">
<h3 id="How_do_I_connect_to_secure_HBase_cluster">How do I connect to secure HBase cluster?</h3>
- <p>Check out excellent post by Anil Gupta <a class="externalLink" href="http://bigdatanoob.blogspot.com/2013/09/connect-phoenix-to-secure-hbase-cluster.html">http://bigdatanoob.blogspot.com/2013/09/connect-phoenix-to-secure-hbase-cluster.html</a></p>
+ <p>Specify the principal and corresponding keytab in the JDBC URL as show above. For ancient Phoenix versions heck out the excellent <a class="externalLink" href="http://bigdatanoob.blogspot.com/2013/09/connect-phoenix-to-secure-hbase-cluster.html">post</a> by Anil Gupta </p>
</div>
<div class="section">
- <h3 id="How_do_I_connect_with_HBase_running_on_Hadoop-2">How do I connect with HBase running on Hadoop-2?</h3>
- <p>Hadoop-2 profile exists in Phoenix pom.xml. </p>
+ <h3 id="What_HBase_and_Hadoop_versions_are_supported_">What HBase and Hadoop versions are supported ?</h3>
+ <p>Phoenix 4.x supports HBase 1.x running on Hadoop 2</p>
+ <p>Phoenix 5.x supports HBase 2.x running on Hadoop 3</p>
+ <p>See the release notes and BULDING.md in recent releases for the exact versions supported, and on how to build Phoenix for specific HBase and Hadoop versions</p>
</div>
<div class="section">
<h3 id="Can_phoenix_work_on_tables_with_arbitrary_timestamp_as_flexible_as_HBase_API">Can phoenix work on tables with arbitrary timestamp as flexible as HBase API?</h3>
Modified: phoenix/site/publish/index.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/index.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/index.html (original)
+++ phoenix/site/publish/index.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-07-05
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -198,7 +198,7 @@
<li>the flexibility of late-bound, schema-on-read capabilities from the NoSQL world by leveraging HBase as its backing store</li>
</ul>
<p>Apache Phoenix is fully integrated with other Hadoop products such as Spark, Hive, Pig, Flume, and Map Reduce.</p>
- <p> Who is using Apache Phoenix? Read more <a href="who_is_using.html">here...</a> </p>
+ <p> Who is using Apache Phoenix? Read more <a href="who_is_using.html">here...</a> </p>
</div>
<div class="section">
<h2 id="Mission">Mission</h2>
@@ -206,7 +206,7 @@
</div>
<div class="section">
<h2 id="Quick_Start">Quick Start</h2>
- <p>Tired of reading already and just want to get started? Take a look at our <a href="faq.html">FAQs</a>, listen to the Apache Phoenix talk from <a class="externalLink" href="https://www.youtube.com/watch?v=XGa0SyJMH94">Hadoop Summit 2015</a>, review the <a class="externalLink" href="http://phoenix.apache.org/presentations/OC-HUG-2014-10-4x3.pdf">overview presentation</a>, and jump over to our quick start guide <a href="Phoenix-in-15-minutes-or-less.html">here</a>.</p>
+ <p>Tired of reading already and just want to get started? Take a look at our <a href="faq.html">FAQs</a>, listen to the Apache Phoenix talk from <a class="externalLink" href="https://www.youtube.com/watch?v=XGa0SyJMH94">Hadoop Summit 2015</a>, review the <a href="/presentations/OC-HUG-2014-10-4x3.pdf">overview presentation</a>, and jump over to our quick start guide <a href="Phoenix-in-15-minutes-or-less.html">here</a>.</p>
</div>
<div class="section">
<h2 id="SQL_Support">SQL Support</h2>
Modified: phoenix/site/publish/installation.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/installation.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/installation.html (original)
+++ phoenix/site/publish/installation.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -172,10 +172,16 @@
</div>
<p>To install a pre-built phoenix, use these directions:</p>
<ul>
- <li>Download and expand the latest phoenix-[version]-bin.tar.</li>
- <li>Add the phoenix-[version]-server.jar to the classpath of all HBase region server and master and remove any previous version. An easy way to do this is to copy it into the HBase lib directory (use phoenix-core-[version].jar for Phoenix 3.x)</li>
+ <li><a href="download.html">Download</a> and expand the latest phoenix-hbase-[hbase.version][phoenix.version]-bin.tar.gz for your HBase version.</li>
+ <li>Add the phoenix-server-hbase-[hbase.version]-[phoenix.version].jar to the classpath of all HBase region servers and masters and remove any previous version. An easy way to do this is to copy it into the HBase lib directory</li>
<li>Restart HBase.</li>
- <li>Add the phoenix-[version]-client.jar to the classpath of any Phoenix client.</li>
+ <li>Add the phoenix-client-hbase-[hbase.version]-[phoenix.version].jar to the classpath of any JDBC client.</li>
+ </ul>
+ <p>To install Phoenix from source:</p>
+ <ul>
+ <li><a href="download.html">Download</a> and expand the latest phoenix-[phoenix.version]-src.tar.gz for your HBase version, or check it out from the main source <a href="source.html">repository</a></li>
+ <li>Follow the build instructions in BUILDING.md in the root directory of the source distribution/repository to build the binary assembly.</li>
+ <li>Follow the instructions above, but use the assembly built from source.</li>
</ul>
<div class="section">
<h3 id="Getting_Started">Getting Started</h3>
@@ -184,16 +190,16 @@
<h4 id="Command_Line">Command Line</h4>
<p>A terminal interface to execute SQL from the command line is now bundled with Phoenix. To start it, execute the following from the bin directory:</p>
<div class="source">
- <pre>$ sqlline.py localhost
+ <pre>$ sqlline.py [zk quorum hosts]
</pre>
</div>
<p>To execute SQL scripts from the command line, you can include a SQL file argument like this:</p>
<div class="source">
- <pre>$ sqlline.py localhost ../examples/stock_symbol.sql
+ <pre>$ sqlline.py [zk quorum hosts] ../examples/stock_symbol.sql
</pre>
</div>
<p><img src="images/sqlline.png" alt="sqlline" /></p>
- <p>For more information, see the <a class="externalLink" href="http://www.hydromatic.net/sqlline/manual.html">manual</a>.</p>
+ <p>For more information, see the <a class="externalLink" href="https://julianhyde.github.io/sqlline/manual.html">manual</a>.</p>
<div class="section">
<h5 id="Loading_Data">Loading Data</h5>
<p>In addition, you can use the bin/psql.py to load CSV data or execute SQL scripts. For example:</p>
@@ -210,7 +216,7 @@
</div>
</div>
<div class="section">
- <h4 id="SQL_Client">SQL Client</h4>
+ <h4 id="SQuirreL_SQL_Client">SQuirreL SQL Client</h4>
<p>If youâd rather use a client GUI to interact with Phoenix, download and install <a class="externalLink" href="http://squirrel-sql.sourceforge.net/">SQuirrel</a>. Since Phoenix is a JDBC driver, integration with tools such as this are seamless. Here are the setup steps necessary:</p>
<ol style="list-style-type: decimal">
<li>Remove prior phoenix-[<i>oldversion</i>]-client.jar from the lib directory of SQuirrel, copy phoenix-[<i>newversion</i>]-client.jar to the lib directory (<i>newversion</i> should be compatible with the version of the phoenix server jar used with your HBase installation)</li>
@@ -225,12 +231,12 @@
</ol>
<p>Through SQuirrel, you can issue SQL statements in the SQL tab (create tables, insert data, run queries), and inspect table metadata in the Object tab (i.e. list tables, their columns, primary keys, and types).</p>
<p><img src="images/squirrel.png" alt="squirrel" /></p>
+ <p>Note that most graphical clients that support generic JDBC drives should also work, and the setup process is usually similar.</p>
</div>
</div>
<div class="section">
<h3 id="Samples">Samples</h3>
<p>The best place to see samples are in our unit tests under src/test/java. The ones in the endToEnd package are tests demonstrating how to use all aspects of the Phoenix JDBC driver. We also have some examples in the examples directory.</p>
- <p><a class="externalLink" href="http://githalytics.com/forcedotcom/phoenix.git"><img src="https://cruel-carlota.pagodabox.com/33878dc7c0522eed32d2d54db9c59f78" alt="githalytics.com alpha" /></a></p>
</div>
</div>
</div>
Modified: phoenix/site/publish/issues.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/issues.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/issues.html (original)
+++ phoenix/site/publish/issues.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -172,8 +172,11 @@
<p>This project uses JIRA issue tracking and project management application. Issues, bugs, and feature requests should be submitted to the following:</p>
<hr />
<p><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX">https://issues.apache.org/jira/browse/PHOENIX</a></p>
+<p><a class="externalLink" href="https://issues.apache.org/jira/secure/CreateIssue!default.jspa">Create New Issue</a> | <a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX/?selectedTab=com.atlassian.jira.jira-projects-plugin:issues-panel">Existing Issues Summary</a> | <a class="externalLink" href="https://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&mode=hide&jqlQuery=project+%3D+PHOENIX">All Issues</a> | <a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX?selectedTab=com.atlassian.jira.jira-projects-plugin:roadmap-panel">Road Map</a></p>
<hr />
-<p><a class="externalLink" href="https://issues.apache.org/jira/secure/CreateIssue!default.jspa">Create New Issue</a> | <a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX/?selectedTab=com.atlassian.jira.jira-projects-plugin:issues-panel">Existing Issues Summary</a> | <a class="externalLink" href="https://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&mode=hide&jqlQuery=project+%3D+PHOENIX">All Issues</a> | <a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX?selectedTab=com.atlassian.jira.jira-projects-plugin:roadmap-panel">Road Map</a></p>
+<p>The Tephra and Omid sub-projects are using separate JIRA projects for historical reasons:</p>
+<p><a class="externalLink" href="https://issues.apache.org/jira/browse/TEPHRA">https://issues.apache.org/jira/browse/TEPHRA</a></p>
+<p><a class="externalLink" href="https://issues.apache.org/jira/browse/OMID">https://issues.apache.org/jira/browse/OMID</a></p>
</div>
</div>
</div>
Modified: phoenix/site/publish/language/datatypes.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/datatypes.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/language/datatypes.html (original)
+++ phoenix/site/publish/language/datatypes.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/language/functions.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/functions.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/language/functions.html (original)
+++ phoenix/site/publish/language/functions.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/language/index.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/index.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/language/index.html (original)
+++ phoenix/site/publish/language/index.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
Modified: phoenix/site/publish/multi-tenancy.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/multi-tenancy.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/multi-tenancy.html (original)
+++ phoenix/site/publish/multi-tenancy.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -215,7 +215,7 @@ SELECT * FROM base.event
WHERE event_type='L';
</pre>
</div>
- <p>The tenant_id column is neither visible nor accessible to a tenant-specific view. Any reference to it will cause a ColumnNotFoundException. Just like any other Phoenix view, whether or not this view is updatable is based on the rules explained <a href="views.html#Updatable_Views">here</a>. In addition, indexes may be added to tenant-specific views just like to regular tables and views (with <a class="externalLink" href="http://phoenix.apache.org/views.html#Limitations">these</a> limitations).</p>
+ <p>The tenant_id column is neither visible nor accessible to a tenant-specific view. Any reference to it will cause a ColumnNotFoundException. Just like any other Phoenix view, whether or not this view is updatable is based on the rules explained <a href="views.html#Updatable_Views">here</a>. In addition, indexes may be added to tenant-specific views just like to regular tables and views (with <a href="views.html#Limitations">these</a> limitations).</p>
</div>
<div class="section">
<h3 id="Tenant_Data_Isolation">Tenant Data Isolation</h3>
Modified: phoenix/site/publish/namspace_mapping.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/namspace_mapping.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/namspace_mapping.html (original)
+++ phoenix/site/publish/namspace_mapping.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -198,9 +198,9 @@
<h2 id="Grammer_Available">Grammer Available</h2>
<p>Following DDL statements can be used to interact with schema.</p>
<ul>
- <li> <p><a class="externalLink" href="https://phoenix.apache.org/language/index.html#create_schema">CREATE SCHEMA</a></p></li>
- <li> <p><a class="externalLink" href="https://phoenix.apache.org/language/index.html#use">USE SCHEMA</a></p></li>
- <li> <p><a class="externalLink" href="https://phoenix.apache.org/language/index.html#drop_schema">DROP SCHEMA</a> </p></li>
+ <li> <p><a href="language/index.html#create_schema">CREATE SCHEMA</a></p></li>
+ <li> <p><a href="language/index.html#use">USE SCHEMA</a></p></li>
+ <li> <p><a href="language/index.html#drop_schema">DROP SCHEMA</a> </p></li>
</ul>
</div>
<div class="section">
Modified: phoenix/site/publish/news.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/news.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/news.html (original)
+++ phoenix/site/publish/news.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -175,27 +175,27 @@
<div class="section">
<div class="section">
<div class="section">
- <h4 id="Phoenix_5.1.2_released_June_7_2021"><a class="externalLink" href="https://phoenix.apache.org/download.html">Phoenix 5.1.2 released</a> (June 7, 2021)</h4>
+ <h4 id="Phoenix_5.1.2_released_June_7_2021"><a href="download.html">Phoenix 5.1.2 released</a> (June 7, 2021)</h4>
<hr />
</div>
<div class="section">
- <h4 id="Phoenix_4.16.1_released_May_21_2021"><a class="externalLink" href="https://phoenix.apache.org/download.html">Phoenix 4.16.1 released</a> (May 21, 2021)</h4>
+ <h4 id="Phoenix_4.16.1_released_May_21_2021"><a href="download.html">Phoenix 4.16.1 released</a> (May 21, 2021)</h4>
<hr />
</div>
<div class="section">
- <h4 id="Monthly_Tech_Talks_started_March_4_2021"><a class="externalLink" href="https://phoenix.apache.org/tech_talks.html">Monthly Tech Talks started</a> (March 4, 2021)</h4>
+ <h4 id="Monthly_Tech_Talks_started_March_4_2021"><a href="tech_talks.html">Monthly Tech Talks started</a> (March 4, 2021)</h4>
<hr />
</div>
<div class="section">
- <h4 id="Phoenix_5.1.1_released_March_1_2021"><a class="externalLink" href="https://phoenix.apache.org/download.html">Phoenix 5.1.1 released</a> (March 1, 2021)</h4>
+ <h4 id="Phoenix_5.1.1_released_March_1_2021"><a href="download.html">Phoenix 5.1.1 released</a> (March 1, 2021)</h4>
<hr />
</div>
<div class="section">
- <h4 id="Phoenix_4.16.0_released_February_23_2020"><a class="externalLink" href="https://phoenix.apache.org/download.html">Phoenix 4.16.0 released</a> (February 23, 2020)</h4>
+ <h4 id="Phoenix_4.16.0_released_February_23_2020"><a href="download.html">Phoenix 4.16.0 released</a> (February 23, 2020)</h4>
<hr />
</div>
<div class="section">
- <h4 id="Phoenix_5.1.0_released_February_10_2020"><a class="externalLink" href="https://phoenix.apache.org/download.html">Phoenix 5.1.0 released</a> (February 10, 2020)</h4>
+ <h4 id="Phoenix_5.1.0_released_February_10_2020"><a href="download.html">Phoenix 5.1.0 released</a> (February 10, 2020)</h4>
<hr />
</div>
<div class="section">
@@ -207,7 +207,7 @@
<hr />
</div>
<div class="section">
- <h4 id="PhoenixCon_2018_announced_for_June_18th_2018_March_24_2018"><a class="externalLink" href="https://phoenix.apache.org/phoenixcon-2018">PhoenixCon 2018 announced for June 18th, 2018</a> (March 24, 2018)</h4>
+ <h4 id="PhoenixCon_2018_announced_for_June_18th_2018_March_24_2018"><a href="phoenixcon-2018">PhoenixCon 2018 announced for June 18th, 2018</a> (March 24, 2018)</h4>
<hr />
</div>
<div class="section">
@@ -251,7 +251,7 @@
<hr />
</div>
<div class="section">
- <h4 id="Announcing_transaction_support_in_4.7.0_release_March_10_2016"><a class="externalLink" href="http://phoenix.apache.org/transactions.html">Announcing transaction support in 4.7.0 release</a> (March 10, 2016)</h4>
+ <h4 id="Announcing_transaction_support_in_4.7.0_release_March_10_2016"><a href="transactions.html">Announcing transaction support in 4.7.0 release</a> (March 10, 2016)</h4>
<hr />
</div>
<div class="section">
Modified: phoenix/site/publish/performance.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/performance.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/performance.html (original)
+++ phoenix/site/publish/performance.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -169,6 +169,7 @@
<div class="page-header">
<h1>Performance</h1>
</div>
+<p><span id="alerts" style="background-color:#ffc; text-align: center;display: block;padding:10px; border-bottom: solid 1px #cc9"> This page hasnât been updated recently, and may not reflect the current state of the project</span></p>
<p>Phoenix follows the philosophy of <b>bringing the computation to the data</b> by using:</p>
<ul>
<li><b>coprocessors</b> to perform operations on the server-side thus minimizing client/server data transfer</li>
Modified: phoenix/site/publish/phoenix_spark.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_spark.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_spark.html (original)
+++ phoenix/site/publish/phoenix_spark.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -616,7 +616,7 @@ val firstCol = rdd.first()("COL1&qu
</div>
<div class="section">
<h4 id="Saving_RDDs_to_Phoenix">Saving RDDs to Phoenix</h4>
- <p><tt>saveToPhoenix</tt> is an implicit method on RDD[Product], or an RDD of Tuples. The data types must correspond to the Java types Phoenix supports (<a class="externalLink" href="http://phoenix.apache.org/language/datatypes.html">http://phoenix.apache.org/language/datatypes.html</a>)</p>
+ <p><tt>saveToPhoenix</tt> is an implicit method on RDD[Product], or an RDD of Tuples. The data types must correspond to the Java types Phoenix supports (language/datatypes.html)</p>
<p>Given a Phoenix table with the following DDL:</p>
<div class="source">
<pre>CREATE TABLE OUTPUT_TEST_TABLE (id BIGINT NOT NULL PRIMARY KEY, col1 VARCHAR, col2 INTEGER);
Modified: phoenix/site/publish/python.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/python.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/python.html (original)
+++ phoenix/site/publish/python.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -183,7 +183,7 @@
</div>
<div class="section">
<h3 id="From_source">From source</h3>
- <p>You can build phoenixdb from the official source <a class="externalLink" href="https://phoenix.apache.org/download.html">release</a>, or you can use the latest development version from the soure <a class="externalLink" href="https://phoenix.apache.org/source.html">repository</a>. The pythondb source lives in the <tt>python-phoenixdb</tt> direcory of the python-queryserver repository.</p>
+ <p>You can build phoenixdb from the official source <a href=".html">release</a>, or you can use the latest development version from the soure <a href="source.html">repository</a>. The pythondb source lives in the <tt>python-phoenixdb</tt> direcory of the python-queryserver repository.</p>
<div class="source">
<pre>$ cd python-phoenixdb # (Only when building from the git repo)
$ pip install -r requirements.txt
Modified: phoenix/site/publish/recent.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/recent.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/recent.html (original)
+++ phoenix/site/publish/recent.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -169,12 +169,13 @@
<div class="page-header">
<h1>New Features</h1>
</div>
+<p><span id="alerts" style="background-color:#ffc; text-align: center;display: block;padding:10px; border-bottom: solid 1px #cc9"> This page hasnât been updated recently, and may be missing relevant information for current releases</span></p>
<p>As items are implemented from our road map, they are moved here to track the progress weâve made:</p>
<ol style="list-style-type: decimal">
<li><b><a href="tablesample.html">Table Sampling</a></b>. Support the <tt>TABLESAMPLE</tt> clause by implementing a filter that uses the guideposts established by stats gathering to only return a percentage of the rows. <b>Available in our 4.12 release</b></li>
- <li><b><a class="externalLink" href="https://phoenix.apache.org/columnencoding.html">Reduce on disk storage</a></b>. Reduce on disk storage to improve performance by a) packing all values into a single cell per column family and b) provide an indirection between the column name and the column qualifier. <b>Available in our 4.10 release</b></li>
- <li><b><a class="externalLink" href="https://phoenix.apache.org/atomic_upsert.html">Atomic update</a></b>. Atomic update is now possible in the UPSERT VALUES statement in support of counters and other use cases. <b>Available in our 4.9 release</b></li>
- <li><b><a class="externalLink" href="https://phoenix.apache.org/language/index.html#column_def">DEFAULT declaration</a></b>. When defining a column it is now possible to provide a DEFAULT declaration for the initial value. <b>Available in our 4.9 release</b></li>
+ <li><b><a href="columnencoding.html">Reduce on disk storage</a></b>. Reduce on disk storage to improve performance by a) packing all values into a single cell per column family and b) provide an indirection between the column name and the column qualifier. <b>Available in our 4.10 release</b></li>
+ <li><b><a href="atomic_upsert.html">Atomic update</a></b>. Atomic update is now possible in the UPSERT VALUES statement in support of counters and other use cases. <b>Available in our 4.9 release</b></li>
+ <li><b><a href="language/index.html#column_def">DEFAULT declaration</a></b>. When defining a column it is now possible to provide a DEFAULT declaration for the initial value. <b>Available in our 4.9 release</b></li>
<li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1311">Namespace Mapping</a></b>. Maps Phoenix schema to HBase namespace to improve isolation between different schemas. <b>Available in our 4.8 release</b></li>
<li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-2743">Hive Integration</a></b>. Enables Hive to be used with Phoenix in support of joining huge tables to other huge tables. <b>Available in our 4.8 release</b></li>
<li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1734">Local Index Improvements</a></b>. Reworked local index implementation to guarantee colocation of table and index data and use supported HBase APIs for better maintainability. <b>Available in our 4.8 release</b></li>
Modified: phoenix/site/publish/release.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/release.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/release.html (original)
+++ phoenix/site/publish/release.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -273,7 +273,7 @@ mvn versions:set -DnewVersion=4.16.0-HBa
</pre>
</div></li>
<li>If releasing Phoenix (core) Create a JIRA to update PHOENIX_MAJOR_VERSION, PHOENIX_MINOR_VERSION and PHOENIX_PATCH_NUMBER in MetaDataProtocol.java appropriately to next version (4, 16, 0 respectively in this case) and compatible_client_versions.json file with the client versions that are compatible against the next version ( In this case 4.14.3 and 4.15.0 would be the backward compatible clients for 4.16.0 ). This Jira should be committed/marked with fixVersion of the next release candidate.</li>
- <li>Add documentation of released version to the <a class="externalLink" href="http://phoenix.apache.org/download.html">downloads page</a> and <a class="externalLink" href="https://en.wikipedia.org/wiki/Apache_Phoenix">wiki</a>.</li>
+ <li>Add documentation of released version to the <a href="download.html">downloads page</a> and <a class="externalLink" href="https://en.wikipedia.org/wiki/Apache_Phoenix">wiki</a>.</li>
<li>Send out an announcement email. See example <a class="externalLink" href="https://www.mail-archive.com/dev@phoenix.apache.org/msg54764.html">here</a>.</li>
<li>Bulk close Jiras that were marked for the release fixVersion.</li>
</ol>
Modified: phoenix/site/publish/release_notes.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/release_notes.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/release_notes.html (original)
+++ phoenix/site/publish/release_notes.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -185,7 +185,7 @@
</div>
<div class="section">
<h3 id="Phoenix-4.8.0_Release_Notes"><u>Phoenix-4.8.0 Release Notes</u></h3>
- <p><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-3164">PHOENIX-3164</a> is a relatively serious bug that affects the <a class="externalLink" href="http://phoenix.apache.org/server.html">Phoenix Query Server</a> deployed with âsecurity enabledâ (Kerberos or Active Directory). Due to another late-game change in the 4.8.0 release as well as an issue with the use of Hadoopâs UserGroupInformation class, every âclient sessionâ to the Phoenix Query Server with security enabled will result in a new instance of the Phoenix JDBC driver <tt>PhoenixConnection</tt> (and other related classes). This ultimately results in a new connection to ZooKeeper for each âclient sessionâ.</p>
+ <p><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-3164">PHOENIX-3164</a> is a relatively serious bug that affects the <a href="server.html">Phoenix Query Server</a> deployed with âsecurity enabledâ (Kerberos or Active Directory). Due to another late-game change in the 4.8.0 release as well as an issue with the use of Hadoopâs UserGroupInformation class, every âclient sessionâ to the Phoenix Query Server with security enabled will result in a new instance of the Phoenix JDBC driver <tt>PhoenixConnection</tt> (and other related classes). This ultimately results in a new connection to ZooKeeper for each âclient sessionâ.</p>
<p>Within a short amount of time of active use with the Phoenix Query Server creating a new ZooKeeper connection for each âclient sessionâ, the number of ZooKeeper connections will have grown rapidly likely triggering ZooKeeperâs built-in denial of service protection (<a class="externalLink" href="https://zookeeper.apache.org/doc/r3.4.8/zookeeperAdmin.html">maxClientCnxns</a>). This will cause all future connections to ZooKeeper by the host running the Phoenix Query Server to be dropped. This would prevent all HBase client API calls which need to access ZooKeeper from completing.</p>
<p>As part of <a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-1734">PHOENIX-1734</a> we have changed the local index implementation to store index data in the separate column families in the same data table. So while upgrading the phoenix at server we need to remove below local index related configurations from <tt>hbase-site.xml</tt> and run upgrade steps mentioned <a href="secondary_indexing.html#Upgrading_Local_Indexes_created_before_4.8.0">here</a></p>
<div class="source">
Modified: phoenix/site/publish/resources.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/resources.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/resources.html (original)
+++ phoenix/site/publish/resources.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -169,7 +169,7 @@
<div class="page-header">
<h1>Presentations</h1>
</div>
-<p>Below are some prior presentations that have been done on Apache Phoenix. Another good source of information is the Apache Phoenix <a class="externalLink" href="https://blogs.apache.org/phoenix/">blog</a>.</p>
+<p>Below are some prior presentations that have been done on Apache Phoenix. Another good source of information is the Apache Phoenix <a class="externalLink" href="https://blogs.apache.org/phoenix/">blog</a> and the <a href="tech_talks.html">Phoenix Tech Talks</a>.</p>
<table border="0" class="bodyTable table table-striped table-hover">
<thead>
<tr class="a">
@@ -182,7 +182,7 @@
<tbody>
<tr class="b">
<td>Drillix: Apache Phoenix + Apache Drill </td>
- <td><a class="externalLink" href="http://phoenix.apache.org/presentations/Drillix.pdf">Slides</a> </td>
+ <td><a href="presentations/Drillix.pdf">Slides</a> </td>
<td>Salesforce.com </td>
<td>2016 </td>
</tr>
@@ -194,7 +194,7 @@
</tr>
<tr class="b">
<td>High Performance Clickstream Analytics with Apache HBase/Phoenix </td>
- <td><a class="externalLink" href="http://phoenix.apache.org/presentations/StrataHadoopWorld.pdf">Slides</a> </td>
+ <td><a href="presentations/StrataHadoopWorld.pdf">Slides</a> </td>
<td>Strata + Hadoop World </td>
<td>2016 </td>
</tr>
@@ -206,13 +206,13 @@
</tr>
<tr class="b">
<td>Lightning Talk for Apache Phoenix </td>
- <td><a class="externalLink" href="http://phoenix.apache.org/presentations/HPTS.pdf">Slides</a> </td>
+ <td><a href="presentations/HPTS.pdf">Slides</a> </td>
<td>HPTS </td>
<td>2015 </td>
</tr>
<tr class="a">
<td>Tuning Phoenix and HBase for OLTP </td>
- <td><a class="externalLink" href="http://phoenix.apache.org/presentations/TuningForOLTP.pdf">Slides</a> </td>
+ <td><a href="presentations/TuningForOLTP.pdf">Slides</a> </td>
<td>Tuning Presentation </td>
<td>2015 </td>
</tr>
@@ -224,43 +224,43 @@
</tr>
<tr class="a">
<td>Apache Phoenix: The Evolution of a Relational Database Layer over HBase </td>
- <td><a class="externalLink" href="http://phoenix.apache.org/presentations/HBaseCon2015-16x9.pdf">Slides</a> </td>
+ <td><a href="presentations/HBaseCon2015-16x9.pdf">Slides</a> </td>
<td>HBaseCon </td>
<td>2015 </td>
</tr>
<tr class="b">
<td>Apache Phoenix: Transforming HBase into a Relational Database </td>
- <td><a class="externalLink" href="http://phoenix.apache.org/presentations/OC-HUG-2014-10-4x3.pdf">Slides</a> </td>
+ <td><a href="presentations/OC-HUG-2014-10-4x3.pdf">Slides</a> </td>
<td>OC Hadoop User Group </td>
<td>2014 </td>
</tr>
<tr class="a">
<td>Apache Phoenix: Transforming HBase into a SQL database </td>
- <td><a class="externalLink" href="http://phoenix.apache.org/presentations/HadoopSummit2014-16x9.pdf">Slides</a>, <a class="externalLink" href="https://www.youtube.com/watch?v=f4Nmh5KM6gI&feature=youtu.be">Video</a> </td>
+ <td><a href="presentations/HadoopSummit2014-16x9.pdf">Slides</a>, <a class="externalLink" href="https://www.youtube.com/watch?v=f4Nmh5KM6gI&feature=youtu.be">Video</a> </td>
<td>Hadoop Summit </td>
<td>2014 </td>
</tr>
<tr class="b">
<td>Taming HBase with Apache Phoenix and SQL </td>
- <td><a class="externalLink" href="http://phoenix.apache.org/presentations/HBaseCon2014-16x9.pdf">Slides</a>, <a class="externalLink" href="http://vimeo.com/98485780">Video</a> </td>
+ <td><a href="presentations/HBaseCon2014-16x9.pdf">Slides</a>, <a class="externalLink" href="http://vimeo.com/98485780">Video</a> </td>
<td>HBaseCon </td>
<td>2014 </td>
</tr>
<tr class="a">
<td>How Apache Phoenix enables interactive, low latency applications over HBase </td>
- <td><a class="externalLink" href="http://phoenix.apache.org/presentations/ApacheCon2014-16x9.pdf">Slides</a>, <a class="externalLink" href="https://www.youtube.com/watch?v=9qfBnFyKZwM">Video</a> </td>
+ <td><a href="presentations/ApacheCon2014-16x9.pdf">Slides</a>, <a class="externalLink" href="https://www.youtube.com/watch?v=9qfBnFyKZwM">Video</a> </td>
<td>ApacheCon </td>
<td>2014 </td>
</tr>
<tr class="b">
<td>How (and why) Phoenix puts the SQL back into NoSQL </td>
- <td><a class="externalLink" href="http://phoenix.apache.org/presentations/HadoopSummit2013-16x9.pdf">Slides</a>, <a class="externalLink" href="http://www.youtube.com/watch?v=YHsHdQ08trg">Video</a> </td>
+ <td><a href="presentations/HadoopSummit2013-16x9.pdf">Slides</a>, <a class="externalLink" href="http://www.youtube.com/watch?v=YHsHdQ08trg">Video</a> </td>
<td>Hadoop Summit </td>
<td>2013 </td>
</tr>
<tr class="a">
<td>How (and why) Phoenix puts the SQL back into NoSQL </td>
- <td><a class="externalLink" href="http://phoenix.apache.org/presentations/HBaseCon2013-4x3.pdf">Slides</a>, <a class="externalLink" href="http://www.cloudera.com/content/cloudera/en/resources/library/hbasecon/hbasecon-2013--how-and-why-phoenix-puts-the-sql-back-into-nosql-video.html">Video</a> </td>
+ <td><a href="presentations/HBaseCon2013-4x3.pdf">Slides</a>, <a class="externalLink" href="http://www.cloudera.com/content/cloudera/en/resources/library/hbasecon/hbasecon-2013--how-and-why-phoenix-puts-the-sql-back-into-nosql-video.html">Video</a> </td>
<td>HBaseCon </td>
<td>2013 </td>
</tr>
@@ -269,8 +269,8 @@
<div class="section">
<h2 id="PhoenixCon">PhoenixCon</h2>
<p>PhoenixCon is a developer-focused event available to the public. The event is comprised of users and developers giving presentations about how they are using Apache Phoenix or new features coming to the project.</p>
- <p>For previous presentations given at PhoenixCon events, please refer to the <a class="externalLink" href="https://phoenix.apache.org/phoenixcon-archives.html">archives</a>.</p>
- <p>See the following for more information about <a class="externalLink" href="https://phoenix.apache.org/phoenixcon-2018/">PhoenixCon 2018</a>.</p>
+ <p>For previous presentations given at PhoenixCon events, please refer to the <a href="phoenixcon-archives.html">archives</a>.</p>
+ <p>See the following for more information about <a href="phoenixcon-2018/">PhoenixCon 2018</a>.</p>
</div>
</div>
</div>
Modified: phoenix/site/publish/roadmap.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/roadmap.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/roadmap.html (original)
+++ phoenix/site/publish/roadmap.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -169,6 +169,7 @@
<div class="page-header">
<h1>Roadmap</h1>
</div>
+<p><span id="alerts" style="background-color:#ffc; text-align: center;display: block;padding:10px; border-bottom: solid 1px #cc9"> This page hasnât been updated recently, and may not reflect the current state of the project</span></p>
<p>Our roadmap is driven by our user community. Below, in prioritized order, is the current plan for Phoenix:</p>
<ol style="list-style-type: decimal">
<li><b><a class="externalLink" href="https://issues.apache.org/jira/browse/PHOENIX-3146">Stress and chaos testing</a></b>. Open source and automate the running of stress and chaos tests that exercise Phoenix and HBase under high load and failure conditions.</li>
Modified: phoenix/site/publish/secondary_indexing.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/secondary_indexing.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/secondary_indexing.html (original)
+++ phoenix/site/publish/secondary_indexing.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -338,9 +338,9 @@ CREATE LOCAL INDEX my_index ON my_table
<li>Delete the data table rows</li>
<li>Delete index table rows</li>
</ol>
- <p>See <a class="externalLink" href="http://phoenix.apache.org/secondary_indexing.html#Resources">resources</a> for more in-depth information.</p>
+ <p>See <a href="secondary_indexing.html#Resources">resources</a> for more in-depth information.</p>
<p>All newly created tables use the new indexing algorithm.</p>
- <p>Indexes created with older Phoenix versions will continue to use the old implementation, until upgraded with <a class="externalLink" href="http://phoenix.apache.org/secondary_indexing.html#Index_Upgrade_Tool">IndexUpgradeTool</a></p>
+ <p>Indexes created with older Phoenix versions will continue to use the old implementation, until upgraded with <a href="secondary_indexing.html#Index_Upgrade_Tool">IndexUpgradeTool</a></p>
</div>
<div class="section">
<h4 id="Mutable_table_indexes_for_4.14_and_5.0_and_older_versions">Mutable table indexes for 4.14 (and 5.0) and older versions</h4>
@@ -387,7 +387,7 @@ CREATE LOCAL INDEX my_index ON my_table
</div>
<div class="section">
<h5 id="Disable_mutable_index_on_write_failure_with_manual_rebuild_required">Disable mutable index on write failure with manual rebuild required</h5>
- <p>This is the lowest level of consistency for mutable secondary indexes. In this case, when a write to a secondary index fails, the index will be marked as disabled with a manual <a class="externalLink" href="http://phoenix.apache.org/language/index.html#alter_index">rebuild of the index</a> required to enable it to be used once again by queries.</p>
+ <p>This is the lowest level of consistency for mutable secondary indexes. In this case, when a write to a secondary index fails, the index will be marked as disabled with a manual <a href="language/index.html#alter_index">rebuild of the index</a> required to enable it to be used once again by queries.</p>
<p>The following server-side configurations controls this behavior:</p>
<ul>
<li><tt>phoenix.index.failure.handling.rebuild</tt> must be set to false to disable a mutable index from being rebuilt in the background in the event of a commit failure.</li>
@@ -460,7 +460,7 @@ CREATE LOCAL INDEX my_index ON my_table
</div>
<div class="section">
<h3 id="Upgrading_Local_Indexes_created_before_4.8.0">Upgrading Local Indexes created before 4.8.0</h3>
- <p>While upgrading the Phoenix to 4.8.0+ version at server remove above three local indexing related configurations from <tt>hbase-site.xml</tt> if present. From client we are supporting both online(while initializing the connection from phoenix client of 4.8.0+ versions) and offline(using psql tool) upgrade of local indexes created before 4.8.0. As part of upgrade we recreate the local indexes in ASYNC mode. After upgrade user need to build the indexes using <a class="externalLink" href="http://phoenix.apache.org/secondary_indexing.html#Index_Population">IndexTool</a></p>
+ <p>While upgrading the Phoenix to 4.8.0+ version at server remove above three local indexing related configurations from <tt>hbase-site.xml</tt> if present. From client we are supporting both online(while initializing the connection from phoenix client of 4.8.0+ versions) and offline(using psql tool) upgrade of local indexes created before 4.8.0. As part of upgrade we recreate the local indexes in ASYNC mode. After upgrade user need to build the indexes using <a href="secondary_indexing.html#Index_Population">IndexTool</a></p>
<p>Following client side configuration used in the upgrade.</p>
<ol style="list-style-type: decimal">
<li><tt>phoenix.client.localIndexUpgrade</tt>
Modified: phoenix/site/publish/sequences.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/sequences.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/sequences.html (original)
+++ phoenix/site/publish/sequences.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -174,7 +174,7 @@
<pre>CREATE SEQUENCE my_schema.my_sequence;
</pre>
</div>
-<p>This will create a sequence named <tt>my_schema.my_sequence</tt> with the an initial sequence value of 1, incremented by 1 each time, with no cycle, minimum value or maximum value, and 100 sequence values cached on your session (determined by the <tt>phoenix.sequence.cacheSize</tt> config parameter). The complete syntax of <tt>CREATE SEQUENCE</tt> may be found <a class="externalLink" href="http://phoenix.apache.org/language/index.html#create_sequence">here</a>.</p>
+<p>This will create a sequence named <tt>my_schema.my_sequence</tt> with the an initial sequence value of 1, incremented by 1 each time, with no cycle, minimum value or maximum value, and 100 sequence values cached on your session (determined by the <tt>phoenix.sequence.cacheSize</tt> config parameter). The complete syntax of <tt>CREATE SEQUENCE</tt> may be found <a href="language/index.html#create_sequence">here</a>.</p>
<p>Caching sequence values on your session improves performance, as we donât need to ask the server for more sequence values until we run out of cached values. The tradeoff is that you may end up with gaps in your sequence values when other sessions also use the same sequence.</p>
<p>All of these parameters can be overridden when the sequence is created like this:</p>
<div class="source">
Modified: phoenix/site/publish/server.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/server.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/server.html (original)
+++ phoenix/site/publish/server.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -178,7 +178,7 @@
<div class="section">
<h3 id="Clients">Clients</h3>
<p>The primary client implementation is currently a JDBC driver with minimal dependencies. The default and primary transport mechanism since Phoenix 4.7 is Protobuf, the older JSON mechanism can still be enabled. The distribution includes the sqlline-thin.py CLI client that uses the JDBC thin client.</p>
- <p>The Phoenix project also maintains the Python driver <a class="externalLink" href="https://phoenix.apache.org/python.html">phoenixdb</a>.</p>
+ <p>The Phoenix project also maintains the Python driver <a href="python.html">phoenixdb</a>.</p>
<p>The Avatica <a class="externalLink" href="https://calcite.apache.org/avatica/docs/go_client_reference.html">Go client</a> can also be used.</p>
<p>Proprietary ODBC drivers are also available for Windows and Linux.</p>
</div>
@@ -187,7 +187,7 @@
<h2 id="Installation">Installation</h2>
<p>In the 4.4-4.14 and 5.0 releases the query server and its JDBC client are part of the standard Phoenix distribution. They require no additional dependencies or installation.</p>
<p>After the 4.15 and 5.1 release, the query server has been unbundled into the phoenix-queryserver repository, and its version number has been reset to 6.0.</p>
- <p>Download the latest source or binary release from the <a class="externalLink" href="https://phoenix.apache.org/download.html">Download page</a>, or check out the development version from <a class="externalLink" href="https://github.com/apache/phoenix-queryserver">github</a></p>
+ <p>Download the latest source or binary release from the <a href="/download.html">Download page</a>, or check out the development version from <a class="externalLink" href="https://github.com/apache/phoenix-queryserver">github</a></p>
<p>Either unpack the binary distribution, or build it from source. See BUILDING.md in the source distribution on how to build.</p>
</div>
<div class="section">
@@ -251,7 +251,7 @@
</div>
<div class="section">
<h2 id="Metrics">Metrics</h2>
- <p>By default, the Phoenix Query Server exposes various Phoenix global client metrics via JMX (for HBase versions 1.3 and up). The list of metrics are available <a class="externalLink" href="https://phoenix.apache.org/metrics.html">here</a>.</p>
+ <p>By default, the Phoenix Query Server exposes various Phoenix global client metrics via JMX (for HBase versions 1.3 and up). The list of metrics are available <a href="metrics.html">here</a>.</p>
<p>PQS Metrics use <a class="externalLink" href="https://hadoop.apache.org/docs/current/hadoop-project-dist/hadoop-common/Metrics.html">Hadoop Metrics 2</a> internally for metrics publishing. Hence it publishes various JVM related metrics. Metrics can be filtered based on certain tags, which can be configured by the property specified in hbase-site.xml on the classpath. Further details are provided in Configuration section.</p>
</div>
<div class="section">
Modified: phoenix/site/publish/tuning_guide.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/tuning_guide.html?rev=1893163&r1=1893162&r2=1893163&view=diff
==============================================================================
--- phoenix/site/publish/tuning_guide.html (original)
+++ phoenix/site/publish/tuning_guide.html Thu Sep 9 05:55:04 2021
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2021-08-27
+ Generated by Apache Maven Doxia at 2021-09-08
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -204,7 +204,7 @@
<li>For write-heavy data:
<ul>
<li>Pre-split the table. It can be helpful to split the table into pre-defined regions, or if the keys are monotonically increasing use salting to to avoid creating write hotspots on a small number of nodes. Use real data types rather than raw byte data.</li>
- <li>Create local indexes. Reads from local indexes have a performance penalty, so itâs important to do performance testing. See the <a class="externalLink" href="https://phoenix.apache.org/pherf.html">Pherf</a> tool.</li>
+ <li>Create local indexes. Reads from local indexes have a performance penalty, so itâs important to do performance testing. See the <a href="pherf.html">Pherf</a> tool.</li>
</ul></li>
</ul>
</div>
@@ -220,11 +220,11 @@
<div class="section">
<h3 id="Can_the_data_be_append-only_immutable">Can the data be append-only (immutable)?</h3>
<ul>
- <li>If the data is immutable or append-only, declare the table and its indexes as immutable using the <tt>IMMUTABLE_ROWS</tt> <a class="externalLink" href="http://phoenix.apache.org/language/index.html#options">option</a> at creation time to reduce the write-time cost. If you need to make an existing table immutable, you can do so with <tt>ALTER TABLE trans.event SET IMMUTABLE_ROWS=true</tt> after creation time.
+ <li>If the data is immutable or append-only, declare the table and its indexes as immutable using the <tt>IMMUTABLE_ROWS</tt> <a href="language/index.html#options">option</a> at creation time to reduce the write-time cost. If you need to make an existing table immutable, you can do so with <tt>ALTER TABLE trans.event SET IMMUTABLE_ROWS=true</tt> after creation time.
<ul>
- <li>If speed is more important than data integrity, you can use the <tt>DISABLE_WAL</tt> <a class="externalLink" href="http://phoenix.apache.org/language/index.html#options">option</a>. Note: it is possible to lose data with <tt>DISABLE_WAL</tt> if a region server fails.</li>
+ <li>If speed is more important than data integrity, you can use the <tt>DISABLE_WAL</tt> <a href="language/index.html#options">option</a>. Note: it is possible to lose data with <tt>DISABLE_WAL</tt> if a region server fails.</li>
</ul></li>
- <li>Set the <tt>UPDATE_CACHE_FREQUENCY</tt> <a class="externalLink" href="http://phoenix.apache.org/language/index.html#options">option</a> to 15 minutes or so if your metadata doesnât change very often. This property determines how often an RPC is done to ensure youâre seeing the latest schema.</li>
+ <li>Set the <tt>UPDATE_CACHE_FREQUENCY</tt> <a href="language/index.html#options">option</a> to 15 minutes or so if your metadata doesnât change very often. This property determines how often an RPC is done to ensure youâre seeing the latest schema.</li>
<li>If the data is not sparse (over 50% of the cells have values), use the SINGLE_CELL_ARRAY_WITH_OFFSETS data encoding scheme introduced in Phoenix 4.10, which obtains faster performance by reducing the size of the data. For more information, see â<a class="externalLink" href="https://blogs.apache.org/phoenix/entry/column-mapping-and-immutable-data">Column Mapping and Immutable Data Encoding</a>â on the Apache Phoenix blog.</li>
</ul>
</div>
@@ -232,14 +232,14 @@
<h3 id="Is_the_table_very_large">Is the table very large?</h3>
<ul>
<li>Use the <tt>ASYNC</tt> keyword with your <tt>CREATE INDEX</tt> call to create the index asynchronously via MapReduce job. Youâll need to manually start the job; see <a class="externalLink" href="https://phoenix.apache.org/secondary_indexing.html#Index_Population">https://phoenix.apache.org/secondary_indexing.html#Index_Population</a> for details.</li>
- <li>If the data is too large to scan the table completely, use primary keys to create an underlying composite row key that makes it easy to return a subset of the data or facilitates <a class="externalLink" href="https://phoenix.apache.org/skip_scan.html">skip-scanning</a>âPhoenix can jump directly to matching keys when the query includes key sets in the predicate.</li>
+ <li>If the data is too large to scan the table completely, use primary keys to create an underlying composite row key that makes it easy to return a subset of the data or facilitates <a href="skip_scan.html">skip-scanning</a>âPhoenix can jump directly to matching keys when the query includes key sets in the predicate.</li>
</ul>
</div>
<div class="section">
<h3 id="Is_transactionality_required">Is transactionality required?</h3>
<p>A transaction is a data operation that is atomicâthat is, guaranteed to succeed completely or not at all. For example, if you need to make cross-row updates to a data table, then you should consider your data transactional.</p>
<ul>
- <li>If you need transactionality, use the <tt>TRANSACTIONAL</tt> <a class="externalLink" href="http://phoenix.apache.org/language/index.html#options">option</a>. (See also <a class="externalLink" href="http://phoenix.apache.org/transactions.html.">http://phoenix.apache.org/transactions.html.</a>)</li>
+ <li>If you need transactionality, use the <tt>TRANSACTIONAL</tt> <a href="language/index.html#options">option</a>. (See also <a class="externalLink" href="http://phoenix.apache.org/transactions.html.">http://phoenix.apache.org/transactions.html.</a>)</li>
</ul>
</div>
<div class="section">
@@ -257,7 +257,7 @@
</div>
<div class="section">
<h2 id="Column_Families">Column Families</h2>
- <p>If some columns are accessed more frequently than others, <a class="externalLink" href="https://phoenix.apache.org/faq.html#Are_there_any_tips_for_optimizing_Phoenix">create multiple column families</a> to separate the frequently-accessed columns from rarely-accessed columns. This improves performance because HBase reads only the column families specified in the query.</p>
+ <p>If some columns are accessed more frequently than others, <a href="faq.html#Are_there_any_tips_for_optimizing_Phoenix">create multiple column families</a> to separate the frequently-accessed columns from rarely-accessed columns. This improves performance because HBase reads only the column families specified in the query.</p>
</div>
<div class="section">
<h2 id="Columns">Columns</h2>
@@ -270,19 +270,19 @@
</ul>
<h1>Indexes</h1>
<p>A Phoenix index is a physical table that stores a pivoted copy of some or all of the data in the main table, to serve specific kinds of queries. When you issue a query, Phoenix selects the best index for the query automatically. The primary index is created automatically based on the primary keys you select. You can create secondary indexes, specifying which columns are included based on the anticipated queries the index will support.</p>
- <p>See also: <a class="externalLink" href="https://phoenix.apache.org/secondary_indexing.html">Secondary Indexing</a></p>
+ <p>See also: <a href="secondary_indexing.html">Secondary Indexing</a></p>
</div>
<div class="section">
<h2 id="Secondary_indexes">Secondary indexes</h2>
- <p>Secondary indexes can improve read performance by turning what would normally be a full table scan into a point lookup (at the cost of storage space and write speed). Secondary indexes can be added or removed after table creation and donât require changes to existing queries â queries simply run faster. A small number of secondary indexes is often sufficient. Depending on your needs, consider creating <i><a class="externalLink" href="http://phoenix.apache.org/secondary_indexing.html#Covered_Indexes">covered</a></i> indexes or <i><a class="externalLink" href="http://phoenix.apache.org/secondary_indexing.html#Functional_Indexes">functional</a></i> indexes, or both.</p>
+ <p>Secondary indexes can improve read performance by turning what would normally be a full table scan into a point lookup (at the cost of storage space and write speed). Secondary indexes can be added or removed after table creation and donât require changes to existing queries â queries simply run faster. A small number of secondary indexes is often sufficient. Depending on your needs, consider creating <i><a href="secondary_indexing.html#Covered_Indexes">covered</a></i> indexes or <i><a href="secondary_indexing.html#Functional_Indexes">functional</a></i> indexes, or both.</p>
<p>If your table is large, use the <tt>ASYNC</tt> keyword with <tt>CREATE INDEX</tt> to create the index asynchronously. In this case, the index will be built through MapReduce, which means that the client going up or down wonât impact index creation and the job is retried automatically if necessary. Youâll need to manually start the job, which you can then monitor just as you would any other MapReduce job.</p>
<p>Example: <tt>create index if not exists event_object_id_idx_b on trans.event (object_id) ASYNC UPDATE_CACHE_FREQUENCY=60000;</tt></p>
- <p>See <a class="externalLink" href="https://phoenix.apache.org/secondary_indexing.html#Index_Population">Index Population</a> for details.</p>
+ <p>See <a href="secondary_indexing.html#Index_Population">Index Population</a> for details.</p>
<p>If you canât create the index asynchronously for some reason, then increase the query timeout (<tt>phoenix.query.timeoutMs</tt>) to be larger than the time itâll take to build the index. If the <tt>CREATE INDEX</tt> call times out or the client goes down before itâs finished, then the index build will stop and must be run again. You can monitor the index table as it is createdâyouâll see new regions created as splits occur. You can query the <tt>SYSTEM.STATS</tt> table, which gets populated as splits and compactions happen. You can also run a <tt>count(*)</tt> query directly against the index table, though that puts more load on your system because requires a full table scan.</p>
<p>Tips:</p>
<ul>
- <li>Create <a class="externalLink" href="https://phoenix.apache.org/secondary_indexing.html#Local_Indexes">local</a> indexes for write-heavy use cases.</li>
- <li>Create global indexes for read-heavy use cases. To save read-time overhead, consider creating <a class="externalLink" href="https://phoenix.apache.org/secondary_indexing.html#Covered_Indexes">covered</a> indexes.</li>
+ <li>Create <a href="secondary_indexing.html#Local_Indexes">local</a> indexes for write-heavy use cases.</li>
+ <li>Create global indexes for read-heavy use cases. To save read-time overhead, consider creating <a href="secondary_indexing.html#Covered_Indexes">covered</a> indexes.</li>
<li>If the primary key is monotonically increasing, create salt buckets. The salt buckets canât be changed later, so design them to handle future growth. Salt buckets help avoid write hotspots, but can decrease overall throughput due to the additional scans needed on read.</li>
<li>Set up a cron job to build indexes. Use <tt>ASYNC</tt> with <tt>CREATE INDEX</tt> to avoid blocking.</li>
<li>Only create the indexes you need.</li>
@@ -324,7 +324,7 @@
<li>If necessary, you can do bigger joins with the <tt>/*+ USE_SORT_MERGE_JOIN */</tt> hint, but a big join will be an expensive operation over huge numbers of rows.</li>
<li>If the overall size of all right-hand-side tables would exceed the memory size limit, use the <tt>/*+ NO_STAR_JOIN */</tt>hint.</li>
</ul>
- <p>See also: <a class="externalLink" href="https://phoenix.apache.org/language/#hint">Hint</a>.</p>
+ <p>See also: <a href="language/#hint">Hint</a>.</p>
</div>
<div class="section">
<h3 id="Explain_Plans">Explain Plans</h3>
@@ -332,7 +332,7 @@
</div>
<div class="section">
<h3 id="Parallelization">Parallelization</h3>
- <p>You can improve parallelization with the <a class="externalLink" href="https://phoenix.apache.org/update_statistics.html">UPDATE STATISTICS</a> command. This command subdivides each region by determining keys called <i>guideposts</i> that are equidistant from each other, then uses these guideposts to break up queries into multiple parallel scans. Statistics are turned on by default. With Phoenix 4.9, the user can set guidepost width for each table. Optimal guidepost width depends on a number of factors such as cluster size, cluster usage, number of cores per node, table size, and disk I/O.</p>
+ <p>You can improve parallelization with the <a href="update_statistics.html">UPDATE STATISTICS</a> command. This command subdivides each region by determining keys called <i>guideposts</i> that are equidistant from each other, then uses these guideposts to break up queries into multiple parallel scans. Statistics are turned on by default. With Phoenix 4.9, the user can set guidepost width for each table. Optimal guidepost width depends on a number of factors such as cluster size, cluster usage, number of cores per node, table size, and disk I/O.</p>
<p>In Phoenix 4.12, we have added a new configuration <tt>phoenix.use.stats.parallelization</tt> that controls whether statistics should be used for driving parallelization. Note that one can still run stats collection. The information collected is used to surface estimates on number of bytes and rows a query will scan when an EXPLAIN is generated for it. </p>
</div>
</div>