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;
Excellent article and interesting one to read. I am very glad to see this kind of article. Thanks! keep rocking.
ReplyDeleteEthical Hacking Course in Bangalore
Hacking Course in Bangalore
AWS Training in Bangalore
Devops Training in Bangalore
Python Training in Bangalore
Data Analytics Training in Bangalore
Digital Marketing Training in Bangalore
Python Course in Bangalore
ReplyDeleteFeeling so good to read your information's in the blog. Good job!
Ethical Hacking course in Chennai
Ethical Hacking Training Institute in Chennai
Hacking course in Chennai
ccna Training in Chennai
Salesforce course in Chennai
PHP Training in Chennai
Tally course in Chennai
Ethical Hacking course in OMR
Ethical Hacking course in Anna Nagar
Ethical Hacking course in Vadapalani
Innovative blog...!!! This is the best post and I got more ideas from your post. Keep continuous....
ReplyDeleteJMeter Training in Chennai
JMeter Training
Power BI Training in Chennai
Job Openings in Chennai
Linux Training in Chennai
Tableau Training in Chennai
Oracle Training in Chennai
Oracle DBA Training in Chennai
JMeter Training in Velachery
JMeter Training in Vadapalani
Awesome links, it has helped me a lot. Thanks for sharing.
ReplyDeleteTeradata Training in Bangalore
Excellent and Job Oriented training on Bigdata andalysis Course provided by Real Time Experts. Thanks for immediate Placement in Laser Technologies
ReplyDeleteTeradata Training in Bangalore