We often need the email facility in the shell script as most of the batch jobs in production are running in Linux based machines only. In case of issues, the jobs or scheduler needs to send failure notifications to the support DL. At times we may need the failure log as an attachment in the… Read More »
We can delete the first line in a file using ‘sed’ command in the shell script. Let us see with the help of a test file called ‘sample.txt’. Here are the contents of the text file. Option 1: Delete and save in a new file In this option, a new file will be created with… Read More »
Basic TEradata Query utility is one of the advantages of Teradata over other extraction utilities. The advantage of the 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… Read More »
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 »
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. In this post, we will see how we can create a table using select in Teradata. There are different ways in which we… Read More »
There are different ways to create tables in Teradata. We can also define the tables so that they will allow or not allow 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 options By default, if… Read More »
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? What language does hive use? History of Hive Is hive a database? What is hive metastore? What are hive properties? Sample hive-site.xml file Hive architecture… Read More »
In the other article, we saw the usage of Table variables. In this article, we will see how to transform column values in a table to a comma-separated string. Let’s create a table variable “Teams” with the columns ‘ID’ and ‘Team’ (use the below script). When you fire a SELECT over the above table, it… Read More »
Table variables in SQL Server are variables that store a set of records in a table like structure for a particular period of time. It is another way of storing data temporarily similar to temporary tables. In this article, we will see what is table variable with an example. Generally, the name of the table… Read More »
A temporary table in SQL Server is a table that exists temporarily on the database server for a certain period of time. Temporary tables are basically stored inside the “tempdb”, which is a system database. Temporary tables are useful to work with a small subset of records in a table that contains a large number… Read More »