Hi, During the phoenix upgrade from 4.6 to 4.8 SYSTEM.STATS meta data is getting deleted and recreated in SYSTEM.CATALOG, but SYSTEM.CATALOG actual data is not getting cleared.
phioenix 4.6 SYSTEM.STATS has row key as physical_Table_name + column family+ region name. Since SYSTEM.STATS data is not deleted during the upgrade and not corrected the data, once upgraded Parallel scans are not proper (as start key and stop key are invalid) and returning multiple records. Example: in the below example "startRow": "CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS,3,1463423431278.7efe47a97f737de2ed34690f453d06bf.", CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS physical_name region name : 1463423431278.7efe47a97f737de2ed34690f453d06bf. }, { "loadColumnFamiliesOnDemand": null, "filter": "default.MESSAGE_ID = 'c2f8d7fe-6e29-4f34-bc38-b61bce8424cc'", "startRow": "CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS,3,1463423431278.7efe47a97f737de2ed34690f453d06bf.", "stopRow": "CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS,4,1463423431278.0a1ac472674298a1c3cb03fb48458665.", "batch": -1, "cacheBlocks": true, "totalColumns": 8, "maxResultSize": -1, "families": { "default": ["CREATED_BY", "JMS_MESSAGE_ID", "MESSAGE_BYTES", "MESSAGE_ID"] }, "caching": 2147483647, "maxVersions": 1, "timeRange": [0, 1485535243351] }, { "loadColumnFamiliesOnDemand": null, "filter": "default.MESSAGE_ID = 'c2f8d7fe-6e29-4f34-bc38-b61bce8424cc'", "startRow": "CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS,4,1463423431278.0a1ac472674298a1c3cb03fb48458665.", "stopRow": "CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS,5,1463423431278.0f69b359c43fc1ce5f546ada80982ff7.", "batch": -1, "cacheBlocks": true, "totalColumns": 8, "maxResultSize": -1, "families": { "default": ["CREATED_BY", "JMS_MESSAGE_ID", "MESSAGE_BYTES", "MESSAGE_ID"] }, "caching": 2147483647, "maxVersions": 1, "timeRange": [0, 1485535243351] }, { "loadColumnFamiliesOnDemand": null, "filter": "default.MESSAGE_ID = 'c2f8d7fe-6e29-4f34-bc38-b61bce8424cc'", "startRow": "CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS,5,1463423431278.0f69b359c43fc1ce5f546ada80982ff7.", "stopRow": "CDS_TEST.MONITORED_QUEUE_MESSAGE_DETAILS,6,1463423431278.761ad4a881f40fb34027b80008550821.", "batch": -1, "cacheBlocks": true, "totalColumns": 8, "maxResultSize": -1, "families": { "default": ["CREATED_BY", "JMS_MESSAGE_ID", "MESSAGE_BYTES", "MESSAGE_ID"] }, "caching": 2147483647, "maxVersions": 1, "timeRange": [0, 1485535243351] }, { Thanks Venkat