teradata

Articles tagged with teradata.

local_offer teradata local_offer SQL local_offer teradata-functions

visibility 229
thumb_up 0
access_time 7 months ago

In SQL Server, TRY_CAST function returns a value cast to a specified data type is the cast is successful or null is the cast is not successful.  In Teradata, the equivalent function is TRYCAST. -- return int 1030 SELECT TRYCAST('01030' AS int); -- return 2019-01-01 as it is a valid date ...

local_offer teradata local_offer SQL

visibility 133
thumb_up 0
access_time 7 months ago

From Teradata 16, LEAD and LAG OLAP functions are supported. The LAG function returns data from a row preceding the current row at a specified offset in a window group; the LEAD function accesses data from a row following the current row at a specified offset in a window group. Table  ...

local_offer teradata local_offer SQL local_offer teradata-functions

visibility 2648
thumb_up 1
access_time 7 months ago

In ANSI SQL, you can use DATEADD function to easily add or subtract days/week/months/years from a date as the following code snippet shows: SELECT DATEADD ( month , 1 , '20060830' ); SELECT DATEADD ( day , - 1 , '20060831' ); However in Teradata this function is not implemented and you ...

local_offer teradata local_offer SQL local_offer teradata-sql-query

visibility 391
thumb_up 0
access_time 7 months ago

In Teradata, Common Table Expression (CTE) is supported as other databases. You can create recursive CTE or use a reference of a CTE to another CTE. However there is a slight differences compared with other databases - The referenced CTE must be present after the referencing CTE. For example, CTE ...

local_offer teradata local_offer SQL

visibility 659
thumb_up 1
access_time 11 months ago

This code snippet shows how to convert string to date in Teradata.

local_offer teradata local_offer SQL local_offer teradata-sql-query

visibility 313
thumb_up 0
access_time 11 months ago

In different databases, the syntax of selecting top N records are slightly different. They may also differ from ISO standards.

local_offer teradata local_offer SQL

visibility 681
thumb_up 0
access_time 11 months ago

This code snippet shows how to calculate time differences.

local_offer teradata local_offer SQL

visibility 546
thumb_up 0
access_time 11 months ago

JSON is commonly used in modern applications for data storage and transfers. Pretty much all programming languages provide APIs to parse JSON. 

local_offer teradata local_offer spark local_offer pyspark local_offer spark-database-connect

visibility 4666
thumb_up 0
access_time 2 years ago

In my article Connect to Teradata database through Python , I demonstrated about how to use Teradata python package or Teradata ODBC driver to connect to Teradata. In this article, I’m going to show you how to connect to Teradata through JDBC drivers so that you can load data directly into PySpark ...

local_offer teradata local_offer teradata-sql-query

visibility 4725
thumb_up 0
access_time 3 years ago

This page summarize some of the commonly used views in Teradata. In all the views in the following sections, X views are also available though they only return rows that contain information on objects that the requesting database user owns, created, granted privilige on, granted access through the ...

Read more

Find more tags on tag cloud.

launch Tag cloud