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
4
votes
1 answer

Connect R and Teradata using JDBC

I´m trying to connect R and Teradata using RJDBC. I´ve found this link that has an example using mysql, but i´m nos sure how to do the same with teradata. library(RJDBC) drv <- JDBC("com.mysql.jdbc.Driver", …
marbel
  • 7,560
  • 6
  • 49
  • 68
4
votes
1 answer

Teradata JDBC Create Volatile Table error 3585

I have never used the Teradata JDBC driver before, so I may be running into something very obvious... Basically, I am trying to create a volatile table from which I can query. Questions Maybe I just can't run CREATE VOLATILE TABLE statements like…
user1766760
  • 631
  • 2
  • 8
  • 26
4
votes
2 answers

split row_number() over partition over multiple columns

I have a query which uses row_number() over partition. When the result comes out it looks like Product Row_Number Price A 1 25 A 2 20 A 3 …
John Henry
  • 165
  • 1
  • 4
  • 14
4
votes
2 answers

Teradata Database 3130 Response limit exceeded?

[Teradata Database] [3130] Response limit exceeded I have no idea what is causing this random error message. It happens when I am making a call to the database for a SELECT or to execute a stored procedure. I wish I had more information on how to…
oscilatingcretin
  • 10,457
  • 39
  • 119
  • 206
4
votes
1 answer

How does hibernate resolve schema for initially validating to a Teradata database?

Environment: Java/Spring application that uses JPA/Hibernate for persistence and connects to a Teradata datasource configured in the app container (Tomcat) which is accessed through JNDI. Versions that I am using: java: 6 spring:…
raspacorp
  • 5,037
  • 11
  • 39
  • 51
4
votes
1 answer

How to change a 'date' in Char format to date format in teradata SQL?

I have a column date like date CHAR(7) CHARACTER SET LATIN NOT CASESPECIFIC, where i have some values like 2010-12, 2011-10, etc. i want to change these into the date format yyyy/mm . How do i do it? Thanks
srk
  • 427
  • 4
  • 11
  • 27
4
votes
1 answer

Teradata: how can I get the primary key and foreign key definition of a table?

The tables are already there but I don't know how they are crated. Now I want to get the definition of primary key and foreign key of the tables. How can I do that?
Cacheing
  • 3,431
  • 20
  • 46
  • 65
4
votes
7 answers

What is the difference between GROUP BY and DISTINCT?

I have the table with the following data empid empname deptid address -------------------------------- aa76 John 6 34567 aa75 rob 4 23456 aa71 smith 3 12345 aa74 dave 2 12345 a77 blake 2…
SrinR
  • 923
  • 7
  • 16
  • 27
4
votes
1 answer

insert into Teradata using R JDBC

I am using R JDBC and teradataR to connect R to teradata. I would like to write a table using the function dbWriteTable, but am receiving this error [Error 3932] [SQLState 25000] Only an ET or null statement is legal after a DDL Statement.) This…
JCWong
  • 1,163
  • 1
  • 10
  • 29
4
votes
1 answer

Teradara: Casting Seconds to Hours, Minutes and Seconds

I need to cast a Duration, measured in seconds, Decimal(18,0) to Hours, Minutes and Seconds. e.g.: 8192 Seconds => 2:16:32 (Hours:Minutes:Seconds) I've found (here) that I can do this if the seconds are a literal string, like this: SELECT…
lexu
  • 8,766
  • 5
  • 45
  • 63
4
votes
3 answers

multiple columns with multiple values in where clause

I am executing a query which has multiple columns in where clause which has multiple values. I know that in SQL you can use IN condition to satisfy and get the correct output. What is the way to do in teradata? my code in Oracle looks like…
user1734698
  • 157
  • 2
  • 2
  • 17
4
votes
4 answers

Creating and using temporary/volatile database tables In Stata

Addendum: As of Stata 14, volatile tables work without any hacks. Is there a way to tweak Stata to work with temporary volatile tables? These tables and the data are deleted after a user logs off the session. Here's an example of a simple toy SQL…
dimitriy
  • 9,077
  • 2
  • 25
  • 50
4
votes
5 answers

Export From Teradata Table to CSV

Is it possible to transfer the date from the Teradata Table into .csv file directly. Problem is - my table has more that 18 million rows. If yes, please send tell me the process
Adam
  • 2,347
  • 12
  • 55
  • 81
4
votes
5 answers

Explain Query Bands in Teradata

Can anyone explain Query Bands in Teradata? I've searched regarding this a lot, but wasnt able to get information which I can understand. Please be a bit detailed. Thanks!!!
user1919035
  • 227
  • 1
  • 4
  • 12
4
votes
2 answers

Compare 3 Consecutive rows in a table

Hi I have an interesting problem. I Have an Employee Table AS Follows CREATE TABLE EMPLOYEE( EMPLOYEE_ID INTEGER, SALARY DECIMAL(18,2), PAY_PERIOD DATE) Now the tables have employees some of whom get paid monthly,some weekly, some biweekly and some…
Eosphorus
  • 312
  • 3
  • 10
  • 19
1 2 3
…
99 100