Teradata is a parallel 'shared-nothing' database management system. It is primarily used for data warehouse applications with large data volumes.

learn more… | top users | synonyms

1
vote
2answers
29 views

Why do we use Group by 1 and Group by 1,2,3 in SQL query?

In SQL queries, we do use Group by clause to apply aggregate functions. But what is the purpose behind using numeric value instead of column name with Group by clause? For example: Group by 1.
0
votes
0answers
12 views

How to split a large table in Teradata

I'm trying to load data from a very large table (200 million rows) into a Presentation Datamart (PDM) for an Enterprise Data Warehouse using Teradata 14.10. I want to split this large table into ...
0
votes
3answers
44 views

SQL MAX function

Suppose I have a table with attributes Name, Age as follows: MyTable (Name, Age) Now, to get the oldest age I can write the following query: SELECT MAX(Age) AS "Oldest Age" FROM MyTable; ...
0
votes
0answers
26 views

Teradata query to fetch records based on date value

I have a case where current date is passed as a parameter to fetch records in TD through a SQL. If current_date doesnt have any records in the DB, then I need to query the DB using previous date ...
0
votes
1answer
142 views

Problem while connecting to teradata with sqoop

I am trying to connect to Teradat using Sqoop with following command: sqoop import -libjars /usr/lib/sqoop/lib/tdgssconfig.jar,/usr/lib/sqoop/lib/terajdbc4.jar -driver com.teradata.jdbc.TeraDriver ...
0
votes
0answers
34 views

Is it possible to automatically convert/load an Access database into a CSV or TXT file?

I'm working on moving an Access database to ultimately Teradata. Now I know that Teradata can't read Access files (.aacdb). So what a colleague has tried was manually convert one of the tables in the ...
0
votes
1answer
72 views

Normalization of Time Series Data

I have a table containing various a/b test experiment performance on a daily basis. The table structure looks something like this: date | experiment | user_count | user_attr | sales ...
0
votes
0answers
142 views

Teradata With Recursive

Hi All i'm having problems writing a recursive query and i ran out of options that i can think of . The query should join serial numbers in one cell coma delimited to a specific order number . ...
3
votes
1answer
729 views

Teradata : Disadvantage of Collect stats

I want to know any disadvantage can occur by doing collect stats on a column that is being widely used in join condition across so many procedures ? (Eg. the column is accessed 300+ times access in 60 ...
0
votes
2answers
192 views

Teradata performance statistics

I need some statistics regarding the performance of Teradata, something like with a given hardware, given nodes and given AMPs - a table which has thousands of rows can be read in 't' secs. I need ...
1
vote
1answer
440 views

Rename primary key constraint in Teradata

Does Teradata have a way to rename a primary key constraint, rather than dropping it and recreating it? I'm using SP_RENAME for SQL Server and ALTER TABLE...RENAME CONSTRAINT for Oracle, but I don't ...
5
votes
2answers
808 views

Teradata: How to design table to be normalized with many foreign key columns?

I am designing a table in Teradata with about 30 columns. These columns are going to need to store several time-interval-style values such as Daily, Monthly, Weekly, etc. It is bad design to store ...