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

Teradata - How to add-list all available databases on Teradata server under SQL Assistant Query Tool?

I am using Teradata SQL Assistant. I am a new user to Teradata database. Like in SQL Server Management Studio, I am not able to see the available databases on Teradata Server via SQL Assistant. So I just wanted to ask, how can I list all the…
Aditya
  • 2,299
  • 5
  • 32
  • 54
4
votes
3 answers

Converting hours into minutes in SQL

i'm trying to write a regular expression that will convert the hours into minutes. Currently I have a value which give me the number of hours before the dot and the number of minutes after the dot, for example 6.10 is 6 hours and 10 minute. Can i…
user7172167
  • 61
  • 5
4
votes
4 answers

Doing a join of two tables after having sampled them

I need a sample after I make a join of two tables, something like: SELECT * from A left join B on A.col=B.col sample 1000000 The problem is that A and B are huge (over 3 billion rows) and I run out of spool space when I try a join. Is there a…
user
  • 2,015
  • 6
  • 22
  • 39
4
votes
3 answers

Connected Components

I have a set of data that has been created by matching together similar sub-items, and then GROUPing these similar items by "category". Now, the resultant categories must be matched in such a way that groups related categories together within each…
transistor1
  • 2,915
  • 26
  • 42
4
votes
2 answers

How to get lastaltertimestamp from Hive table?

Teradata has the concept of lastaltertimestamp, which is the last time an alter table command was executed on a table. lastaltertimestamp can be queried. Does Hive have a similar value that can be queried? The timestamp returned by hdfs dfs -ls…
user1332148
  • 1,256
  • 2
  • 11
  • 24
4
votes
1 answer

'[08001][TPT] [ODBC SQL Server Wire Protocol driver] Invalid connection Data

I have a python program that implies connecting to a teradata database. The server name is defaulted. Two people can succesfully use the python program but one person can't and gets the following error message: '[08001][TPT] [ODBC SQL Server Wire…
Filip Eriksson
  • 975
  • 7
  • 30
  • 47
4
votes
1 answer

How user, database and schema are related in Teradata?

I am aware of Oracle. In oracle schema or user is more or less same. When we create a user, schema is created. Database is something we create when we install oracle. I am new to Teradata. Are things same in case of Teradata too? How user, database…
Dev
  • 13,492
  • 19
  • 81
  • 174
4
votes
2 answers

R and odbcDriverConnect() to connect R to teradata

I am trying to connect R to Teradata and am not sure what the input items are to the RODBC::odbcDriverConnect(). There is a teradataR package, but it is only used with R versions 3 and under, which I neither have nor want to switch to. Below is a…
Tracy
  • 699
  • 2
  • 9
  • 21
4
votes
4 answers

SQL: case-when statement with "exists"

I'd like to be able to set add a field that answers the question "For a value in this record, does that value meet some condition in another table?". I thought I'd try a case-when with an exists, but Teradata (my dbms) does not like it. Any…
Chris
  • 1,421
  • 3
  • 18
  • 31
4
votes
2 answers

Teradata sql Select Failed [2616] Numeric Overflow occurred during computation

I get: Error 2616 (Numeric overflow occurred duing computation) when I run the code below. I developed 2 separate queries that each run. When I put them in one query and use a UNION I get the error message. 1 side of the union returns 274…
Shaves
  • 884
  • 5
  • 16
  • 46
4
votes
1 answer

LISTAGG equivalent in Teradata

Is there any equivalent of Listagg function of oracle in teradata. With recursive is an option I have tried, but wanted something other than. Thanks Aritra
Aritra Bhattacharya
  • 720
  • 1
  • 7
  • 18
4
votes
2 answers

Multiple table join in hive

I have migrated Teradata tables' data into hive . Now I have to build summary tables on top of imported data. Summary table needs to be built from five source tables If I go with joins I'll need to join five tables is it possible in hive ? or should…
Chhaya Vishwakarma
  • 1,407
  • 9
  • 44
  • 72
4
votes
1 answer

Move billions of records from one table to another in teradata

I have a teradata view, containing 1 billion records for each day and I need to process data for 1 year, so we have 365 billion records and Data is partitioned by date - interval each day. I need to Insert - select 3 ID columns(data will be grouped…
Rahul Khanna
  • 137
  • 2
  • 8
4
votes
3 answers

Find out the currently running queries in teradata using SQL instead of viewpoint

I want to find out what are the queries that are currently under execution specific to a user or a group . I don't want to use view point . I need to achieve this functionality using a SQL.
venkat
  • 77
  • 3
  • 11
4
votes
1 answer

Error in JDBC-Teradata Connectivity

I have tried connecting to teredata DB through JDBC. I am using the jars 'terajdbc4.jar' and 'tdgssconfig.jar', but I am getting a ClassNotFoundException and NoClassDefFoundError for something kind of com.ncr.teradata.jtdgss.TdgssManager is not…
Tirthankar
  • 75
  • 1
  • 9
1 2 3
…
99 100