Apache Phoenix
Apache Phoenix is a relational database layer that is build on top of Apache HBase. Apache Phoenix compiles an SQL query into a series of HBase scans and executes those scans to produce result sets.
Information noteIndustry-accepted best practices must be followed when using or allowing access through the ODBC Connector. Administrators must follow The Principle of Least Privilege when setting up source database privileges and permissions.
Supported Apache Phoenix database versions
The followings database versions are supported:
- CDH 4.4.0 to 4.7.0
Supported Apache Phoenix data types
The following Apache Phoenix data types are supported by the Apache Phoenix Connector.
- Array
- BigInt
- Binary
- Boolean
- Char
- Date
- Decimal
- Double
- Float
- Integer
- SmallInt
- Time
- Timestamp
- TinyInt
- Unsigned_Date
- Unsigned_Double
- Unsigned_Float
- Unsigned_Int
- Unsigned_Long
- Unsigned_SmallInt
- Unsigned_Time
- Unsigned_TimeStamp
- Unsigned_TinyInt
- Varchar