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
3 answers

Need to pick latest 5 records among the partitions

I am stuck in a requirement. It might be simple but i am not getting through. I have one audit table Audit_Info which captures the audit information of all tables. A table could be run multiple times on the same business date. My requirement is to…
user3901666
  • 399
  • 11
  • 29
5
votes
1 answer

Run-Time error '-2147217871 (80040e31)': Query timeout expired

This error comes up when I try and run this big query. Smaller query's it doesn't. I have set connect timeout to 0 and that doesn't help. It looks like the connect makes it and it gets hung up at the .Open part of the code. Thank you for any…
Matt
  • 111
  • 1
  • 2
  • 9
5
votes
1 answer

Teradata CASE and HAVING COUNT

I have a table Handset. There are some duplicate imei's and i have to select only one imei each with these requirement: when unique imei found then pick that one when duplicate imei found, if one data_capable = 'Y', pick that one. when duplicate…
mdrahadian
  • 53
  • 4
5
votes
2 answers

How to get the table size in Teradata?

I have a table in Teradata. I would like to know its size. The same thing might be interesting for databases in Teradata. How can I do it?
Stefan Papp
  • 2,199
  • 1
  • 28
  • 54
5
votes
2 answers

How to find all the tables in database Teradata with specific column names in them?

I have 2-3 different column names that I want to look up in the entire DB and list out all tables which have those columns. Any easy query? I have seen solution for MySQL, which won't work here because TD as far as I know don't have schemes, but…
Rocketq
  • 5,423
  • 23
  • 75
  • 126
5
votes
2 answers

Teradata string truncated after UNION ALL

I have a query with a UNION clause. One of the field is a plain hardcoded string. The string in the statement after UNION gets truncated to match the string length of the field before the UNION. Sounds confusing? Here's an example. SELECT 'abc' as…
idok
  • 642
  • 10
  • 24
5
votes
5 answers

dbo in SqlServer

I'm converting database from Teradata to SqlServer. I've noticed all tables and procedures are named by the prefix "dbo." (e.g. "dbo.Table1"). I would like to know if and how I can get rid of "dbo" because it would make the conversion task a lot…
ala
  • 7,070
  • 13
  • 47
  • 54
5
votes
2 answers

How to generate AUTOMATIC Number in Teradata SQL

I want to generate AUTOMATIC Number to use TD SQL, for example as follows, CREATE MULTISET TABLE TEST_TABLE ( AUTO_NUMBER INT, NAME VARCHAR(10) ) PRIMARY INDEX (AUTO_NUMBER); INSERT INTO TEST_TABLE VALUES('TOM'); INSERT INTO…
user2002948
  • 63
  • 1
  • 1
  • 4
5
votes
3 answers

Get column type using teradata system tables

I want to get the actual column type from teradata system tables like dbc.columns. This table have column columntype but it does not give the actual datatype. I can get output with select type(columnname) from table output: varchar2(20) but…
user1011046
  • 204
  • 1
  • 5
  • 16
5
votes
1 answer

Unnecessary IO and Product Join Indicators

what are Unnecessary-IO and Product Join Indicators in Teradata. How are these metrics determined for a query?
rogue-one
  • 11,259
  • 7
  • 53
  • 75
5
votes
5 answers

Connecting Java and Teradata: The UserId, Password or Account is invalid

I have been trying to connect to Teradata Class.forName("com.teradata.jdbc.TeraDriver"); String connectionString = "jdbc:teradata://xxx.xxxxxx.com/database=xxxxxx, tmode=ANSI, charset=UTF8"; String user = "Rocket512"; …
Borat Sagddiev
  • 807
  • 5
  • 14
  • 28
5
votes
1 answer

Multiple Joins in Teradata SQL - Faster to Use Subqueries or Temp Tables?

I am writing SQL for Teradata. I need to use joins to connect data from multiple tables. Is it typically faster to use subqueries or create temporary tables and append columns one join at a time? I'm trying to test it myself but network traffic…
Jeffrey Kramer
  • 1,345
  • 6
  • 25
  • 43
5
votes
3 answers

Odd Behavior on Sum (Getting Numeric Overflow)

I was working with a SAS proc sql query and uncovered something odd. First, I tried this simple query: proc sql; CREATE TABLE test AS (SELECT YEAR(dt) AS yr, MONTH(dt) AS mo, SUM(val) AS total FROM …
Jeffrey Kramer
  • 1,345
  • 6
  • 25
  • 43
5
votes
1 answer

Does Teradata support literals for DATE and TIMESTAMP?

I'd like to be able to do something like this: insert into mydb.mytable (updatetimestamp) values (#1/15/2012 01:03:00#) ...or... select * from mydb.mytable where updatetimestamp = #1/15/2012 01:03:00# Using literals wouldn't required the…
oscilatingcretin
  • 10,457
  • 39
  • 119
  • 206
5
votes
1 answer

Teradata: Is there a way to generate DDL from a view or select statement?

I am using a global application user account to access database A. This user account does not have permissions to modify database A's schema (ie, create tables, modify tables, etc). This user also has access to database B, but only views. I need…
oscilatingcretin
  • 10,457
  • 39
  • 119
  • 206
1 2 3
…
99 100