Top "Teradata" questions

SQL SELECT multi-columns INTO multi-variable

I'm converting SQL from Teradata to SQL Server in Teradata, they have the format SELECT col1, col2 FROM table1 INTO @…

sql sql-server teradata

What is ROWS UNBOUNDED PRECEDING used for in Teradata?

I am just starting on Teradata and I have come across an Ordered Analytical Function called "Rows unbounded preceding" in …

sql teradata window-functions

Find which rows have different values for a given column in Teradata SQL

I am trying to compare two addresses from the same ID to see whether they match. For example: Id Adress …

sql join teradata rows matching

MAX() and MAX() OVER PARTITION BY produces error 3504 in Teradata Query

I am trying to produce a results table with the last completed course date for each course code, as well …

sql aggregate-functions teradata database-partitioning

no more spool space in Database

I am using Teradata. In that I am getting 'no more spool space in Database'. My database utilization is 85%. Is …

database teradata

Connecting Python with Teradata using Teradata module

I have installed python 2.7.0 and Teradata module on Windows 7. I am not able to connect and query TD from python. …

python connection odbc teradata

Teradata Volatile Table Statement is not creating any rows

I want to create table in Teradata. Therefore I am using this syntax: CREATE VOLATILE TABLE a AS ( Select * FROM ... ) …

teradata

zero padding in teradata sql

Table A Id varchar(30) I'm trying to re-create a logic where I have to use 9 digit Ids irrespective of the …

sql teradata

Multiple table join in hive

I have migrated Teradata tables' data into hive . Now I have to build summary tables on top of imported data. …

hadoop hive teradata sqoop

Select Records With Only One Value In A Column Where Multiple Are Possible

My apologies in advance, this is probably a basic question asked and answered but I don't know how to word …

sql teradata