Teradata Numeric overflow occurred during computation
Numeric overflow is a very common error in Teradata which you will encounter while handling numeric values in computation or transformation. The error comes when you try to load or … Read More
Category: Teradata SQL
Teradata SQL related posts in this category
50 Teradata Interview Questions & Answers
I am sharing below 50 Teradata Interview questions which covers various topics and shall help in preliminary rounds of Interview. It covers basic architecture questions, utilities related – Fastload, Multiload, … Read More
Moving from Teradata to Hadoop – Read this before
It’s been few years since I have been working on HIVE, Impala, Spark SQL, PySpark, Redshift and in the journey so far I have migrated many applications in different RDBMS … Read More
Convert number to TIME in Teradata
While calculating measures you may want to convert seconds to TIME. Say you want to know how many HOURS,MINUTES & Seconds constitute this number. Example you may want to convert … Read More
Teradata TPT Export script
If writing a typical TPT script is tedious task for you then you may try using existing TPT templates to quickly write a TPT script. Teradata provides list of templates … Read More
Fetch Metadata of View in Teradata via HELP
Recently someone in my team asked me how to fetch column list along with datatype from VIEW definition via jdbc connection. I proposed couple of solutions to him however due … Read More
Error – Select with Grant Option required
“An owner referenced by user does not have SELECT WITH GRANT OPTION access to DB_Name.Table_Name.Col_Name “. This is very common error related with privileges granted to objects in Teradata. So … Read More
How to write a BTEQ Script in Teradata
In most of the Teradata environment I have seen the preferred medium to call BTEQ is shell script. It means that Teradata developer will write a shell script which will … Read More
Teradata combine rows into single value
Few years ago, I shared a post to “Convert Multiple Rows into Single Row” using recursive queries. Though it solves the problem and gives the correct desired result, the solution … Read More
ROWS BETWEEN in Analytical Function in Teradata
ROWS BETWEEN is used in Teradata to determine group for calculating aggregation in Analytical Functions. Whenever you use window functions or OLAP functions you specify the rows which shall be … Read More