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. ... View more

CDP Operational Database (COD) provides increased visibility into performance with graphs on P99 latency, block cache hit ratio, compaction queue size.   P99 get latency is one of the key metrics used to determine auto-scaling behavior in COD.  P99 refers to the maximum latency 99% of the requests incur (i.e., 99% of requests are responded to in less than this latency figure).  In other words, only 1% of the requests are expected to be slower than this metric.   Block cache hit ratio refers to the # of requests/minute that are serviced from the block cache instead of object storage.  This is an overall driver of database performance as object storage (S3 on AWS, ABFS on Microsoft Azure) is slow relative to the block cache.   Compaction queue size gives an indication of the number of Stores in HBase that have been targeted for compaction.    Try out CDP Operational Database for free with Test Drive (no cloud account or setup needed). ... View more

Replication Manager dramatically simplifies setup of CDP Operational Database replication automating most parts of setup including: Deployment of the OpDB Replication plugin which eliminates the need for Kerberos x-realm trust Creation of the /user/hbase directory used for snapshot staging Creation of the table name on target for replicated tables Configuration of HBase to setup peering between source & target Configuration of HBase replication to enable replication Creation of snapshot on source and loading of snapshot on target to ensure all existing data is copied as HBase replication only copies data that has changed after it is enabled Automated rolling restarts after peering   Delivered in COD service version 1.13 (deployed services automatically use the latest release) and Cloudera Runtime 7.2.10.1 (requires DataLake and database upgrade) Try out CDP Operational Database for free with Test Drive (no cloud account or setup needed). ... View more

COD can now deploy using HDFS on EBS to provide high-performance storage (single millisecond / low double-digit millisecond latencies for many gets/puts).  Use the CDP CLI Beta to deploy a COD with this capability (e.g., “create-database” with “--use-hdfs” flag)   Delivered in COD service version 1.13 (deployed services automatically use the latest release) and requires CDP CLI Beta v 0.9.41 Try out CDP Operational Database for free with Test Drive (no cloud account or setup needed). ... View more

CDP Operational Database (COD) databases store data in cloud storage. The location of the data is stored in cloud storage is defined by the data access cloud storage location in the CDP environment and the COD database name.   When a COD database is dropped, any data stored in the cloud storage is not dropped.  You can delete the data separately if you no longer need it.   If a COD database is created using the same name (i.e., against a cloud storage location that already contains COD data from a previously deployed database), COD will automatically re-create the tables with the corresponding data in the new COD instance.    Delivered in COD service version 1.13 (deployed services automatically use the latest release) Try out CDP Operational Database for free with Test Drive (no cloud account or setup needed). ... View more

In CDP Public Cloud, each SDX cluster creates a separate kerberos domain and COD databases deploy within the context of each SDX cluster. Prior to this release, using CopyTable required configuration of kerberos x-realm trust between multiple domains. With this release, the HBase CopyTable can now use the same auth mechanism as the OpDB Replication Plugin to copy data across databases without requiring kerberos x-realm trust. Delivered in Cloudera Runtime 7.2.10.1 (requires DataLake and database upgrade to this runtime version)   Try out CDP Operational Database for free with Test Drive (no cloud account or setup needed). ... View more

CDP Operational Database Experience (COD) enables customers to use Apache Spark on the same database either directly with Apache HBase (NoSQL) or through Apache Phoenix (SQL) simultaneously through the Spark-Phoenix and Spark-HBase connector enabling customer's whose aggregation pipelines were built using both HBase and/or Phoenix to use the Cloud without code change.     ... View more

Customers that use CDP Operational Database Experience (or the "Operational Database with SQL" template in DataHub) need to deploy their applications on an edge node that has connectivity with the database.  Edge nodes are pre-configured to work with Cloudera's FreeIPA based DNS solution and within the Kerberos domain of the SDX.   Creating an edge node is now as simple as selecting the "COD Edge Node" template in Data Hub and is available for both AWS & Microsoft Azure.   ... View more

COD UI has been enhanced to provide the client URL for Python (used in conjunction with the phoenixDB python library)   It also provides better failure detection when downloading HBase client configuration files using the provided CURL command.  Instead of failing silently, the command will now emit error messages upon authentication failure ... View more

CDP Operational Database (COD) adds the ability to automatically tag underlying compute instances.  This enables customers to leverage negotiated pricing with AWS & Azure where such tags are required.  To use this functionality, create a COD database using the CDP CLI. ... View more