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 :

4768 questions
87
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
  • 6,230
  • 12
  • 43
  • 53
54
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,231
  • 11
  • 55
  • 90
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
  • 20
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
  • 7,595
  • 17
  • 25
21
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
  • 409
  • 1
  • 6
  • 23
19
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
  • 475
  • 2
  • 7
  • 23
14
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,795
  • 7
  • 35
  • 46
12
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
  • 151
  • 2
  • 2
  • 7
10
votes
1 answer

Teradata update join syntax

I've tried a few examples I've seen on the internet, but I can't seem to figure them out. This is a Teradata database. I have TableA that has CustomerId and DepartmentId. I have TableB that also CustomerId and DepartmentId. I know this structure is…
oscilatingcretin
  • 9,495
  • 31
  • 111
  • 188
10
votes
1 answer

NullPointerException after extracting a Teradata table with Scala/Spark

I need to extract a table from Teradata (read-only access) to parquet with Scala (2.11) / Spark (2.1.0). I'm building a dataframe that I can load successfully val df = spark.read.format("jdbc").options(options).load() But df.show gives me a…
RaphDG
  • 1,311
  • 10
  • 15
10
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
  • 139
  • 1
  • 2
  • 10
10
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
  • 103
  • 1
  • 1
  • 5
10
votes
4 answers

How to set up .net teradata connection in c#?

I am trying to connect to Teradata with c#. I am using the sample code from this website using System; using System.Collections.Generic; using System.Text; using Teradata.Client.Provider; namespace Teradata.Client.Provider.HelloWorld { class…
Aleksei Nikolaevich
  • 285
  • 3
  • 13
  • 39
10
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
  • 1,967
  • 9
  • 48
  • 75
10
votes
4 answers

Issue with querying Teradata in Python/Pyodbc

I'm trying to query a Teradata database in Python with PyODBC. The connection to database is established alright; however, when I try to fetch result, I ran into this error "Invalid literal for Decimal: u''". Help please. I am on RHEL6, with Python…
wangke99
  • 141
  • 2
  • 4
1
2 3
…
99 100