Top "Teradata" questions

Writing Efficient Queries in SAS Using Proc sql with Teradata

EDIT: Here is a more complete set of code that shows exactly what's going on per the answer below. libname …

sql sas teradata

How do I add comments to existing table DDL in Teradata?

I am adding some new columns to a table and want to add documentation to the table DDL for future …

ddl teradata

WHERE and JOIN order of operation

My question is similar to this SQL order of operations but with a little twist, so I think it's fair …

sql teradata

How do you check if a field contains all numeric values using Teradata SQL?

I'm looking for a function similar to ISNUMERIC() from T-SQL with Teradata SQL. I'd like a simple method to return …

teradata

Safe casting VARCHAR to DECIMAL in Teradata

In Teradata DB I have source table create set table SRC_TABLE ( Some_Id varchar(2O) not null ); This table …

casting decimal varchar teradata isnumeric

Sqoop import Null string

The Null values are displayed as '\N' when a hive external table is queried. Below is the sqoop import …

hadoop null hive teradata sqoop

How to improve performance for slow Spark jobs using DataFrame and JDBC connection?

I am trying to access a mid-size Teradata table (~100 million rows) via JDBC in standalone mode on a single node (…

apache-spark teradata pyspark spark-dataframe

Teradata regexp_replace to eliminate specific special characters

I imported a file that contains email addresses (email_source). I need to join this table to another, using this …

regex teradata regexp-replace

Snapshot too old error

I am getting 'snapshot too old error' frequently while i am running my workflow when it runs for more than 5 …

oracle teradata informatica

JOIN versus EXISTS performance

Generally speaking, is there a performance difference between using a JOIN to select rows versus an EXISTS where clause? Searching …

sql teradata