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
What is the function of parser component in teradata?
What is spool space? Why do you get spool space errors?
What is the use of having index on table?
What are the string manipulation operators and functions associated with teradata?
What do you mean by tpt in teradata?
How can we check the version of Teradata that we are using currently?
Explain PDE.
What are the commands to make a new table, change a table and remove a table in teradata?
Define views in teradata with syntax.
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is difference between user and database in teradata?
What is the multi-insert?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
Difference between stored procedure and macro?
