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
- 15548 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 |
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Different phases of multiload?
how to load or extract the error table data ?
How do you load Multiple files to a table by using fastload scripts?
During the Display time, how is the sequence generated by Teradata?
What is basic teradata query language?
What do you mean by fastexport in teradata?
Which is faster fastload or multiload?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
how teradata fetches a row from primary index table?
What is spool space?
Teradata 
