Query to identify the data distribution across AMP's in Teradata


The below query is used to identify the data distribution across AMP's in Teradata


SELECT HASHAMP(HASHBUCKET(HASHROW( index_columns ))) AS AMP_NO ,
COUNT(*)
FROM databasename.tablename
GROUP BY 1
ORDER BY 1;




Comments

  1. Awesome links, it has helped me a lot. Thanks for sharing.
    Teradata Training in Bangalore

    ReplyDelete
  2. Excellent and Job Oriented training on Bigdata andalysis Course provided by Real Time Experts. Thanks for immediate Placement in Laser Technologies

    Teradata Training in Bangalore

    ReplyDelete

Post a Comment

HTML/JAVASCRIPT