For Teradata Aster, we can use SQL-H to pull data from Hadoop to Aster.
After some searching, I am still not able to find any documentation (syntax details, etc.).
Does anyone have a link to official TD doc?
Check the Aster Database User Guide for your version on www.info.teradata.com