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;

How to eliminate product joins in a teradata sql query?

960

---

What are the primary characteristics of the Teradata.

1058

---

What do you mean by caching in teradata?

995

---

What is spool space? Why do you get spool space errors?

947

---

Explain parsing engine in teradata?

1024

---

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

981

---

What is the use of stored procedures in teradata?

942

---

What is meant by a Clique?

989

---

How to Extract data from multiple legacy systems?

1040

---

What are the different functions performed in development phase?

1013

---

Explain amp in teradata?

1005

---

What is the difference between union and union all in teradata?

1048

---

Explain teradata vs. Redshift?

956

---

Why does varchar occupy 2 extra bytes?

1105

---

What is the use of virtual processor connectivity in teradata?

941

---