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
How is MLOAD Teradata Server restarted after execution?
What is teradata? What are some primary characteristics of teradata?
Explain vproc in teradata?
How can we check the version of Teradata that we are using currently?
What are the functions involved in shared information architecture?
What is meant by a Channel Driver?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What do you mean by fastexport in teradata?
What happens when a node suffers a downfall?
Differentiate primary key and partition key?
Highlight the advantages of PPI(Partition Primary Index).
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Discuss the advantages of using partitioned primary index in a query?
What are the various etl tools in the market?
What are the things to be considered while creating secondary index?
