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

Why subquery does not work in teradata?

I tried this SELECT * FROM ( SELECT * FROM mytable; ); and this SELECT * FROM ( SELECT * FROM mytable ); Why these simple queries do not execute in Teradata?
Andrei Vasilev
  • 597
  • 5
  • 18
  • 37
7
votes
2 answers

Selected non-aggregate values must be part of the associated group

I have two tables in Teradata: Table_A and Table_B. Between them is LEFT JOIN. Afterwards I am making SELECT statement which contains attributes from both tables: SELECT attribute_1 attribute_2 ... attribute_N Afterwords, I am using SUM functions…
Adam
  • 2,347
  • 12
  • 55
  • 81
7
votes
2 answers

Move data from oracle to HDFS, process and move to Teradata from HDFS

My requirement is to Move data from Oracle to HDFS Process the data on HDFS Move processed data to Teradata. It is also required to do this entire processing every 15 minutes. The volume of source data may be close to 50 GB and the processed…
Manikandan Kannan
  • 8,684
  • 15
  • 44
  • 65
7
votes
2 answers

How do I add comments to existing table DDL in Teradata?

I am adding some new columns to a table and want to add documentation to the table DDL for future developers. How does one go about this?
oscilatingcretin
  • 10,457
  • 39
  • 119
  • 206
6
votes
1 answer

Teradata equivalent for lead and lag function of oracle

I have been working ot see the equivalent function for Oracle lead and lag function. The oracle lead would look like LEAD(col1.date,1,ADD_MONTHS(col1.DATE,12)) OVER(Partition By tab.a,tab.b,tab.c Order By tab.a)-1 END_DATE LAG(col1.DATE +…
user708477
  • 147
  • 2
  • 4
  • 14
6
votes
3 answers

Connecting to Teradata via Perl

Has anyone had any success with this? There aren't a great deal of references online and I've exhausted every relevant result on Google. Here's my script: #!/usr/bin/perl use DBI; use DBD::ODBC; $user = "user"; $pw = "pw"; $ip =…
SemperFly
  • 1,563
  • 3
  • 17
  • 31
6
votes
6 answers

Need a better option - outer joining 32 times to same table

I have a nasty SQL query problem and I'd love help with an elegant solution. I'm trying to avoid 32 left outer joins to the same table. The database is Teradata. I have a table with 14 million records and 33 columns. The primary key (let's call it…
LukeK
  • 61
  • 4
6
votes
2 answers

teradatasql: runtime/cgo: could not obtain pthread_keys

When I'm trying to read data from sqlalchemy df=pd.read_sql_table(table, con, schema) getting runtime error : runtime/cgo: could not obtain pthread_keys tried 0x115 0x116 0x117 0x118 0x119 0x11a 0x11b 0x11c 0x11d 0x11e 0x11f 0x120 0x121…
Nishant
  • 105
  • 9
6
votes
1 answer

Teradata Database Docker Image

I've browsed the web and could not find a satisfactory answer. Is there an existing Docker image to run Teradata database in a Docker container? All I've found so far is this repository which conains Docker Images for Hadoop Hive, Presto, etc... but…
Alexis.Rolland
  • 5,724
  • 6
  • 50
  • 77
6
votes
1 answer

Teradata and Java server Connection

I am trying to connect to JAVA server using Teradata UDF, here is my code below.It uses HOST as "localhost" and PORT(integer) as "9091" and all the parameters such as PEM file location etc have been provided, but the function always exits from the…
Aman Vaishya
  • 179
  • 12
6
votes
2 answers

sql: like any vs like all

I can't figure out why sometimes LIKE requires ANY and other times it requires ALL, and it's making me crazy. I feel like I should be able to use ANY in both conditions (I'm trying to select records following any of the regex expressions in…
Adam
  • 581
  • 2
  • 4
  • 12
6
votes
2 answers

How do you check if a field contains all numeric values using Teradata SQL?

I'm looking for a function similar to ISNUMERIC() from T-SQL with Teradata SQL. I'd like a simple method to return a Boolean (or numeric 1/0) if the data contained in a character-type field is all numeric. For example: My column contains the…
Sevyns
  • 2,992
  • 5
  • 19
  • 23
6
votes
2 answers

COALESCE vs IS NOT NULL performance on checking empty string

Some articles I found on the internet compared ISNULL with COALESCE, so I think my question is a little different. I'm wondering which is better in terms of performance? SELECT * FROM mytable WHERE mycolumn IS NOT NULL AND mycolumn <> ''; Or SELECT…
Russell
  • 3,975
  • 7
  • 37
  • 47
6
votes
8 answers

how do i filter out non-numeric values in a text field in teradata?

oI have a teradata table with about 10 million records in it, that stores a numeric id field as a varchar. i need to transfer the values in this field to a bigint column in another table, but i can't simply say cast(id_field as bigint) because i…
Chris Drappier
  • 5,280
  • 10
  • 40
  • 64
6
votes
3 answers

Fastest way to check if any case of a pattern exist in a column using SQL

I am trying to write code that allows me to check if there are any cases of a particular pattern inside a table. The way I am currently doing is with something like select count(*) from database.table where column like (some pattern) and seeing…
Hangil Jang
  • 61
  • 7
1 2 3
…
99 100