Yes, advanced Big Data analytics tools are powerful. But connecting and making them work together can challenge your patience and technical ability.
Not long ago, Syntelli data engineers helped a client set up TIBCO™ Spotfire® Server to authenticate database connections with the MIT Kerberos protocol. They used Kerberos to secure an HBase cluster so that users could visualize data securely. The problem: establishing a connection with was uncharted territory. No one had developed a successful way to do it.
Why HBase and Apache Phoenix Work Well Together
Consultants wanted to connect the server running Spotfire Server software to an HBase cluster that also ran Apache Phoenix®. Why? Because HBase and Phoenix are a very effective combination.
Fast and flexible. HBase is built for flexible, high-volume, high-speed data processing. It enables you to store data in HDFS directly or through HBase. Part of the Hadoop ecosystem, HBase:
- Was developed to work with Hortonworks Hadoop clusters.
- Is a NoSQL data store.
- Is a distributed column-oriented database built on top of HDFS.
- Uses horizontally scalability to provide fast lookups in the largest tables.
Provides quick random access to huge amounts of structured data.
Easy queries and management. Apache Phoenix is the open source SQL query engine for Apache HBase. It’s designed to be compatible with Hortonworks software. And, the latest version of Phoenix supports the Parquet files present in HBase. Phoenix:
- Is accessed as a JDBC driver.
- Queries and manages HBase tables by using SQL.
- Takes the SQL query, compiles it to into a series of HBase scans and orchestrates the scans to produce regular JDBC result sets.
