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

List the days between two given dates

I am working on a code like this CREATE FUNCTION edw_devdb.test ( StartDate Date, EndDate Date) RETURNS DATE LANGUAGE SQL DETERMINISTIC CONTAINS SQL SPECIFIC test.myudf CALLED ON NULL INPUT SQL SECURITY DEFINER …
TD123
  • 27
  • 1
  • 9
1
vote
2 answers

getting the number of day in quarter Teradata

I am trying to get Which day of the quarter when you give a current date. For Example if i give 01/25/2012 then the output should be 25. Since it is the 25th day of the quarter. Similarly if i give 02/01/2012 it should give 32 as output. I am able…
TD123
  • 27
  • 1
  • 9
1
vote
0 answers

Connecting to Teradata with Perl and undefined symbol: DBCHINI

i am having issues trying to get perl to connect to Teradata. I have installed the Teradata DBD from CPAN as well as the teradata utilities required. however when i attempt to run a perl script i get the following error: /usr/local/bin/perl: symbol…
N0m0r3
  • 11
  • 1
1
vote
1 answer

How to join 3 tables to a single table in SQL

I need to join 3 tables to a single table. Here is the scenario. Table 1: Has user_id, app_id Table 2: Has user_id, gender Table 3: Has app_id, app_name(PC, Mobile) Table 4: Has user_id, user_city Now I am looking to get a count of users by mobile…
Gaurav Mehta
  • 1,103
  • 4
  • 16
  • 27
1
vote
1 answer

Calculate date for particular day in Teradata

How to calculate date for current week Friday in Teradata? I need a general function that can calculate date for friday for any week. thanks
user3438498
  • 211
  • 3
  • 11
  • 21
1
vote
1 answer

Teradata ODBC 15.0 "ODBC Driver does not support the requested properties"

I'm using ADODB in Excel 2007 VBA to connect to a Teradata 14.0 server using the Teradata ODBC 15.0 driver. Everything works as expected, except for when I submit very large queries through ADODB.Recordset.Open. Sporadically, when I attempt…
JNevill
  • 46,980
  • 4
  • 38
  • 63
1
vote
1 answer

Teradata-jdbc: What's the point of using Fastload if java has memory limitations?

Here is the link to a sample jdbc Fastload program from the teradata website : http://developer.teradata.com/doc/connectivity/jdbc/reference/current/samp/T20205JD.java.txt It inserts only one row so I modified it to insert 500K rows by replacing…
user3191304
  • 221
  • 3
  • 8
1
vote
2 answers

How is query working at Teradata?

I tried to run below query at teradata and It resulted as expected : select column1 as c1Alias from my_table where column2 in ( c1Alias , 10 , 20 , 30) ; But I tried to run same query on HIVE , It throws exception as given below : FAILED:…
Sanjiv
  • 1,795
  • 1
  • 29
  • 45
1
vote
1 answer

sqoop to transfer data to HDFS from Teradata

sqoop to transfer data to HDFS from Teradata: Getting error as below: -bash-4.1$ sqoop import --connection-manager com.cloudera.sqoop.manager.DefaultManagerFactory --driver com.teradata.jdbc.TeraDriver \ --connect…
user3754136
  • 509
  • 11
  • 25
1
vote
1 answer

Pyodbc Issue with Teradata

Getting below error while connecting with Teradata from pyodbc in Linux ('632', '[632] 523 630 (0) (SQLDriverConnect)') Details below: Connection String DRIVER={Teradata};DBCNAME=;UID=;PWD=;QUIETMODE=YES; Pyodbc Version:pyodbc-2.1.8 Python…
Haroon Rashedu
  • 155
  • 1
  • 9
1
vote
1 answer

SOH (\001) Fastload Delimiter

I'm trying to set the delimiter in a Fastload to \001 with no success. Anybody know if this is possible? SET record vartext "\001";
cloud36
  • 1,026
  • 6
  • 21
  • 35
1
vote
2 answers

Why does Teradata Identity column have negative values?

I am very new to Teradata (1 week) and my primary skillset is SQL Server. I am pulling data from one of the TeraData tables to SQL Server table and the TD table has an Identity column with negative values. I looked at the DDL for that table and it…
rvphx
  • 2,324
  • 6
  • 40
  • 69
1
vote
1 answer

Where does the NOT LOCAL AFTER JOURNAL get stored in the Teradata Catalog tables

When I run this below query, CREATE SET TABLE "DBC1"."NotLocalTable",FALLBACK, BEFORE JOURNAL , NOT LOCAL AFTER JOURNAL , CHECKSUM = LOW ( "Column1" CHARACTER(5) NOT NULL, "Column2" CHARACTER(5) ); I see the catalog Journal column…
Ravikumar S
  • 185
  • 3
  • 12
1
vote
1 answer

Continuous Integration for Teradata Projects

I am looking to develop a continuous integration system for Teradata projects. We have more than 100 teradata projects manually migrating the code to different environments. I am trying to automate this process using Jenkins. Goal is to pull the…
Upen
  • 1,388
  • 1
  • 22
  • 49
1
vote
3 answers

Teradata - word frequency in a column

Say I have the following column in a teradata table: Red ball Purple ball Orange ball I want my output to be Word Count Red 1 Ball 3 Purple 1 Orange 1 Thanks.
kittymad
  • 93
  • 7