What's New @ Cloudera

Find the latest Cloudera product news
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Contributor

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.