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

Save Python data-frame as Table in Teradata

I want to pull a table from Teradata as a Python data-frame. I know how to accomplish this step. Next I want to run algorithms on the data to transform it however I want. Once I am done with manipulating the data in Python, I want the resulting…
Maria Nazari
  • 660
  • 1
  • 9
  • 27
5
votes
3 answers

sql teradata filtering on date - database version Teradata 15.10.06.02 and provider version Teradata.Net 15.11.0.0

my table has a date column. its data type is date. I confirmed it by going to table name>>columns and it says MTH_END_DT [DATE, Not NULL] I want to filter my data for a particular date. If I put a condition where MTH_END_DT = '6/1/2018' I get an…
Ni_Tempe
  • 307
  • 1
  • 6
  • 20
5
votes
1 answer

What is Teradata's equivalent for Oracle's DUAL

In Oracle, we can write this to generate a single row using a SELECT statement. SELECT 1 AS x FROM dual What is Teradata's equivalent?
Lukas Eder
  • 211,314
  • 129
  • 689
  • 1,509
5
votes
2 answers

R: JDBC() not finding Java drivers path when connecting to Teradata

I'm trying to connect to Teradata through RStudio, but for some reason JDBC function has problems recognizing the path where Java drivers sit. See the code below: library(RODBC) library(RJDBC) library(rJava) # both Java drivers definitely exist…
Kasia Kulma
  • 1,683
  • 1
  • 14
  • 39
5
votes
3 answers

SELECT VALUES in Teradata

I know that it's possible in other SQL flavors (T-SQL) to "select" provided data without a table. Like: SELECT * FROM (VALUES (1,2), (3,4)) tbl How can I do this using Teradata?
Peter Smit
  • 1,594
  • 1
  • 13
  • 27
5
votes
2 answers

difference between minus and except in Teradata

what is the difference between minus and except in teradata?
Vivart
  • 14,900
  • 6
  • 36
  • 74
5
votes
5 answers

Converting teradata timestamp(6) to datetime for SQL Server

I'm working on a data exportation from SSIS, and I have a truncation error in one of my project: [TH27 [91]] Error: "A truncation error occurred. Column name is 'mydate'." In the input (Teradata), I have a column of type timestamp(6), and in the…
Hicham Bouchilkhi
  • 682
  • 10
  • 29
5
votes
1 answer

Concatenate strings from multiple records in Teradata SQL

I have a list of merchants that do business in different states. Merch State A NC A FL B CA B VA Instead of returning four records I want to group by Merch but concatenate the strings of the states so that…
JF4bes
  • 147
  • 1
  • 4
  • 12
5
votes
2 answers

How to delete rows in a Teradata table that are not in another table?

What makes my situation tricky is that I don't have a single column key, with a simple list of primary keys to delete (for instance, "delete from table where key in ([list])"). I have multiple columns together as the primary key, and would need to…
Paul Hooper
  • 839
  • 2
  • 7
  • 15
5
votes
1 answer

DELETE query performance

Original query delete B from TABLE_BASE B , TABLE_INC I where B.ID = I.IDID and B.NUM = I.NUM; Performanace stats for above query +-------------------+---------+-----------+ | Response Time | SumCPU | ImpactCPU…
Pirate X
  • 3,023
  • 5
  • 33
  • 60
5
votes
4 answers

Sqoop import Null string

The Null values are displayed as '\N' when a hive external table is queried. Below is the sqoop import script: sqoop import -libjars /usr/lib/sqoop/lib/tdgssconfig.jar,/usr/lib/sqoop/lib/terajdbc4.jar -Dmapred.job.queue.name=xxxxxx \ --connect…
Bagavathi
  • 438
  • 2
  • 7
  • 17
5
votes
3 answers

SQL Challenge/Puzzle: How to merge nested ranges?

This challenge is based on a real life use-case involving IP ranges. The solution I came with is based on the stack trace challenge I've presented previously. Each range start is treated as a PUSH operation and each range end + 1 is treated as a…
David דודו Markovitz
  • 42,900
  • 6
  • 64
  • 88
5
votes
3 answers

check if volatile table exists in teradata

Volatile table are great and somewhat comparable to temp tables in sql server (my background). Is there a way to check if a volatile table exists already? This code won't work when it is run for the first time: DROP TABLE SomeVolatileTable; CREATE…
cs0815
  • 16,751
  • 45
  • 136
  • 299
5
votes
4 answers

Validate syntax of CREATE TABLE DDLs using EXPLAIN Command

I have some create table scripts which I need to pre-validate in my application. I can think of two ways: CREATE table using that script and immediately DROP table. Use EXPLAIN command to find syntactical errors without creating it. I found 2nd…
Dev
  • 13,492
  • 19
  • 81
  • 174
5
votes
1 answer

Task.Run in a for loop

I have a for loop inside of which First : I want to compute the SQL required to run Second : Run the SQL asynchronously without waiting for them individually to finish in a loop My code looks like: for ( int i = 0; i <…
StrugglingCoder
  • 4,781
  • 16
  • 69
  • 103
1 2 3
…
99 100