Interested to Buy Any Domain ? << Click Here >> for more details...
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
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What happens when a node suffers a downfall?
if collect stats but it show low confidence why?
Explain BYNET.
How is the teradata different from oracle?
Highlight the points of differences between the database and user in Teradata.
What is meant by a Parsing Engine?
What are the various etl tools in the market?
what are the uses of fact table and dimension table in banking project?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
In Teradata, how do we Generate Sequence?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is the maximum number of dml can be coded in a multiload script?
What are the steps involved after the disk manager passes the request?
What is the use of fallback?
