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
1
vote
0 answers

DatabaseError: Execution failed on sql: SELECT

I am connecting to Teradata with the following code which I execute on the python console: conn = pyodbc.connect('DRIVER={Teradata}; DBCNAME=TdwB; UID=####;PWD=###;') query = file(full_path).read() opportunities = pd.read_sql(query,…
NoIdeaHowToFixThis
  • 4,484
  • 2
  • 34
  • 69
1
vote
1 answer

Uninstall teradata ulitilies issue

I am trying to install teradata utilities 15.x, I earlier installed teradata ODBC drive and .NET Data Provider for teradata. Now if I start the installation, I get an error saying: "The installation failed for the following reason: A TTU 14.0 suite…
Rahul Khanna
  • 137
  • 2
  • 8
1
vote
5 answers

How get information from multiple tables using cursor?

I have a query, that returns multiple tables, something like that: SELECT TableName, DatabaseName +'.'+ TableName, ColumnName FROM DBC.Columns WHERE ColumnName = 'id' And I need to loop through these tables by looking to the information stored in…
Rocketq
  • 5,423
  • 23
  • 75
  • 126
1
vote
2 answers

How to clean a csv file from weird characters (e.g. SUB)?

I am uploading csv files using jdbc to teradata. Everything used to be fine, until recently I came across a csv file that had some weird characters and my code failed to upload . I opened the csv file in Notepad ++ , and it look like this SUB .…
Borat Sagddiev
  • 807
  • 5
  • 14
  • 28
1
vote
1 answer

Connecting R To Teradata VOLATILE TABLE

I am using R to try and connect to a teradata database and am running into difficulties The steps in the process are below 1) Create Connection 2) Create a VOLATILE TABLE 3) Load information from a data frame into the Volatile table Here is where…
John Smith
  • 2,448
  • 7
  • 54
  • 78
1
vote
2 answers

SSIS Teradata ole db connection

I'm working on modifying an SSIS package that includes several lookup transformations. In my experience you must have an OLEDB connection created to use a lookup. I am being asked to change the lookup to connect to a Teradata connection. We have…
Nathan J.
  • 13
  • 2
  • 5
1
vote
3 answers

SAS teradata connection

I am using following query to connect SAS with Teradata: proc sql; connect to Teradata (server = ‘WML’ user = ‘******’ password = ‘*******’ mode = Teradata ); quit; But I am getting following error: ERROR : Teradata connection: TheUserId,…
Akshay Huria
  • 43
  • 1
  • 4
1
vote
1 answer

Add Optional Parameters to Teradata Stored Procedure

Is there a way to add optional parameters to a stored procedure in Teradata? I know in Oracle it is: create or replace procedure myProcedure (param1 in varchar2 default null, param2 in number default null) and in SQLServer it is: CREATE…
Brad
  • 49
  • 1
  • 7
1
vote
0 answers

Is there any way to undo DELETE for a Teradata table?

I have a tableTest . It was created like this : CREATE SET TABLE mydbname.Test,FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( nameid INTEGER) PRIMARY INDEX (…
Alex
  • 355
  • 7
  • 25
1
vote
1 answer

SQL Server SSIS Teradata SQL UNION ALL

I have a Teradata SQL query that has over 20 separate SELECT queries all separated by UNION ALL. This query runs fine in SQL Assistant. I am wanting to set up an automated SSIS pull from Teradata using this SQL. I am using an ADO.NET task in my…
Matthew
  • 11
  • 1
1
vote
2 answers

Query a manual list of data items

I would like to run a query involving joining a table to a manually generated list but am stuck trying to generate the manual list. There is an example of what I am attempting to do below: SELECT * FROM ('29/12/2014', '30/12/2014',…
Nic2352
  • 95
  • 8
1
vote
1 answer

Create a list of dates and match records to the list

I am trying to gather a set of MI which counts the number of 'events' for a day. As this is MI i also need to list the days which haven't got any 'events' listed. My query is as follows: SELECT event_timestamp, COUNT(*) FROM table1 GROUP…
Nic2352
  • 95
  • 8
1
vote
1 answer

How do I assign a number to a set of results but re-start the numbering at the start of a new unique ID?

I am trying to (within a query) assign a row number to a date grouped by a customer ID. I realise that that makes little or no sense as a description so I have included an examples below (I don't have the reputation to post images yet and HTML…
Nic2352
  • 95
  • 8
1
vote
2 answers

Teradata Recursive CTE Concatenate Rows

Hello all I have the following CTE...what I'm trying to do is have an Id and then a concatenated list of Status so for example...if I have 1, 1234, Hot 2, 1234, Cold 3, 1234, Warm I want to end up with 1234,'Hot,Cold,Warm' My CTE with recursive…
jim
  • 26,598
  • 13
  • 51
  • 66
1
vote
1 answer

SAS: How do I write a pass-through to Teradata query without bringing back the results?

I want write a passthrough query in SAS but I don't want to bring back the results and I want to store the results in Teradata. In Teradata SQL I can do create table db.table2 as (select column1, column2, count(*) as cnt …
xiaodai
  • 14,889
  • 18
  • 76
  • 140
1 2 3
…
99 100