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
1answer
9 views

Teradata 15: Failed [5315 : HY000] An owner referenced by user does not have SELECT WITH GRANT OPTION access to DBC.RoleMembersV.RoleName

I am using Teradata 15. Using a powerful database user sysdba, I created the following view: REPLACE VIEW DBA_TABLES_TEST.ROLE_ALL_APP_USERS AS SELECT A.ROLENAME FROM DBC.ROLEMEMBERSV A ...
2
votes
1answer
24 views

How can I force Teradata to create a table in memory?

Teradata has an "intelligent" in-memory engine that dynamically loads some data into memory based on usage. How can I force it to create or store a table in memory all the time?
3
votes
0answers
73 views

Oracle replicat is abending when oracle is having special char while loading to teradata

I am doing replication from oracle to teradata where oracle is having below charter in one column. ->->-> ACSII value for this char is 26 . I need to replace it with null . In the charmap we have ...
0
votes
1answer
54 views

Selecting Only One Record with Most Recent Date Using Table Join

I have a list of 463 CARRIER_CD. I am attempting to retrieve the most current BILL_DT for each of the 463 CARRIER_CD. I have uploaded the 463 unique CARRIER_CD to a database named edw_sbx_bt the ...
0
votes
0answers
46 views

Teradata how to create a sysdba super user

I am relatively new to Teradata. I was told by my Teradata consultant to create a super user or a role for DBAs to use, in stead of using DBC. I tried the following syntax, but kept getting errors: ...
1
vote
0answers
76 views

Teradata view with “With Clause” syntax

I am trying to a view with "With" clause in Teradata but it is not allowing to create a view. Please suggest with any options. Given below is the query which I have tried: create view ...
0
votes
1answer
55 views

Teradata sql syntax from date to quarter

Need a Teradata sql syntax to extract quarter from a date. Given below is the expected output Date: (YYYY-MM-DD) 2015-09-12 2015-05-22 2014-12-15 Output 3Q15 2Q15 4Q14 Query which I have ...
0
votes
1answer
107 views

What is the date function used to display month name from Date column in Teradata

I have a table with Date column and I need to display Month name. I found EXTRACT(MONTH) function in teradata to display the month_number but it does not serve my purpose. I can still use case ...
0
votes
0answers
30 views

Unable to execute the Teradata stored procedure due to syntax errors

ERROR: CALL Failed. 3707: SP_PARTICIPANTS_BY_AGE:Syntax error, expected something like a name or a Unicode delimited identifier between '(' and ')'. Below is the query used REPLACE PROCEDURE ...
0
votes
2answers
57 views

Need help with SQL query in Teradata

I have a table with the following columns member_number step_count social_activity -- (which contains both Challenges and Posts) high_fives Basically all the columns 2-4 are counts for members. I ...
0
votes
0answers
96 views

Cant connect to local teradata database in VMware image

Login credentials for VM linux: root/root database: dbc/dbc The image`ve been downloaded from here. (this version TDExpress15.00.02.08_Sles11_40GB.7z) I successfully launched VM image, but failed ...
1
vote
2answers
96 views

How do I get a list of all the partitioned tables and partitioning details in my Teradata?

How do I get a list of all the partitioned tables in teradata? and How do I get a partitioning columns and details for a table in teradata ?
0
votes
0answers
75 views

INSERT INTO SELECT causing data to double

I have strange issue. I am working in a Teradata database. In a procedure I am populating a main table by processing data via multiple intermediate tables. But in the end only one table is populating ...
0
votes
1answer
291 views

teradata database unable to increase database size in permanent space

Anyone with teradata database experience? I'm new to this database and I've been tasked to increase the size of a database. I am using Teradata Administrator to do this. I am using Tools > Modify ...
0
votes
0answers
97 views

Why does a table take more space in SQL server than in Teradata? [closed]

Is there any reason for a table to occupy significantly more space in SQL server than Teradata? The rows and data structure (columns, data types, data type length) are same, no extra objects like ...
0
votes
0answers
69 views

Granting permission on an altered table in Teradata

I have a table, which has two columns say A and B as part of the Primary index PI_AB. I have to alter the length of B column - increase it. I was planning to alter the primary index to just have A, ...
1
vote
0answers
119 views

Convert Teradata Database to SQL Server 2012 [closed]

I am just wondering if anyone has any experience, knowledge, or recommendations on migrating a Teradata database to SQL Server 2012. I have never worked with Teradata before so I am unfamiliar with ...
0
votes
1answer
830 views

Teradata SQL Assistant - List tables under DBC in the Database Explorer

I am able to query, but under DBC, in the Database Explorer, I do not see the list of tables. That also makes it impossible for me to qualify name and get any kind of ide support while writing my ...
1
vote
2answers
1k views

Best practice - use of derived table or use the original table in join?

Imagine I have the following tables in Teradata : TableA : Field1|Field2|Field3 TableB : Field1|Field4|Field5 I am trying to join these two tables Method 1 : SEL TableA.Field3, TableB.Field4 ...
0
votes
1answer
616 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
577 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
110 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
1k 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
1answer
119 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 ...
4
votes
1answer
1k 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
272 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
606 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 ...
6
votes
2answers
1k 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 ...