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

How to count the number of times an element appears consecutively in a table in Teradata?

I have a table that looks like this ID, Order, Segment 1, 1, A 1, 2, B 1, 3, B 1, 4, C 1, 5, B 1, 6, B 1, 7, B 1, 8, B Basically by ordering the data using the Order column. I would like to understand the number of consecutive B's for each of the…
xiaodai
  • 14,889
  • 18
  • 76
  • 140
1
vote
1 answer

Run time error [Teradata] The object name is too long in NFD/NFC

When I try to run a SQL query through VBA Code it is throwing the below error: Run time error -2147467259(80004005) [Teradata] The object name is too long in NFD/NFC Set rec1 = New ADODB.Recordset rec1.Open oSql,…
Rajyalakshmi Gangisetty
  • 53
  • 5
  • 18
1
vote
1 answer

How to pass a parameter into a long query in Teradata

I have a somewhat large query (~8 tables being joined, 100 lines of sql or so) that I use frequently in order to join many different data sources together. I would like to be able to pass a parameter into the query so that myself and other members…
user2395059
  • 80
  • 1
  • 2
  • 10
1
vote
1 answer

How to count words frequency in Teradata

For example if I have 1000 rows of data that has customer ID (e.g. 123) and their comments on our product (e.g. great product easy use) How do I use Teradata (version 15) to do a word frequency count so that the output has two columns one with the…
user2525645
  • 73
  • 3
  • 8
1
vote
1 answer

Significance of --connection-manager in Sqoop

I have written sqoop script to import data from Teradata to Hive. `sqoop import \ --connect $JDBC_URL \ --driver com.teradata.jdbc.TeraDriver \ --username $Username \ --password $Password \ --table $TD_Table \ --hive-import \ --hive-overwrite \ …
Chhaya Vishwakarma
  • 1,407
  • 9
  • 44
  • 72
1
vote
1 answer

Teradata- insert records from UPI table to NUPI table

How the data will be distributed among the AMPs if the records are inserted to a NUPI table from a UPI table? Will the data be copied and retained in the same AMP as that of original one?
AKSHAYAA VAIDYANATHAN
  • 2,715
  • 7
  • 30
  • 51
1
vote
1 answer

drop range partition in oracle between two dates

in Teradata you can do something like: DROP RANGE BETWEEN DATE FROM_DATE AND DATE TO_DATE, EACH INTERVAL '1' DAY; Is there an equivalent way of doing this in Oracle? dropping a r
bytebiscuit
  • 3,446
  • 10
  • 33
  • 53
1
vote
1 answer

How to write a regular expression to replace dots and single spaces inside of a string in Teradata?

I am badly in need to write a regular expression which replaces dots or single spaces inside of particular sub strings in a string. Suppose the string that I want to parse is something like 'AB.C$. WFD.C!-' . Now the reg ex should essentially…
StrugglingCoder
  • 4,781
  • 16
  • 69
  • 103
1
vote
1 answer

How to create an SQL query that checks for duplicates in multiple tables

I want to create an SQL query where I check if duplicates exist in several different tables. I do this in Teradata. I want the output to look like the following. |Table A| |Table B| |Table C| |Table D| |Table D| For each of these columns we can…
Filip Eriksson
  • 975
  • 7
  • 30
  • 47
1
vote
2 answers

How can I check if a character is allowed to be uploaded in Teradata?

How can I check if a character is allowed to be uploaded in Teradata ? Recently I was uploading (using jdbc) a .csv file that contained some weird SUB characters. The upload failed. Later i found out that those weird characters were the older…
Alex
  • 355
  • 7
  • 25
1
vote
3 answers

SQL query to identify 0 AFTER a 1

Let's say I have two columns: Date and Indicator Usually the indicator goes from 0 to 1 (when the data is sorted by date) and I want to be able to identify if it goes from 1 to 0 instead. Is there an easy way to do this with SQL? I am already…
Chris
  • 12,900
  • 12
  • 43
  • 65
1
vote
1 answer

Teradata 13: CASE statement in Join

Is CASE statement allowed in join? Is there a good way to accomplish the task here? My real query has some other left join. I would like to join T1 and T2 in this condition: 1. when T1.sub_service is not null, then join with T2.type 2. when…
angelcake
  • 119
  • 5
  • 7
  • 18
1
vote
2 answers

Child user can't select view of parent in teradata

In Teradata SQLAssistant, I have created a db user USER1 which has 17 views. This user can do a SELECT on any view, thanks to a profile/role I granted and then associated to him. His child USER2 is a db user with the same profile/role as USER1, but…
daniel.rna
  • 73
  • 1
  • 11
1
vote
1 answer

Oracle equivalent of ABORT where in teradata

In teradata you can do something like this: ABORT 'custome message' WHERE :parameter_var NOT IN ( SELECT var FROM table_name ); exec delete_something(:parameter_var); What's the equivalent in Oracle. I'm thinking of using exceptions but…
bytebiscuit
  • 3,446
  • 10
  • 33
  • 53
1
vote
1 answer

Teradata create global temporary table

In Teradata I want to create a global temporary table and then reference this global table in other queries. I don't want to create a volatile table as I am using Teradata through another front-end and that front-end has to be able to tell whether…
xiaodai
  • 14,889
  • 18
  • 76
  • 140
1 2 3
…
99 100