Stack Overflow
Stack Overflow

Questions tagged [teradata]

Teradata is a Relational Database Management System (RDBMS), capable of supporting many concurrent users from various client platforms. Teradata is compatible with the ANSI standard and built completely on parallel architecture.

The Teradata RDBMS is linearly and predictably scalable in all dimensions of a database system workload (data volume, breadth, number of users, complexity of queries). The scalability explains its popularity for enterprise data warehousing applications.

Features

  • Acts as a "database server" to client applications throughout the enterprise
  • Uses parallelism to manage "terabytes" of data
  • Capable of supporting many concurrent users from various client platforms (over TCP/IP or IBM channel connections).

Utilities

  • Batch Teradata Query (BTEQ) - query tool to load data and export data off at a time
  • FastExport - to exports data from Teradata to a Flat file
  • FastLoad - loads huge amount of data from flat file into EMPTY tables
  • MultiLoad - to load multiple tables at one time from either a LAN or Channel environment
  • Teradata Parallel Data Pump (TPump) - loads data using multiple SQL sessions, using row hash locks
  • Teradata Parallel Transporter (TPT) - combination of BTEQ, FastLoad, MultiLoad, Tpump, and FastExport utilities

Teradata Links

###Related tags :

5537 questions
111
votes
2 answers

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 @variable1, @variable2 In SQL Server, I found SET @variable1 = ( SELECT col1 FROM table1 ); That only allows a single…
ala
  • 7,070
  • 13
  • 47
  • 54
79
votes
2 answers

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 Teradata. I tried several sites to learn about the function but all of them uses a complicated example explaining the same.…
StrugglingCoder
  • 4,781
  • 16
  • 69
  • 103
24
votes
3 answers

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. pip install Teradata Now I want to import teradata module in my source code and perform operations like - Firing queries to teradata…
anurag
  • 590
  • 3
  • 8
  • 27
24
votes
4 answers

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 Code Address 1 1 123 Main 1 2 123 Main 2 1 456 Wall 2 2 456 Wall 3 1 …
Hatt
  • 689
  • 4
  • 9
  • 23
24
votes
2 answers

SQL - What is the performance impact of having multiple CASE statements in SELECT - Teradata

So I have a query that requires a bunch of CASE statements in the SELECT. This was not the orginal design but part of a compromise. So the query looks something like this: SELECT CONT.TABLE.FINC_ACCT_NM, CONT.TABLE.FINC_ACCT_ID, …
tarheels058
  • 439
  • 1
  • 7
  • 24
22
votes
2 answers

PDO returning empty property name

I'm having a strange issue with pdo_odbc and PDO::FETCH_OBJ (and PDO::FETCH_CLASS) that results in the following error message: PHP Fatal error: Cannot access empty property Here's the code: $dbh = new PDO("odbc:FOO"); $sth = $dbh->query(" …
mwp
  • 8,217
  • 20
  • 26
17
votes
5 answers

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 as the last completed course code overall for each employee. Below is my query: SELECT employee_number, MAX(course_completion_date) …
dneaster3
  • 309
  • 1
  • 3
  • 10
15
votes
4 answers

WHERE and JOIN order of operation

My question is similar to this SQL order of operations but with a little twist, so I think it's fair to ask. I'm using Teradata. And I have 2 tables: table1, table2. table1 has only an id column. table2 has the following columns: id, val I might…
Russell
  • 3,975
  • 7
  • 37
  • 47
15
votes
4 answers

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 there any relationship between this error and DB utilization factor ? Any studies on this would be more helpful for me to resolve…
user1601052
  • 181
  • 2
  • 2
  • 7
13
votes
1 answer

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 ... ) WITH DATA PRIMARY INDEX ( ACCOUNT_ID ) ; The inner SELECT statement results in 4 rows. However, when I run…
Adam
  • 2,347
  • 12
  • 55
  • 81
12
votes
5 answers

Left join without multiple rows from right table

I have two tables (User and Salary). I want to do a left join from User to Salary. For each user I want their name and salary. In case they have no salary that field can be left empty. So far a left join is all we need. But I only want one row per…
Filip Eriksson
  • 975
  • 7
  • 30
  • 47
11
votes
2 answers

Difference between timestamp(0) and timestamp(6)

Can some body tell me the difference between timestamp(0) and timestamp(6) in Teradata
user1172117
  • 169
  • 2
  • 3
  • 6
11
votes
1 answer

Avoiding warning message “There is a result object still in use” when using dbSendQuery to create table on database

Background: I use dbplyr and dplyr to extract data from a database, then I use the command dbSendQuery() to build my table. Issue: After the table is built, if I run another command I get the following warning: Warning messages: 1. In…
i_love_chocolate
  • 414
  • 5
  • 16
11
votes
3 answers

How to improve performance for slow Spark jobs using DataFrame and JDBC connection?

I am trying to access a mid-size Teradata table (~100 million rows) via JDBC in standalone mode on a single node (local[*]). I am using Spark 1.4.1. and is setup on a very powerful machine(2 cpu, 24 cores, 126G RAM). I have tried several memory…
Dev Patel
  • 292
  • 1
  • 5
  • 12
11
votes
5 answers

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 the search to find the right results. I have a table that (among other columns) contains program names for a customer number. I need to…
user3298276
  • 113
  • 1
  • 1
  • 5
1
2 3
…
99 100