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

Teradata update join syntax

I've tried a few examples I've seen on the internet, but I can't seem to figure them out. This is a Teradata database. I have TableA that has CustomerId and DepartmentId. I have TableB that also CustomerId and DepartmentId. I know this structure is…
oscilatingcretin
  • 10,457
  • 39
  • 119
  • 206
10
votes
1 answer

Retrieving column and other metadata information in Teradata

I have a half dozen views in SQL Server that I need to replicate in Teradata, but I haven't been able to find the TD equivalent of the SQL metadata tables. I'd like to replicate the following functionality (which I assume is fairly…
William
  • 508
  • 3
  • 10
  • 18
10
votes
2 answers

Difference between "TOP" and "SAMPLE" in TeraData SQL

What is the difference between "TOP" and "SAMPLE" in TeraData SQL? Are they the same?
Steve
  • 229
  • 1
  • 6
  • 13
10
votes
1 answer

NullPointerException after extracting a Teradata table with Scala/Spark

I need to extract a table from Teradata (read-only access) to parquet with Scala (2.11) / Spark (2.1.0). I'm building a dataframe that I can load successfully val df = spark.read.format("jdbc").options(options).load() But df.show gives me a…
RaphDG
  • 1,351
  • 10
  • 17
10
votes
4 answers

How to set up .net teradata connection in c#?

I am trying to connect to Teradata with c#. I am using the sample code from this website using System; using System.Collections.Generic; using System.Text; using Teradata.Client.Provider; namespace Teradata.Client.Provider.HelloWorld { class…
Aleksei Nikolaevich
  • 325
  • 3
  • 15
  • 40
10
votes
1 answer

teradata sql pivot multiple occurrences into additional columns

I have something like this: ID Result 1 value1 2 value1 2 value2 3 value1 4 value1 4 value2 4 value3 And I'd like to return something like this: ID Result1 Result2 Result3 1 …
user2820576
  • 115
  • 1
  • 2
  • 7
10
votes
4 answers

hadoop vs teradata what is the difference

I've touched a Teradata. I've never touched hadoop, but since yesterday, I am doing some research on that. By description of both, they seem quite interchangable, but in some papers it is written that they serve for different purposes. But all I…
John
  • 503
  • 2
  • 10
  • 25
10
votes
4 answers

Issue with querying Teradata in Python/Pyodbc

I'm trying to query a Teradata database in Python with PyODBC. The connection to database is established alright; however, when I try to fetch result, I ran into this error "Invalid literal for Decimal: u''". Help please. I am on RHEL6, with Python…
wangke99
  • 141
  • 2
  • 4
9
votes
1 answer

Avoid Parameter Binding When Executing Query with SQLAlchemy

I am using SQLALchemy to execute queries on Teradata. One of the queries I execute is a DDL statement to replace a stored procedure: REPLACE PROCEDURE DEV_MIGRATION_TOOL.UNIT_TEST_NEW_STORED_PROCEDURE() UNIT_TEST_NEW_STORED_PROCEDURE: BEGIN …
Alexis.Rolland
  • 5,724
  • 6
  • 50
  • 77
9
votes
7 answers

Insert Multiple Rows SQL Teradata

I am creating a volatile table and trying to insert rows to the table. I can upload one row like below... create volatile table Example ( ProductID VARCHAR(15), Price DECIMAL (15,2) ) on commit preserve rows; et; INSERT INTO…
Bocean
  • 103
  • 1
  • 2
  • 7
9
votes
4 answers

Can you recommend a good source for Teradata Best Practices?

Looks like my data warehouse project is moving to Teradata next year (from SQL Server 2005). I'm looking for resources about best practices on Teradata - from limitations of its SQL dialect to idioms and conventions for getting queries to perform…
Cade Roux
  • 88,164
  • 40
  • 182
  • 265
9
votes
3 answers

SQL Concatenate multiple rows

I'm using Teradata, I have a table like this ID String 123 Jim 123 John 123 Jane 321 Jill 321 Janine 321 Johan I want to query the table so I get ID String 123 Jim, John, Jane 321 Jill, Janine,…
user2888246
  • 175
  • 1
  • 4
  • 9
9
votes
3 answers

query to return specific date from teradata timestamp(6)

How can i search for a particular date for eg: '2013-10-22' from teradata timestamp(6) field? sel * from table A where date = '2013-10-22'; I tried the above query which is throwing error. Please help!
RRR
  • 145
  • 1
  • 3
  • 11
9
votes
3 answers

Issue with subquery - All expressions must have explicit name

Not sure what is going on here and why this is not working. I'm receiving the following error: "All expressions in a derived table must have an explicit name" - working with teradata. select clm.c_clm ,clm.c_loc from (select * …
gfuller40
  • 1,183
  • 9
  • 19
  • 36
9
votes
3 answers

How to calculate moving sum with reset based on condition in teradata SQL?

I have this data and I want to sum the field USAGE_FLAG but reset when it drops to 0 or moves to a new ID keeping the dataset ordered by SU_ID and WEEK: SU_ID WEEK USAGE_FLAG 100 1 0 100 2 7 100 3 7 100 4 …
wilsonm2
  • 561
  • 2
  • 7
  • 17
1
2
3
…
99 100