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
5
votes
2 answers

How to create column and set default value in sql select statement

I'm trying to set a default text value for the already derived column "Sub1" Is this possible? I've created placeholders for the columns to be derived using a value of 0. I'm working in Teradata if it matters..... THANKS! select…
gfuller40
  • 1,183
  • 9
  • 19
  • 36
4
votes
3 answers

what is the full Teradata Client software?

I read couple of online documents to get start with the Teradata basics. I am curious to know what is full client version of Teradata client software to install on Windows/unix/Linux environments? What is best suited for client install? I see…
Krish212124
  • 65
  • 1
  • 4
  • 8
4
votes
1 answer

R package teradatasql dbGetQuery taking forever to return somewhat larger data whereas python works very quickly

I have a database table from which I am trying to get 5+ million rows of two columns. The following piece of code in python works perfectly and quickly (In about 3 minutes for the full 5+ rows of data, retrieved via query and written to CSV): import…
Gopala
  • 10,363
  • 7
  • 45
  • 77
4
votes
2 answers

Python Connection to Multiple Servers with Different SQL Dialects?

Question: How can I run SQL queries via Python to retrieve data from multiple servers that may have different SQL dialects (e.g. where one server dialect uses TOP X and another SAMPLE X)? Currently I have some code that allows me to run a query…
dady7749
  • 125
  • 3
  • 11
4
votes
3 answers

sas teradata fastload issue

Is there a fast way to load data to teradata? I need to load 350,000 account numbers to teradata and it's been running for about 4.5 hours now. I am just using a data step. Below is my code. Thank you libname myid teradata authdomain=IDWPRD…
user9016406
4
votes
1 answer

How to list the columns of a table in Teradata SQL

I have been googling and searching this site but cant find an answer to this simple question. How can I list or select all the columns of a table in Teradata?
timbram
  • 1,797
  • 5
  • 28
  • 49
4
votes
2 answers

SQL (Teradata): Removing NULLs caused by GroupBy / CASE Statement

I'm having a problem with NULLs showing up in my results. It's because of how I'm using my Group By & CASE Statement with, "ItemDamagedStatus". One solution could be to break out those CASE Statement items and do a JOIN to the same table. However,…
CHS_SQL_SE
  • 43
  • 3
4
votes
1 answer

Teradata & Continuous Integration

Status quo: We are developing a project at the client side. There's an existing Teradata appliance on the DEV side and one on the production side. On the DEV side there is more than one supplier and every supplier has its own sub-database. The DBAs…
C.B.
  • 91
  • 4
4
votes
1 answer

Lead and Lag in Teradata Query - For category

I am writing a query to get data as SCD 2 type from a data dump. My data and code are as follows: create table promotions ( start_date date, end_date date, promotion_name varchar(50)); Insert statements to populate the table: insert into…
Ravi
  • 659
  • 2
  • 10
  • 32
4
votes
1 answer

Create table Failed: [100015] Total size of all parcels is greater than the max message size

Could someone explain what does the above error message mean? How can it be fixed? Thanks
user3356554
  • 109
  • 1
  • 3
  • 11
4
votes
4 answers

Error: String contains an untranslatable character - TERADATA (for REGEXP_REPLACE operation)

I need to clean one character column and for that I am using REGEXP_REPLACE function in Teradata 14. The same piece of code worked for some other data source (having the same LATIN encoding). The data definition using show table has given me below…
Piyush Upadhyay
  • 41
  • 1
  • 1
  • 3
4
votes
0 answers

Delphi - Connect to Teradata DB (on virtual machine) with FireDAC

Cut to the chase: Windows 10 x64 host machine runs VMWare Player 12 which runs 'TDE 16.00.04 SLES 11' linux OS downloaded from teradata website. The virtual machine is pre-installed with teradata DB and it works fine, I can connect to it with…
Laszlo Szilvasi
  • 41
  • 1
4
votes
3 answers

declare variable in teradata

In TSql I can define a variable like so: DECLARE @Threshold AS int; SET @Threshold = 5; I can then use it like so: ,COALESCE( CASE WHEN X >= @Threshold THEN A ELSE NULL END ,CASE WHEN Y >= @Threshold THEN B ELSE NULL END ) AS Bla is…
cs0815
  • 16,751
  • 45
  • 136
  • 299
4
votes
1 answer

Specifying additional jars in AWS EMR custom jar application

I am trying to run a hadoop job on an EMR cluster. It is being run as a Java command for which I use a jar-with-dependencies. The job pulls data from Teradata and I am assuming Teradata related jars are also packed within the jar-with-dependencies.…
Nik
  • 5,515
  • 14
  • 49
  • 75
4
votes
2 answers

Trouble Installing tdodbc in Ubuntu

I'm using Ubuntu 16.04 and I'm trying to follow the guide here: http://crashthatch.tumblr.com/post/66957708538/teradata-odbc-connection-using-python-on-ubuntu To install the teradata odbc driver on Ubuntu. The blog post is a bit old and so I'm…
Murium
  • 183
  • 7
1 2 3
…
99 100