teradata

Articles tagged with teradata.

local_offer teradata local_offer SQL local_offer teradata-functions

visibility 67
thumb_up 0
access_time 2 months ago

In article   Teradata SQL - Use OREPLACE to Replace or Remove Characters , it shows how to use OREPLACE function in Teradata to replace or remove strings. This page will show one more alternative way of doing that using regular expressions. select oreplace('Kontext is a website for data ...

local_offer teradata local_offer SQL local_offer teradata-functions

visibility 100
thumb_up 0
access_time 2 months ago

This page shows how to trim or remove leading or/and trailing zeros using Teradata SQL.

local_offer teradata local_offer python local_offer python-database

visibility 1653
thumb_up 1
access_time 5 months ago

Pandas is commonly used by Python users to perform data operations. In many scenarios, the results need to be saved to a storage like Teradata. This article shows you how to do that easily using JayDeBeApi or  sqlalchemy-teradata   package.  JayDeBeApi package and Teradata JDBC ...

local_offer teradata local_offer SQL

visibility 138
thumb_up 0
access_time 6 months ago

In SQL Server, we can use TRUNCATE statement to clear all the records in a table and it usually performs better compared with DELETE statements as no transaction log for each individual row deletion. The syntax looks like the following: TRUNCATE TABLE { database_name.schema_name.table_name | ...

local_offer teradata local_offer python local_offer Java local_offer python-database

visibility 944
thumb_up 0
access_time 6 months ago

Python JayDeBeApi module allows you to connect from Python to Teradata databases using Java JDBC drivers. In article Connect to Teradata database through Python , I showed how to use teradata package to connect to Teradata via Teradata ODBC driver. This article demos how to use this JayDeBeApi ...

local_offer teradata local_offer SQL local_offer teradata-functions

visibility 770
thumb_up 0
access_time 6 months ago

OREPLACE functions in Teradata can be used to replace or remove characters from a string. OREPACE is Teradata's extension to ASNI SQL. The usual REPLACE function is not available. REPLACE function is commonly implemented in many other SQL databases such as SQL Server, MySQL, BigQuery, Oracle, etc.

local_offer pyspark local_offer spark-2-x local_offer teradata local_offer SQL Server local_offer spark-database-connect

visibility 4510
thumb_up 0
access_time 6 months ago

In my previous article about  Connect to SQL Server in Spark (PySpark) , I mentioned the ways to read data from SQL Server databases as dataframe using JDBC. We can also use JDBC to write data from Spark dataframe to database tables. In the following sections, I'm going to show you how to ...

local_offer teradata local_offer SQL local_offer teradata-functions

visibility 200
thumb_up 0
access_time 7 months ago

Extract sub string from a string is a common operation in data analytics. In Teradata, function SUBSTRING (SUBSTR) and REGEXP_SUBSTR are provided to achieve that. SUBSTR is used to extract string from a specified location while REGEXP_SUBSTR is used to extract string using regular expressions. -- ...

local_offer teradata local_offer SQL

visibility 132
thumb_up 1
access_time 7 months ago

COALESCE function in Teradata returns NULL if all arguments evaluate to null; otherwise it returns the value of the first non-null argument. NULLIF is to used evaluate two expressions and returns NULL if the two arguments are equal otherwise if returns the first arguments. IS NULL is used to ...

Read more

Find more tags on tag cloud.

launch Tag cloud