Jirka's Public Notepad

Data Engineering | Python | SQL Server | Teradata

January 2, 2019 By Jiří Hubáček Leave a Comment

TOP N Syntax error: Top N option is not supported in subquery.

Unlike other database engines, Teradata doesn't support top N clause in suqueries (error Failed [6916 : HY000]). I came across this limitation when I

December 6, 2018 By Jiří Hubáček Leave a Comment

Timezone handling in Teradata

I needed to display local timestamps of UTC stored data in my report. But I didn't want to just blindly add or subtract hours as this wouldn't reflect

December 19, 2017 By Jiří Hubáček Leave a Comment

RDBMS error 2574: Operation not allowed: table is being MLoaded

Teradata Parallel Transporter (TPT) is a Teradata tool for Extraction Transformation and Loading. It offers a native, scalable and parallel way of

September 22, 2017 By Jiří Hubáček Leave a Comment

Casting Char to Timestamp and Date in Teradata

Casting character data to timestamp or date data type is a common task during ETL development. Yet, I couldn’t learn the formatting characters by

September 17, 2017 By Jiří Hubáček Leave a Comment

Listing all tables in a database and their PERM space consumption

Listing table sizes in Teradata is done by querying the all AllSpace view in the DBC database: SELECT DatabaseName,

November 23, 2016 By Jiří Hubáček Leave a Comment

Reverse string search in Teradata

I needed to perform a reverse string search to find the last occurence of a slash. It took me a while before I found a simple and elegant solution

»
  • GitHub
  • LinkedIn
  • RSS
  • Twitter
© 2021 · Jiří Hubáček, PGP