Answer Posted / yuvaevergreen
Below query can be used to find the distribution by amps.
SELECT HASHAMP(HASHBUCKET(HASHROW(index or column)))
,COUNT(*)
FROM TABLENAME GROUP BY 1 ORDER BY 2 DESC;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
When tpump is used instead of multiload?
What is the difference between fastload and multiload?
What are teradata utilities?
What are the various reporting tools in the market?
What is teradata and why it is used?
Mention a few of the ETL tools that come under Teradata.
What is the use of virtual processor connectivity in teradata?
Why does varchar occupy 2 extra bytes?
What are the advantages of teradata?
What is the purpose of upsert command?
What do you mean by teradata intellicloud?
Where is teradata rdbms used?
What are the 5 phases in a multiload utility?
What is basic teradata query language?
How many types of joins are there in teradata?