Questions tagged [teradata]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
19 views

Teradata 'Column Dictioanry Name' and 'Column SQL Name' definitions and differences between them

With the following sql query Teradata shows a lot of information about the columns of a table. HELP TABLE Database_Name.Table_Name; Two of them being Column Dictionary Name and Column SQL Name. ...
0
votes
0answers
25 views

Teradata DB Explorer vs Tree

I'm new to Teradata and the following has been confusing me. In Teradata SQL Assistant (login as non DBC), I can see DBC database and my user database. When I expand DBC database I can see views, ...
0
votes
0answers
98 views

Unable to establish connection with data source with Teradata. Missing settings: {[DBCName]}

I'am installed Teradata driver on CentOS as described in official README. After installation drivers is located in /opt/teradata/client /ODBC_32/ /ODBC_64/ Each folder has subfolders and files ...
-1
votes
2answers
27 views

SQL to return preferred duplicate rows

Have a data set that some rows have a duplicate. Looking to return the row with IND = Y if it is present, otherwise to return the N. +------------+---------------+------------+----------+ | ...
0
votes
1answer
155 views

Select rows from table 1, table 2, then selecting based on ID

I am dealing with a large dataset, and have run into some issues because of this. I have a data set like: Table1 State ID Conditional_Value AZ 1 Yes AZ 2 ...
0
votes
1answer
33 views

Does teradata provides free or trial setup of multinode (at least 2 node) environment

I want to test my code on Teradata on 2 node environment. It doesn't need a power of multiple AMPs multiple nodes ( more than 2 ). Like Teradata provides VM of single node setup of its every version, ...
1
vote
0answers
75 views

Teradata Install 32bit appears to have failed

I'm getting the error "The installation of ODBC -32bit appears to have failed. Do you want to continue the installation?" and I'm not sure how to solve it. I've never installed teradata before, and I'...
0
votes
2answers
230 views

Different calculations in EXCEL and TERADATA SQL

The calculation select (75/979.86)*979.86 in Teradata SqL gives 78.3888. In excel, it would give 75 simply and that is logically correct. I get it that SQL is rounding off 75/979.86 to 0.08 ie the ...
1
vote
2answers
822 views

Remove all Null values from Sql table at once

I am very new to Teradata and SQL environment. I am trying to remove all the null values from sql table in teradata using ISNULL(COLUMNNAME,0). But it gives an error that "the data type does not match ...
1
vote
1answer
1k views

how to bring in the most recent record in SQL in Teradata

I have a table that contains store number, inventory $, inventory year from 2014 through 2018. so if store 111 has inventoried in all the years, I will have 5 records for that store: Store Inventory ...
0
votes
1answer
239 views

How show command works internally in teradata?

When we run show command it lists the object definition. I believe it will query the dictionary tables and rebuild . Could you help us to understand how it queries the internal tables?
0
votes
1answer
33 views

For each row, find the next closest value in another table (Teradata)

I've seen a few close examples here but I'm not quite getting something close enough for me to noodle out a fix. I have events, where trucks come in and out of a gate and I have two tables. The ...
0
votes
1answer
76 views

How create copy SYSDBA?

now I have 2 user, DBC and SYSDBA. I want to create else 5 users with same rights as SYSDBA. Please help to write script.
0
votes
1answer
315 views

How make DBMS_OUTPUT?

I know in Oracle DBMS_OUTPUT.enable; DBMS_OUTPUT.put_line(in_COMP); Now I writing procedure in Teradata create procedure SANDBOX.CreateNewUser () begin DECLARE errstr VARCHAR(1000); begin ...
1
vote
1answer
209 views

How create user with admin option?

I have Teradata v16.10.0. I want to create user with admin options: with possibility get to grant select any tables/views. How to create such user right?
0
votes
3answers
340 views

How DROP USER: while the user is logged on?

did try to DROP USER by Teradata Studio: DROP USER user_1; client returned error: Executed as Single statement. Failed [3561 : HY000] Cannot DROP USER user_1 while the user is logged on. Elapsed ...
0
votes
1answer
795 views

Teradata: Get quarter for specific date

When selecting the maximum date of a column how do I obtain which quarter that date falls into without using a CASE statement?
1
vote
2answers
3k views

Calculate period start and end date

My table: Date Employee Status ----------------------------- 20171106 001 At work 20171107 001 Sick leave 20171108 001 At work 20171109 001 At ...
1
vote
2answers
1k views

Database explorer disabled in SQL Assistant

I am a new Teradata SQL assistant user. I have used SQL Server Management Studio before. In the View option, I am unable to toggle the Database Explorer. Please let me know how I can access the ...
1
vote
1answer
3k views

Group multiple rows with different column values to a single row

I have 3 records with 3 column values for the same key. PFB sample data. CREATE TABLE student ( student varchar(100), maths int, physics int, chemistry int ) PRIMARY INDEX (student) ...
0
votes
1answer
252 views

Teradata ODBC - version 14 and 15 side by side

Is there a way to install version 15.11 alongside version 14.10 of the ODBC Teradata drivers? I've run the 15.11 install wizard but it seems to want to remove all previous versions automatically. ...
1
vote
0answers
355 views

Teradata SQL Assistant - CALL Failed HY000: User Defined Function source on the client is not supported by the driver

Using Teradata SQL Assistant to install a user defined R script fails with an error. The call looks like this: SET SESSION SEARCHUIFDBPATH = demouser; -- Tells the linux user tduser, where to find ...
3
votes
1answer
4k views

Teradata: Select Table With No Lock

As I understand, when selecting from a table in Teradata the table is locked by default. I would like to do a simple select * from table without locking the table. Meaning, i want to do a select and ...
1
vote
2answers
2k views

More efficient SQL for different databases with same schema

I have data stored in different monthly databases that have the exact same name schema for the tables and columns. Each monthly database has ~10 million rows. I'm looking for a more efficient way to ...
1
vote
2answers
68 views

Aggregating spend by customer where accounts can be re-assigned to different customers

I want to join unique customer ids with their spends. Problem: The account_no can be assigned to a different customer (A,B,C etc) at different point in time (assume an employee A leaving the ...
1
vote
0answers
196 views

Teradata backup information query

I'm looking for a way to query the last backup time for each database in Teradata 14.10. I am piecing together something with info from DBQL tables, but am unable to get anything that seems to be ...
3
votes
1answer
453 views

Teradata to drive responsive web application

Does anyone have experience using Teradata to drive a typical, responsive client-side web application? What is your evaluation? Specifically, how well does it perform in single-read and single-write? ...
1
vote
0answers
112 views

Teradata REST API performance metrics

What are single read and single write speeds like with the Teradata REST API? Is it fast enough to be used as an operational database for a typical responsive web application? What is the difference ...
0
votes
1answer
64 views

Explanation of the query [closed]

Can somebody explain me the below query? select SUBSTR(SUBSTR(PART_SEQ_NBR, POSITION('_' in PART_SEQ_NBR )+1, char_length(PART_SEQ_NBR) ...
1
vote
2answers
58 views

SQL to combine records only if data is available [closed]

I have a table with the following format: id description1 description2 123 null abcd 123 zyxw abcd 124 null efgh 124 vuts ...
1
vote
1answer
739 views

how to execute unix commands within nzsql?

I'm converting a script from Teradata to Netezza, and I'm stuck at the portion where BTEQ uses the functionality of the OS to check if a file contains any data. If it does, it is deleted. I want to ...
1
vote
1answer
317 views

Teradata 15 : Failure 5619 Role nesting exceeded single-level

I am using Teradata 15. In Active Directory, We have a policy to assign a universal group, which has people, to a local group, where permissions are assigned. So I create two Teradata roles to mimic ...
0
votes
1answer
79 views

Can't get update one prompt for same variable over multiple tables

I've tried using the following: select * from TABLE1 where COLUMN= :VAR union select * from TABLE2 where COLUMN= :VAR; I'm getting the following error message back: [Teradata Database] [TeraJDBC 14....
0
votes
1answer
285 views

Teradata Join Syntax

I'm having a hard time doing what I want to do here, as SQL (and Teradata SQL on top of that) is not my main forte. I have two queries that I want to join together. I want everything that returns ...
1
vote
1answer
4k views

Set default database for connection

Super n00b question, I know, but I can't seem to find it anywhere that's easy to find, so it would be good to document this here. Say I connect to a Teradata system as a particular user, NICK, but I ...
4
votes
0answers
1k views

How does the Teradata REST API performance compare to other means of querying Teradata?

I'm planning on using the Teradata Python module, which can use either the Teradata REST API or ODBC to connect to Teradata. I'm wondering what the performance would be like for REST vs. ODBC ...
0
votes
0answers
1k views

Teradata 15: install TTU 15, The installation of Shared ICU-32 bit appears to have failed

I downloaded Teradata Tools and Utilities (TTU 15) from Teradata support site. After I uninstalled the TTU 15, now I cannot install it again! I am using Windows 7 Enterprise version. Here is my ...
3
votes
1answer
7k 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 ...
3
votes
1answer
827 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
109 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 ...
3
votes
1answer
7k 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
831 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: ...
2
votes
2answers
5k 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 derived_table(...
0
votes
2answers
4k views

Teradata SQL syntax from date to quarter

I need Teradata SQL syntax to extract quarter from a date: Date: (YYYY-MM-DD) 2015-09-12 2015-05-22 2014-12-15 Given below is the expected output: 3Q15 2Q15 4Q14 Query which I have tried (wrapped ...
0
votes
1answer
11k 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 ...
1
vote
1answer
785 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
434 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
2k 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 ...
2
votes
2answers
5k 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 ?
3
votes
3answers
1k 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 ...