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

SQL teradata trying to obtain all rows where column has a question mark

I have a column(dt) that either contains a date (mo/dd/yr) or a question mark(?). In my where close I'm trying to select only rows where the column has a question mark. I tried the following below and I get an error. where c.dt = '?' The…
T D
  • 143
  • 3
  • 13
1
vote
1 answer

Difference in these 2 queries in TERADATA

SEL * FROM TABLE WHERE a=10 VS SEL * FROM TABLE WHERE a='10' Here a is BIGINT, Explain plan does not show any difference, how teradata handles this and any difference in these query ?
Vivek Keshri
  • 108
  • 10
1
vote
2 answers

How to find two rows where a field value is x and 2nd row is x + 1

I have a list of records (transactions). I want to be able to ONLY include rows where the transaction numbers have a sequential value +1. Not even sure where to start to get it to list ONLY those transactions. I have it working to list all…
DJDJ23
  • 139
  • 1
  • 2
  • 12
1
vote
2 answers

Count and return where 2 fields match

I'm trying to write a script that counts results based on 2 fields matching - but not matching like identically, but where the values re-occur throughout the table. For example, I want to find where Field A and Field B = x & y, respectively (and…
DJDJ23
  • 139
  • 1
  • 2
  • 12
1
vote
1 answer

Is there anything faster than fastload ?

I am loading a table of 200,000,000 rows daily. The fastload does this in 2-3 hours. However, I have other table to upload, so this creates an issue for me because those tables are even bigger. Is there any other faster way ?
Elvis
  • 255
  • 3
  • 11
1
vote
3 answers

teradata export from hive to teradata class not found

I am trying to export from hive table to teradata using TDCH connector, I am getting below errror:- 15/05/07 08:01:03 INFO tool.ConnectorExportTool: java.lang.NoClassDefFoundError: org/apache/hadoop/hive/metastore/api/MetaException at…
priyanka
  • 305
  • 1
  • 3
  • 18
1
vote
1 answer

Is there a way to reuse subqueries in the same query?

See Update at end of question for solution thanks to marked answer! I'd like to treat a subquery as if it were an actual table that can be reused in the same query. Here's the setup SQL: create table mydb.mytable ( id integer not null, …
oscilatingcretin
  • 10,457
  • 39
  • 119
  • 206
1
vote
4 answers

Is it possible to connect to TeraData from Spark SQL and run queries over it?

So far, I have been able to Connect and run queries over Mysql database using spark SQL using Mysql JDBC driver registering it as spark Data frame. Is it possible to connect to TeraData from Spark SQL and run queries over it?
Prem Singh Bist
  • 1,273
  • 5
  • 22
  • 37
1
vote
0 answers

Teradata 3706 error: OTRANSLATE

I am using Teradata SQLA 14.01 and want to use the OTRANSLATE function, but it is not working. I have checked the DBC.FunctionsV table to ensure that the function is defined in the system, which it is. However, even when I use the sample code; …
dcleere
  • 11
  • 4
1
vote
1 answer

Executing TeraData codes using SAS function

I have a question about executing the year() function in TeraData from SAS. For example, when executing the code below, I will get the error message below the codes. Is there a way to execute the year() function besides using the year function in…
Bob
  • 121
  • 1
  • 4
  • 12
1
vote
2 answers

Setting Minute and Second component of Timestamp field to 0

I have a requirement such that if I enter a timestamp(yyyy-mm-dd hh:mm:ss) say 2015-04-05 16:45:12 I need it converted to 2015-04-05 16:00:00 Is there an elegant way to do this in Teradata rather than extracting hour and then casting it with…
haldar55
  • 59
  • 1
  • 1
  • 11
1
vote
1 answer

Casting to decimal in Teradata/SQL

I'm trying to cast a line in a (Teradata) SQL query so I can get decimals: (SUM((vndr_po_ln_vb.mnfst_qty - vndr_po_ln_vb.rcvd_qty)))/(CAST(COUNT(DISTINCT vndr_po_vb.vndr_po_num)) AS DECIMAL(3,2)) AS "Average Damaged Cases per PO" However, it…
Felix Reyes
  • 19
  • 1
  • 1
  • 5
1
vote
2 answers

how to give row number only for consecutive combination

I want to give row number only to the combination when it appears in a consecutive manner like , Please guide on how to get this type of sequence numbering in Tsql I have tried with ROW_NUMBER() Over (Partition by name,Order_type Order by…
Kaleem
  • 55
  • 2
  • 10
1
vote
5 answers

rownum equivlent in teradata

How to convert rownum in following query(oracle) to teradata equivalent: and not exists(select 1 from CSE, SPD WHERE cse.id=spd.id AND ROWNUM = 1 AND CSE.STATUSID IN(6,7,8,13) thanks.
user3438498
  • 211
  • 3
  • 11
  • 21
1
vote
1 answer

Case Sensitive SELECT Statement Against Teradata Database

I want to make a select NAM, COUNT(*) as cnt on a table, but I want the count to function in case sensitive matter. For example, if the NAM attribute has the following 2 values: DEV dev I would like cnt for each value to be 1 (to have 2 rows in…
Adam
  • 2,347
  • 12
  • 55
  • 81
1 2 3
…
99 100