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.
- 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
- is related to
KNOX-893 Use Phoenix "thin" JDBC driver HTTP basic auth got HTTP/401 error