CREATE TABLE using SELECT in Teradata

In the other post, we saw how to create tables in Teradata and the corresponding examples for each. Here we will see how to create a table with select from another table. Let us see the basic syntax of the same. Create table without data and index Syntax In the above example, please note the… Read More »

CREATE TABLE in Teradata with examples

There are different ways to create tables in Teradata. We can also define the tables in such a way that it will allow or not allow the duplicates. We can also create tables with data from another table on the fly. Create table – Default We can create a table in Teradata with the default… Read More »

Difference between ISNULL and COALESCE in SQL

In this article, we will see the difference between ISNULL and COALESCE in SQL Server. Both ISNULL and COALESCE evaluates the expression for NULL and returns a non-null value. ISNULL The ISNULL function replaces NULL with a specified value. ISNULL ( check_expression, replacement_value ) It contains two parameters. The first parameter is to evaluate the… Read More »

Apache Hive architecture

One cannot avoid hearing the word “Hive” when it comes to the distributed processing system. In this article, we will see the hive architecture and its components What is Hive? Apache Hive is nothing but a data warehouse tool for querying and processing large datasets stored in HDFS. It uses the MapReduce processing mechanism for… Read More »