What's New @ Cloudera

CDP Operational Database expands support for JDBC APIs and SQLAlchemy APIs through Python

Cloudera Employee

CDP Operational Database expands support for SqlAlchemy APIs with Phoenix with support for the getPrimaryKeys and getIndexInfo from the JDBC API through PhoenixDB (along with the SQL Alchemy wrapper APIs).  

 

  • getPrimaryKeys API retrieves a description of a table's primary key columns ordered by COLUMN_NAME
  • getIndexInfo API retrieves a description of a table's indices ordered by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION

 

This capability is available in PhoenixDB 1.1.0 and is compatible with all CDP 7.x versions and all CDP Operational Database service versions.