Apache PhoenixApache Software Foundation
|
WarehousePGEDB
|
|||||
| Apache Phoenix | WarehousePG | |||||
|---|---|---|---|---|---|---|
Related Products
|
||||||
Apache Phoenix:
About
Apache Phoenix enables OLTP and operational analytics in Hadoop for low-latency applications by combining the best of both worlds. The power of standard SQL and JDBC APIs with full ACID transaction capabilities and the flexibility of late-bound, schema-on-read capabilities from the NoSQL world by leveraging HBase as its backing store. Apache Phoenix is fully integrated with other Hadoop products such as Spark, Hive, Pig, Flume, and Map Reduce. Become the trusted data platform for OLTP and operational analytics for Hadoop through well-defined, industry-standard APIs. Apache Phoenix takes your SQL query, compiles it into a series of HBase scans, and orchestrates the running of those scans to produce regular JDBC result sets. Direct use of the HBase API, along with coprocessors and custom filters, results in performance on the order of milliseconds for small queries, or seconds for tens of millions of rows.
|
WarehousePG:
About
WarehousePG is an open-source, massively parallel processing (MPP) database for large-scale data warehousing, business intelligence, and analytics. Based on PostgreSQL, it distributes data and query work across clusters of coordinator and segment servers. SQL users can connect through PostgreSQL-compatible clients and interfaces, including psql, JDBC, ODBC, and libpq. Capabilities include append-optimized row- or column-oriented storage, table partitioning, parallel data loading through external tables, workload and resource management, query planning with GPORCA, and high availability through coordinator and segment mirroring. The Platform Extension Framework (PXF) lets WarehousePG query and write external data in sources such as Hadoop, object stores, and JDBC-accessible SQL databases. It supports analytical warehouse and BI workloads, with cluster deployments on Linux in on-premises or cloud infrastructure.
|
|||||
Apache Phoenix:
Platforms Supported
Windows
Supported
Mac
Supported
Linux
Supported
Cloud
Not Supported
On-Premises
Not Supported
iPhone
Not Supported
iPad
Not Supported
Android
Not Supported
Chromebook
Not Supported
|
WarehousePG:
Platforms Supported
Windows
Not Supported
Mac
Not Supported
Linux
Supported
Cloud
Not Supported
On-Premises
Supported
iPhone
Not Supported
iPad
Not Supported
Android
Not Supported
Chromebook
Not Supported
|
|||||
Apache Phoenix:
Audience
Anyone searching for a solution to manage their OLTP and operational analytics for Apache Hadoop
|
WarehousePG:
Audience
Data warehouse administrators, data engineers, and business intelligence and analytics teams managing large-scale analytical workloads.
|
|||||
Apache Phoenix:
Support
Phone Support
Not Supported
24/7 Live Support
Not Supported
Online
Supported
|
WarehousePG:
Support
Phone Support
Not Supported
24/7 Live Support
Not Supported
Online
Not Supported
|
|||||
Apache Phoenix:
API
Offers API
Supported
|
WarehousePG:
API
Offers API
Supported
|
|||||
Apache Phoenix:
Screenshots and Videos |
WarehousePG:
Screenshots and Videos |
|||||
Apache Phoenix:
Pricing
Free
Free Version
Supported
Free Trial
Not Supported
|
WarehousePG:
Pricing
$0
The WarehousePG project is free and open source.
Free Version
Supported
Free Trial
Not Supported
|
|||||
Apache Phoenix:
Reviews/
|
WarehousePG:
Reviews/
|
|||||
Apache Phoenix:
Training
Documentation
Supported
Webinars
Not Supported
Live Online
Not Supported
In Person
Not Supported
|
WarehousePG:
Training
Documentation
Supported
Webinars
Not Supported
Live Online
Not Supported
In Person
Not Supported
|
|||||
Apache Phoenix:
Company InformationApache Software Foundation
phoenix.apache.org
|
WarehousePG:
Company InformationEDB
Founded: 2004
United States
warehouse-pg.io
|
|||||
Apache Phoenix:
Alternatives |
WarehousePG:
Alternatives |
|||||
|
Apache Phoenix:
|
WarehousePG:
|
|||||
| Apache Phoenix: |
WarehousePG:
|
|||||
|
Apache Phoenix:
|
WarehousePG:
|
|||||
|
Apache Phoenix:
|
WarehousePG: | |||||
Apache Phoenix:
Categories |
WarehousePG:
Categories |
|||||
Apache Phoenix:
Integrations
Apache HBase
Supported
Hadoop
Supported
3forge
Supported
Amazon EMR
Supported
Amazon S3
Not Supported
Apache Flume
Supported
Apache Hive
Supported
Apache Spark
Supported
Azure Blob Storage
Not Supported
Data Sentinel
Supported
|
WarehousePG:
Integrations
Apache HBase
Supported
Hadoop
Supported
3forge
Not Supported
Amazon EMR
Not Supported
Amazon S3
Supported
Apache Flume
Not Supported
Apache Hive
Not Supported
Apache Spark
Not Supported
Azure Blob Storage
Supported
Data Sentinel
Not Supported
|
|||||
|
Apache Phoenix:
|
WarehousePG:
|