Connect to Teradata from the BeakerX SQL Kernel in JupyterLab

Posted on Apr 10, 2021 in Computer Science • Tagged with programming, Jupyter, JupyterLab, SQL, BeakerX

You can run the following magics in a cell to connect to Teradata from a BeakerX SQL kernel.

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

%classpath add jar /workdir/jars/teradata/tdgssconfig.jar
%classpath …

Continue reading

Fastload in Teradata

Posted on May 22, 2020 in Computer Science • Tagged with Computer Science, SQL, Teradata, fastload, BTEQ, prepared statement

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

** Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement! **

Insert Multiple Rows

Teradata SQL does not support …


Continue reading

Understand and Avoid the No More Spool Space Issue in Teradata

Posted on Jun 22, 2020 in Computer Science • Tagged with Computer Science, Teradata, spool space, no more spool space, database, SQL

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

** Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement! **

Knowledge About Spool Space in Teradata

  1. Volatile Tables …

Continue reading

Use q to Query Text File Using SQL Syntax

Posted on Jun 05, 2016 in Programming • Tagged with programming, SQL, structured text, CSV, TSV

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

It is suggested that you use Python instead of q to manipulate text files!

Installation on Ubuntu

wajig install python3-q-text-as-data

General Tips

  1. The semantics of q is …


Continue reading

Using SQL in R

Posted on Jan 08, 2016 in Programming • Tagged with programming, CRAN, SQL, database, RJDBC, teradataR, RODBC

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

** Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives. **

  1. It is suggested that …

Continue reading

Teradata Table Type

Posted on Oct 16, 2016 in Computer Science • Tagged with programming, SQL, table, type

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

** Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives. **

  1. MULTISET Table

create table …


Continue reading