Jirka's Public Notepad

Data Engineering | Python | SQL Server | Teradata

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 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