By Shakil Akhtar, Ravi Magham

Leverage Phoenix as an ANSI SQL engine equipped on most sensible of the hugely dispensed and scalable NoSQL framework HBase. examine the fundamentals and top practices which are being followed in Phoenix to allow a excessive write and browse throughput in a tremendous facts area.

This e-book comprises real-world instances corresponding to net of items units that ship non-stop streams to Phoenix, and the ebook explains how key positive aspects corresponding to joins, indexes, transactions, and features assist you comprehend the easy, versatile, and strong API that Phoenix presents. Examples are supplied utilizing real-time information and data-driven companies that allow you to acquire, research, and act in seconds.

Pro Apache Phoenix covers the nuances of establishing a allotted HBase cluster with Phoenix libraries, working functionality benchmarks, configuring parameters for construction eventualities, and viewing the implications. The e-book additionally indicates how Phoenix performs good with different key frameworks within the Hadoop surroundings corresponding to Apache Spark, Pig, Flume, and Sqoop.

You will find out how to:

  • Handle a petabyte information shop via utilizing typical SQL techniques
  • Store, research, and control info in a NoSQL Hadoop echo procedure with HBase
  • Apply top practices whereas operating with a scalable information shop on Hadoop and HBase
  • Integrate renowned frameworks (Apache Spark, Pig, Flume) to simplify monstrous information analysis
  • Demonstrate real-time use situations and massive facts modeling techniques

Who This ebook Is For
Data engineers, vast facts directors, and architects.

Show description

Read or Download Pro Apache Phoenix: An SQL Driver for HBase PDF

Similar data mining books

Data Visualization: Part 1, New Directions for Evaluation, Number 139

Do you speak information and knowledge to stakeholders? This factor is an element 1 of a two-part sequence on info visualization and overview. partly 1, we introduce contemporary advancements within the quantitative and qualitative information visualization box and supply a historic viewpoint on information visualization, its capability position in evaluate perform, and destiny instructions.

Big Data Imperatives: Enterprise Big Data Warehouse, BI Implementations and Analytics

Great facts Imperatives, makes a speciality of resolving the most important questions about everyone’s brain: Which facts concerns? Do you could have sufficient information quantity to justify the utilization? the way you are looking to strategy this quantity of information? How lengthy do you actually need to maintain it energetic in your research, advertising, and BI functions?

Learning Analytics in R with SNA, LSA, and MPIA

This booklet introduces significant Purposive interplay research (MPIA) conception, which mixes social community research (SNA) with latent semantic research (LSA) to aid create and examine a significant studying panorama from the electronic strains left by means of a studying neighborhood within the co-construction of information.

Metadata and Semantics Research: 10th International Conference, MTSR 2016, Göttingen, Germany, November 22-25, 2016, Proceedings

This e-book constitutes the refereed court cases of the tenth Metadata and Semantics learn convention, MTSR 2016, held in Göttingen, Germany, in November 2016. The 26 complete papers and six brief papers offered have been conscientiously reviewed and chosen from sixty seven submissions. The papers are equipped in numerous classes and tracks: electronic Libraries, details Retrieval, associated and Social info, Metadata and Semantics for Open Repositories, learn info structures and knowledge Infrastructures, Metadata and Semantics for Agriculture, foodstuff and setting, Metadata and Semantics for Cultural Collections and functions, ecu and nationwide initiatives.

Extra info for Pro Apache Phoenix: An SQL Driver for HBase

Sample text

You can build Phoenix from source code or you can use the convenient binary tarfile for a simple setup. It’s easy and handy to install Phoenix from the binary distribution. Here we show how to install Phoenix from the binary distribution: 1. org. tar. 1. 0” in this example. 2. gz archive and extract to your preferred directory. 3. jar jar to the HBase lib directory. 4. We have integrated Phoenix. sh This will start HBase in standalone mode. 5. py localhost where localhost is actually the zookeeper quorum address as we are running HBase in standalone mode, so the zookeeper address is localhost, and 2181 is the default port).

2, as well. To install Hbase, download the HBase binaries and extract the archive from one of the recommended mirror pages: 1. 4 directory. 4” in this example. 2. gz file. Download the file to install on your system. 3. gz file into some location. 4. Create the HBASE_HOME environment variable. 4 Installing Apache Phoenix Now that we have installed all prerequisite software for Phoenix, the process to install Phoenix is simple. You can build Phoenix from source code or you can use the convenient binary tarfile for a simple setup.

Py. py, create a new terminal window, navigate to the binary distribution directory(bin) on the machine and type the following command. 39 Chapter 3 ■ CRUD with Phoenix ■■Note By default, Phoenix upper-cases all column names and table names defined in the table. help to see the list of available commands. ■■Note These commands correspond to Phoenix Sqlline. For other JDBC clients you can refer to their manuals. 2 CREATE Let’s create a simple user table with ‘id’ as a primary key. Note that the columns first_name and last_name are mapped to the ‘d’ column family.

Download PDF sample

Rated 4.19 of 5 – based on 50 votes