local_offer teradata

1-10 of 33

Teradata SQL - Round Numbers to Hundreds or Thousands

more_vert

local_offer teradata local_offer SQL

visibility 12
thumb_up 0
access_time 14 days ago

The following code snippets show how to use round numbers to hundreds or thousands in Teradata.  warning Alert - The following code snippets are used to round to the smallest hundreds or thousands that is equal or greater than the i...

open_in_new Code snippets

Teradata SQL - Get Rid of Spaces from String

more_vert

local_offer teradata local_offer SQL

visibility 23
thumb_up 0
access_time 14 days ago

In article   Teradata SQL...

open_in_new Code snippets

Teradata SQL LIKE: Contains, Starts With, Ends With Functions

more_vert

local_offer teradata local_offer SQL

visibility 12
thumb_up 0
access_time 14 days ago

This page shows you how to use LIKE

open_in_new Code snippets

Trim Leading or/and Trailing Zeros in Teradata

more_vert

local_offer teradata local_offer SQL

visibility 11
thumb_up 0
access_time 14 days ago

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

open_in_new Code snippets

Python: Save Pandas DataFrame to Teradata

more_vert

local_offer teradata local_offer python

visibility 1070
thumb_up 1
access_time 4 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  ...

open_in_new Spark

Truncate table in Teradata

more_vert

local_offer teradata local_offer SQL

visibility 80
thumb_up 0
access_time 4 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.tab...

open_in_new Code snippets

Create, Insert, Delete, Update Operations on Teradata via JDBC in Python

more_vert

local_offer teradata local_offer python local_offer Java

visibility 600
thumb_up 0
access_time 4 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 ho...

open_in_new Python Programming

Teradata SQL - Use OREPLACE to Replace or Remove Characters

more_vert

local_offer teradata local_offer SQL

visibility 420
thumb_up 0
access_time 5 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. ANSI SQL REPLACE function REPLACE function is commonly implemented in many other SQL databases such as ...

open_in_new Code snippets

Save DataFrame to SQL Databases via JDBC in PySpark

more_vert

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

visibility 2457
thumb_up 0
access_time 5 months ago

In my previous article about  Connect to SQL Server in Spark (PySpark) , I mentioned the ways t...

open_in_new Spark

Teradata SUBSTRING / SUBSTR and REGEXP_SUBSTR Functions

more_vert

local_offer teradata local_offer SQL

visibility 118
thumb_up 0
access_time 5 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. ...

open_in_new Code snippets

1-10 of 33

Tag cloud

local_offer C# local_offer .NET local_offer ASP.NET local_offer SQL Server local_offer SSIS local_offer QlikView local_offer HTML local_offer Javascript local_offer MVC local_offer SVN local_offer C&CPP local_offer VB local_offer Context Project local_offer WebMatrix local_offer Linq local_offer Java local_offer Web Services local_offer dotnet core local_offer angular local_offer asp.net core 2 local_offer kontext local_offer xml-rpc local_offer .net core local_offer Azure local_offer asp.net core local_offer identity core 2 local_offer teradata local_offer SQL local_offer python local_offer dotnetcore local_offer bootstrap local_offer zeppelin local_offer spark local_offer hadoop local_offer yarn local_offer hdfs local_offer rdd local_offer scala local_offer parquet local_offer kerberos local_offer powershell local_offer linux local_offer sqoop local_offer power-bi local_offer google-analytics local_offer entity-framework local_offer docu local_offer bigquery local_offer gcp local_offer dataflow local_offer gcs local_offer pyspark local_offer open-banking local_offer hive local_offer partitioning local_offer gulp local_offer NTLM local_offer WSL local_offer ubuntu local_offer oozie local_offer pandas local_offer hue local_offer csharp local_offer dotnet local_offer dotnet-core local_offer mssql local_offer r-lang local_offer shell local_offer spark-2-x local_offer t-sql local_offer .net-core-3 local_offer asp.net core 3 local_offer devops local_offer ssl local_offer bug local_offer aws local_offer jupyter-notebook local_offer f# local_offer machine-learning local_offer windows local_offer windows10 local_offer node.js local_offer plot local_offer sqlite local_offer oauth local_offer how-to