Top "Teradata" questions

Teradata is a Relational Database Management System (RDBMS), capable of supporting many concurrent users from various client platforms.

Create table but Drop it if the table exists already

I am working on a request where I have to create a table to insert some data. So, obviously I …

sql teradata create-table drop-table
query to return specific date from teradata timestamp(6)

How can i search for a particular date for eg: '2013-10-22' from teradata timestamp(6) field? sel * from …

sql teradata
SQL - What is the performance impact of having multiple CASE statements in SELECT - Teradata

So I have a query that requires a bunch of CASE statements in the SELECT. This was not the orginal …

sql performance teradata
Selected non-aggregate values must be part of the associated group

I have two tables in Teradata: Table_A and Table_B. Between them is LEFT JOIN. Afterwards I am making …

sql group-by case teradata
How to add/subtract date/time components using a calculated interval?

I'd like to get this to work in Teradata: Updated SQL for better example select case when current_date between …

teradata
multiple columns with multiple values in where clause

I am executing a query which has multiple columns in where clause which has multiple values. I know that in …

teradata
ERROR 2616 Numeric overflow during computation while doing count(*)

I am trying to do a select count(*) from table from a table and I am not able to do …

sql teradata
Issue with subquery - All expressions must have explicit name

Not sure what is going on here and why this is not working. I'm receiving the following error: "All expressions …

sql teradata
Add a sequential number on create / insert - Teradata

In oracle we would use rownum on the select as we created this table. Now in teradata, I can't seem …

sql teradata row-number
hadoop vs teradata what is the difference

I've touched a Teradata. I've never touched hadoop, but since yesterday, I am doing some research on that. By description …

database hadoop teradata business-intelligence