phoniex 4.6 to 4.8 upgrade SYSTEM.STATS issue

[venk sham]

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