Hello @SagarCapG    Thanks for using Cloudera Community. While I haven't tested the above Use-Case in Phoenix v5.0.0, I tested in Phoenix v5.1.0 (Used in CDP v7.1.7) & the same shows the Primary Key correctly [1]. As such, I believe the above ask is fixed in CDP v7.1.8 atleast.    I reviewed Upstream JIRA & it appears the same is actually fixed in Phoenix v5.1.x as per comments in https://issues.apache.org/jira/browse/PHOENIX-6651. As such, Kindly plan for CDP v7.1.8 Upgrade for obtaining the concerned functionality of identifying PK via "!primarykeys".    Regards, Smarak   [1]  0: jdbc:phoenix:> CREATE TABLE Employee (EmpId Integer Not Null Primary Key, Ename Varchar(50)); 0: jdbc:phoenix:> !primarykeys Employee; +-----------+-------------+------------+-------------+---------+---------+-------------+-----------+-----------+-------------+---------+---------------+ | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | KEY_SEQ | PK_NAME | ASC_OR_DESC | DATA_TYPE | TYPE_NAME | COLUMN_SIZE | TYPE_ID | VIEW_CONSTANT | +-----------+-------------+------------+-------------+---------+---------+-------------+-----------+-----------+-------------+---------+---------------+ | | | EMPLOYEE | EMPID | 1 | | A | 4 | INTEGER | null | 4 | | +-----------+-------------+------------+-------------+---------+---------+-------------+-----------+-----------+-------------+---------+---------------+   ... View more

Hello @anks1    Thanks for using Cloudera Community. Kindly confirm the following details:   CML Deployment (CDP Public Cloud Or Private Cloud) CML Version Used (Via CML Workspace Details In CML Page) Any timeframe of how many days before an App transition to Failed State from Running State   Regards, Smarak ... View more

Hello @sekhar1    We wish to follow-up on the Post & confirm if your Team have resolved the issue. In Summary,  such Exception are received if Traffic from your Machine isn't allowed to or from the Security Group linked with the VPC wherein the CML Workspace instances are deployed. Check if the Kubernetes Pods associated with the CML Workspace Kubernetes Cluster are Up/Running. If Yes, Such Exception should be reviewed from a Network Standpoint only.    You may reach out to your Customer's AWS/Platform Team to review the Traffic between your Machine & the VPC within which the CML Workspace is deployed.    Regards, Smarak ... View more

Hi @pacman A Merge happens for each Read Operation i.e. BlockCache & MemStore. As such, Incorrect Values aren't observed. Having said that, If you observe any such scenario of Read/Write Inconsistency, Kindly share a Use-Case & any replication attempt to allow us to review accordingly.   Regards, Smarak ... View more

Hello @pacman    Thanks for using Cloudera Community. HBase handles such scenario by Read Merge. A Read "Merges" Key Values from the Block Cache, MemStore, and HFiles in the following steps:   First, the Scanner looks for the Row Cells in theBlock Cache (Read Cache).  Next, the Scanner looks in the MemStore (Write Cache). If the Scanner does not find all of the Row Cells in the MemStore and Block Cache, then Hfiles are referred.    Hope the above answers your query. If Yes, Kindly mark the Post as Resolved.    Regards, Smarak ... View more