Teradata SQL related posts in this category
Apache Zeppelin is a multi-purpose software that can be used for data visualization, data ingestion, data discovery and data analytics. You can check the below… Read More »How to create Apache Zeppelin-Teradata Interpreter and use charts?
As per SQL standards we cannot use ORDER BY clause in subqueries. It also does not make sense to use ORDER BY inside a derived… Read More »3706: Syntax error: ORDER BY is not allowed in subqueries.
Recently Raghav reached out to us on our Facebook page asking for a SQL query in Teradata to identify the highest AMPCPU, I/O and SPOOL… Read More »Calculate hourly resource consumption using DBQL in Teradata
What is encryption ? Why we need encryption ? How do we implement encryption ? One must clearly know answer to these 3 questions before… Read More »What,Why and How of Encryption in Teradata – Basics and Examples with Syntax
We recently received a comment on our previous TPT post,(Click here to read it) requesting for a sample TPT script to load multiple data files… Read More »How to load multiple files into one single Table using TPT in Teradata?
How Teradata distribute rows ? It is very important to understand how Teradata actually distribute rows among AMPs. We all know that PRIMARY INDEX is… Read More »HASHROW, HASHBUCKET, HASHAMP in Teradata