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

can I connect nodejs with teradata (any nodejs npm for this)?

Is there anyway I can connect teradata to nodejs server? I have use case where I need to pull teradata information in my rest APIs. Can I use this npm package?
Prafulla Patil
  • 171
  • 1
  • 7
6
votes
1 answer

Writing a data frame to a Teradata table using RJDBC

After establishing a connection as explained here, I tried to write a very simple data frame (trythis, shown below) to a table called gh_test_20141105 in a database called p_cia_t. First, I tried > conn <- getTdConnection(vdm='vivaldi') >…
Gabi
  • 1,303
  • 16
  • 20
6
votes
1 answer

How to find all tables / views with a column name that matches a particular pattern

How do I find all tables or views that have a column name that matches a pattern. The pattern is a simple LIKE %abcd% pattern and not a regex. The query or queries should return both views and tables.
cammil
  • 9,499
  • 15
  • 55
  • 89
6
votes
1 answer

Limiting the number of rows in subqueries with Teradata

I'm new to Teradata and I'm facing a problem I didn't have with the previous database I used. Basically, I'm trying to reduce the number of rows returned in subqueries inside a where clause. I had no problem doing this previously with the ROWNUM…
Charles
  • 63
  • 1
  • 1
  • 3
6
votes
3 answers

Teradata : How to get the server name using query

How can I get the server name using query in Teradata? That is, if I am writing a query on the 'dev' server, it should return the dev server name. for example, in Sybase : we will be using select @@servername.
user3881871
  • 61
  • 1
  • 1
  • 2
6
votes
2 answers

Early (or re-ordered) re-use of derived columns in a query - is this valid ANSI SQL?

Is this valid ANSI SQL?: SELECT 1 AS X ,2 * X AS Y ,3 * Y AS Z Because Teradata (12) can do this, as well as this (yes, crazy isn't it): SELECT 3 * Y AS Z ,2 * X AS Y ,1 AS X But SQL Server 2005 requires something like…
Cade Roux
  • 88,164
  • 40
  • 182
  • 265
6
votes
1 answer

Split String Teradata SQL

I'm looking to split a string in Teradata. The table might look something like this. column1 hello:goodbye:afternoon I'm trying to use SUBSTRING and INSTR to extract specific words. So, say I want to select "goodbye". I'm trying the following…
cloud36
  • 1,026
  • 6
  • 21
  • 35
6
votes
5 answers

Writing Efficient Queries in SAS Using Proc sql with Teradata

EDIT: Here is a more complete set of code that shows exactly what's going on per the answer below. libname output '/data/files/jeff' %let DateStart = '01Jan2013'd; %let DateEnd = '01Jun2013'd; proc sql; CREATE TABLE output.id AS ( SELECT DISTINCT…
Jeffrey Kramer
  • 1,345
  • 6
  • 25
  • 43
6
votes
3 answers

How to add/subtract date/time components using a calculated interval?

I'd like to get this to work in Teradata: Updated SQL for better example select case when current_date between cast('03-10-2013' as date format 'mm-dd-yyyy') and cast('11-03-2013' as date format 'mm-dd-yyyy') then 4 …
oscilatingcretin
  • 10,457
  • 39
  • 119
  • 206
6
votes
1 answer

RowID in Teradata

I need to pull a row ID with a select statement. Something that is similar to the row ID of oracle. How would I do that in Teradata? I am trying the following query but it is throwing error. select rowid,emp_id,e_name from test; Error msg : Syntax…
LazyCoder
  • 336
  • 2
  • 8
6
votes
2 answers

Can I query a procedure's RequestText in Teradata?

Teradata has a useful view called dbc.tables that you can use to query objects. I've used this to query the RequestText in views with success, but procedures seem to be compiled a bit differently. When I look at the RequestText of a procedure…
oscilatingcretin
  • 10,457
  • 39
  • 119
  • 206
6
votes
4 answers

Maven dependency for Teradata JDBC driver

Does Teradata have its JDBC driver uploaded as a jar referenced from a maven file?
priya
  • 24,861
  • 26
  • 62
  • 81
5
votes
2 answers

Create table but Drop it if the table exists already

I am working on a request where I have to create a table to insert some data. So, obviously I will have first have a delete table st. before the create st. but when I am running this for the first time(before the table can be created) it will pop up…
user1172117
  • 169
  • 2
  • 3
  • 6
5
votes
1 answer

Connecting to Teradata using teradatasql module in Python

I am trying to connect to Teradata using teradatasql module in Python. The code is running fine on localhost, but once deployed on the server as part of the server code, it is throwing the error. the code: import teradatasql try: host, username,…
Kritz
  • 89
  • 2
  • 13
5
votes
1 answer

Similar Hash Algorithms in Teradata and Spark

I am performing an incremental load on data coming from a Teradata database and storing it as a parquet file. Because the tables from Teradata contains billions of rows, I would like my PySpark script to compare hash values. Teradata Table: An…
user10920066
  • 51
  • 1
1 2 3
…
99 100