Author Archives: emanator

IF ELSE in Teradata BTEQ

BTEQ utility is one of the advantages of Teradata over other extraction utilities. The advantage of BTEQ utility is its error handling ability and conditional execution. It is more common that the query execution is often compared against the conditional flow in programming languages and programmers may end up choosing JDBC connection to have control… Read More »

Error handling with ACTIVITYCOUNT and ERRORCODE in BTEQ

Batch Teradata Query(BTEQ) is a powerful utility in Teradata with multiple options. You can export/import tables and files and make use of them in the same sessions for checking conditions to take decisions. Based on the checks, you can perform your DDL, DML operations. In this post, we will use a very simple use case… Read More »

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 »

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 »

MySQL Installation steps

In this article, we will see how to install MySql in the Ubuntu machine. MySql can be installed in linux based machines through the terminal window Execute the command “sudo apt-get install mysql-server mysql-client” from the terminal. The below-given picture is for reference. You will be asked to enter the machine password here. Give the… Read More »

PIG Installation steps

In this previous article, we saw how to install Apache Hive in the Ubuntu machine. Both of these articles are written with an assumption that you have already installed the Hadoop framework in the machine. If not, please visit this post and install the Hadoop framework first. Pig is another component of the Hadoop ecosystem… Read More »