How to find number of records present in Each AMP or a Node for a given Table through SQL?
Select HASHAMP(HASHBUCKET(HASHROW(PRIMARY_INDEX_COLUMNS))) AS AMP_NO,COUNT(*) from DATABASENAME.TABLE_NAME GROUP BY 1
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!