Interested to Buy Any Domain ? << Click Here >> for more details...
How to find No. of Records present in Each AMP or a Node
for a given Table through SQL?
- 2 Answers
- 15464 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / n
Sel HASHAMP(HASHBUCKET(HASHROW(PRIMARY_INDEX_COLUMNS)))
AS AMP_NO,
COUNT(*)
From DATABASENAME.TABLE_NAME
GROUP BY 1;
| Is This Answer Correct ? | 30 Yes | 2 No |
Answer / yuvaevergreen
Adding to the above,
hashrow gives the unique row hash (23 bit value) for any
value given as a parameter.
hashbucket gives the bucket value (16 bit) for any hashrow.
hashmap gives the ampno for the hashbucket.
Since, PI must be defined for any table, this hashing
function can be used to determine the ampno and the no of
rows in the amps.
| Is This Answer Correct ? | 5 Yes | 0 No |
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
List the logical and conditional operators that are used with teradata along with their meanings?
What are the uses of client software involved in teradata?
How to Extract data from multiple legacy systems?
What is difference between user and database in teradata?
Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD
How many tables can you join in v2r5?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Highlight all the modes that are present under Confidence Level.
What do you mean by teradata intelliflex?
How do you verify a complicated sql?
What is upsert statement in teradata?
Teradata 
