teradata

Sysdate in Teradata

There is no sysdate built-in function in Teradata. You can use current_date and current_timestamp function.You can also create custom function named "sysdate" to replicate it in Teradata. If you have worked in Oracle or MySQL then you must have used sysdate a lot. In this post we will see how you can use "sysdate" in …

Sysdate in Teradata Read More »

Redshift

Redshift ORDER BY

Redshift ORDER BY is used to sort the output rows in the result set. You can sort the output rows in ascending or descending order. By default, the sorting order is ascending. You can sort output rows on the basis of single column, multiple columns or even combination of ascending and descending for different columns. …

Redshift ORDER BY Read More »

Redshift

Redshift Select

In this post, I will show you how you can use SELECT statements in Redshift to query data from tables. SELECT is used to fetch one or more columns directly from the table. The SELECT is one of the most simple and yet challenging at times statement in Redshift. SELECT can become complex while creating …

Redshift Select Read More »

Redshift

Should you use PARQUET files with Redshift Copy ?

Amazon Redshift supports loading columnar file formats like PARQUET, ORC. This extends compatibility and possibility of moving data easily from different environments for your data lake or data warehouse. Parquet primarily is a very popular file format on Hadoop and is first preference of Big Data experts. Now you can load parquet files in Amazon …

Should you use PARQUET files with Redshift Copy ? Read More »