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

How to configure ODBC Data Source Administrator connection for Teradata 17?

I have an instance of Teradata up and running from VMWare Workstation Player on my local machine. I am able to connect to that Teradata database using the default login DBC via putty. I have created another login dbc_test, using the dbc_test also I…
Teja Goud Kandula
  • 1,462
  • 13
  • 26
8
votes
1 answer

Group by Concat Teradata

I have a problem with a table, I would like to concat a string field using a group by. I have this situation here: USER | TEXT A | 'hello' A | 'by' B | 'hi' B | '9' B | 'city' I would like to obtain this result: USER | TEXT A |…
Davide Morgagni
  • 81
  • 1
  • 2
8
votes
1 answer

select aggregate function and all other columns

How do I select all columns in a table and an aggregate function in a convenient way? I.e. say that I have a table with 100 columns, and I want to send the following SELECT Max(Columns 44), ALL OTHER COLUMNS FROM zz Group by ALL OTHER COLUMNS…
D.Loo
  • 316
  • 1
  • 6
  • 16
8
votes
0 answers

How to Set Block Insert Size Parameters in Teradata

I am using odbc insert command in the statistics package Stata (v14.2) on an Ubuntu 14.04.2 LTS server to insert some data into a Teradata DB (v14.10). This Stata command has a block option, which makes Stata send the data in blocks of 1000 rows.…
dimitriy
  • 9,077
  • 2
  • 25
  • 50
8
votes
2 answers

Show column name and data type in Teradata?

Is there a way to get column name and data type in a Teradata SQL Assistant 15.0view? In Oracle 11g you can do something like desc tablename and get a script result set of the following : Name Null Type …
anm
  • 1,865
  • 3
  • 19
  • 28
8
votes
3 answers

View vs volatile table?

What is the difference between a view and a volatile table in Teradata? As far as I know, a volatile table is removed with the end of the session. Also it is only me who can see the volatile table as opposed to the view. Are there any other…
Azamat Bagatov
  • 289
  • 3
  • 11
  • 26
8
votes
1 answer

Using COLLECT STATISTICS in Teradata

In Teradata I can use a statement like ... collect statistics on my_table column(col1) This will gather stats on the table and store them in DBC views like ColumnStats, IndexStats and MultiColumnStats. I'm also under the impression that the…
ChrisCamp
  • 672
  • 1
  • 5
  • 20
8
votes
1 answer

JOIN versus EXISTS performance

Generally speaking, is there a performance difference between using a JOIN to select rows versus an EXISTS where clause? Searching various Q&A web sites suggests that a join is more efficient, but I recall learning a long time ago that EXISTS was…
BellevueBob
  • 9,498
  • 5
  • 29
  • 56
7
votes
2 answers

Teradata - limiting the results using TOP

I am trying to fetch a huge set of records from Teradata using JDBC. And I need to break this set into parts for which I'm using "Top N" clause in select. But I dont know how to set the "Offset" like how we do in MySQL - SELECT * FROM tbl LIMIT…
Aanand Natarajan
  • 111
  • 1
  • 1
  • 7
7
votes
3 answers

Liquibase preconditions: How do I check for a column being the correct data type?

I have a db upgrade script to change some datatypes on a few columns. I want to do a preCondition check, and call ALTER TABLE only when it is a DECIMAL datatype, but I will want it to be changed to INTEGER. Couldn't find a predefined precondition…
Ben
  • 71
  • 1
  • 2
7
votes
2 answers

How to identify groups/clusters in set of arcs/edges in SQL?

I have arcs/edges like these ‘haves’: Node1 Node2 A B B C D E Here A is connected to B and B to C. D is connected to E. In other words there are 2 groups/clusters shown in these ‘wants’: Node1 Node2 Cluster A B …
cs0815
  • 16,751
  • 45
  • 136
  • 299
7
votes
2 answers

Create a recursive view that has a "with recursive" statement in Teradata

I would like to create a recursive view in Teradata (i.e., CREATE RECURSIVE VIEW) from the following reproducible example: CREATE VOLATILE TABLE vt1 ( foo VARCHAR(10) , counter INTEGER , bar INTEGER ) ON COMMIT PRESERVE ROWS; INSERT…
JasonAizkalns
  • 20,243
  • 8
  • 57
  • 116
7
votes
2 answers

Difference between Qualify and Having

Can someone please explain me, what is the difference between qualify...over...partition by and group by...having in Teradata?I would also like to know if there are any differences in their performances.
pri
  • 1,521
  • 2
  • 13
  • 26
7
votes
1 answer

zero padding in teradata sql

Table A Id varchar(30) I'm trying to re-create a logic where I have to use 9 digit Ids irrespective of the actual length of the Value of the Id field. So for instance, if the Id is of length 6, I'll need to left pad with 3 leading zeros. The actual…
user3634687
  • 73
  • 1
  • 1
  • 3
7
votes
2 answers

ERROR 2616 Numeric overflow during computation while doing count(*)

I am trying to do a select count(*) from table from a table and I am not able to do it because of this error. I am not aware of the number of rows in the table. I am not doing any other aggregation in my query apart from this. I guess it has…
user3055262
  • 405
  • 3
  • 9
  • 20
1 2
3
…
99 100