[KNOX-844] Add documentation for support of Apache Phoenix via Knox

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.11.0
• Fix Version/s: 0.11.0
• Component/s: Site
• Assignee: Josh Elser
• Reporter: John McParland
• Created: 05/Jan/17 16:15
• Updated: 28/Mar/19 14:17
• Resolved: 25/Sep/18 14:06

Description

We would like to access data stored in Hadoop (especially HBase) using traditional tools which rely on ODBC connections and SQL.

Phoenix provides the SQL interface to HBase, and Hortonworks have an ODBC Connector for Phoenix

However this is unsecured - in so far as accessing from outside of the perimeter of the Big Data Platform.

This ticket should address that by allowing the ODBC connection to Phoenix to be proxied through Knox, to enforce perimeter level security.

Acceptance Criteria

• Connections to Phoenix via Knox are only allowed with valid credentials, as enforced by Knox
• Connections to Phoenix via Knox are NOT allowed if Knox finds invalid credentials.
• Connection to Phoenix via Knox can are made via an ODBC connector

Issue Links

• is related to: KNOX-893 Use Phoenix "thin" JDBC driver HTTP basic auth got HTTP/401 error