Installing Apache Phoenix using Cloudera Manager

Minimum Required Role: Cluster Administrator (also provided by Full Administrator)

1. In the Parcels page, click Parcel Repositories & Network Settings.
2. In the Remote Parcel Repository URLs section, add a new entry and type the correct Phoenix parcel repository URL in the format: https://username:password@archive.cloudera.com/p/phoenix/<parcel_version>/parcels/. For example, https://username:password@archive.cloudera.com/p/phoenix/6.2.1/parcels/.
3. Click Save Changes.

   The Phoenix parcel will now be available to download.

4. In the Location selector, click the cluster name in which you want to install Phoenix.

   The Phoenix parcel is listed as Available Remotely in the Status column.

5. Click Download to download the Phoenix parcel to your local repository. The status changes to Downloading.
6. Click Distribute. The status changes to Distributing. During distribution, you can:
   • Click the Details link in the Status column to view the Parcel Distribution Status page.
   • Click Cancel to cancel the distribution. When the Distribute action completes, the button changes to Activate, and you can click the Distributed status link to view the status page.
7. Click Activate to activate the parcel.

   You will see Distributed, Activated in the Status column.

For more information about installing the CSD file, see Installing an Add-on Service.

You must add the Phoenix service before you can use PQS. The Phoenix service takes care of starting and stopping the PQS. For instructions to add the Phoenix service, see Adding a Service.

Minimum Required Role: Cluster Administrator (also provided by Full Administrator)

Before you start using Phoenix, you must configure the following HBase properties using Cloudera Manager:

1. Go to the HBase service.
2. Click the Configuration tab.
3. Select Scope > HBase Cluster (Service-Wide).
4. Locate the HBase Service Advanced Configuration Snippet (Safety Valve) for hbase-site.xml property or search for it by typing its name in the Search box.
5. Click View as XML, and add the following properties:
   • Set hbase.regionserver.wal.codec to enable custom Write Ahead Log ("WAL") edits to be written as follows:

     <property>
     <name>hbase.regionserver.wal.codec</name>
      
     <value>org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec</value>
     </property> 

   • Set the following property to enable user-defined functions:

     <property>
      <name>phoenix.functions.allowUserDefinedFunctions</name>
      <value>true</value>
      <description>enable UDF functions</description>
     </property>

6. Enter a Reason for change, and then click Save Changes to commit the changes.
7. Restart the role and service when Cloudera Manager prompts you to restart.