In this post, we will see how we can connect to Teradata using the JDBC connection in Java using the credentials and copy the contents of the table to a CSV file. JDBC stands for Java Database Connector which is nothing but a set of libraries that will have supported functions to communicate with Teradata… Read More »
What is HDFS? This is the common question that everyone will encounter when they start learning about Hadoop. HDFS deals with the way data is stored and managed by Hadoop Framework. What is a Distributed File System? A distributed file system deals with managing data(files and folder) across multiple nodes or computers. It serves the… Read More »
While reading this article, Hadoop has already reached 3.0 version. However, it is important to know the history and how it evolved in the past. This will help people who are working in the migration projects from Hadoop 1.0 to Hadoop 2.0. It will also help the developers to understand and consider future use cases… Read More »
What is BigData? It is the question that will arise in the minds when someone wants to learn Hadoop and other distributed processing tools. There is no end to learn about any technology as technology is growing along with you each day. Companies like Facebook, Twitter, Google are already generating Petabytes of data every day.… Read More »
Microsoft SQL Server provides a nice feature of creating a table on the fly along with the data from another table using “Select into” statement. Syntax columns – Columns to be retrieved from the existing table. newTableName – Name of the new table to be created. existingTableName – Source table with data. conditions – Conditions… Read More »
In Microsoft SQL Server, there are different ways in which we can create the table. The table can be created with or without constraints. Basic Syntax for creating a table is, databaseName – Name of the DB where the table will be created tableName – Name of the table. columnName – Name of the column… Read More »
There are different types of statements that can be executed in SQL Server for different purposes. These are basically categorized into four types DDL – Data Definition Language DML – Data Manipulation Language DCL – Data Control Language TCL – Transaction Control Language DDL(Data Definition Language) The name itself suggests that it defines the structure… Read More »
BTEQ stands for Batch Teradata Query. It is one of the utilities in Teradata to perform DDL and DML queries, creating macros, etc. However, the BTEQ export feature is exclusively for exporting the result of a query to a file. BTEQ modes There are two modes of running BTEQ. They are interactive mode and Batch… Read More »
While there are many encryption and decryption algorithms available, AES is one of the robust and reliable modes of encrypting the data. The implementation can be done in many languages as there are libraries and packages available for multiple languages. Creating the AES encryption/decryption library We do not need any special library to be downloaded… Read More »
AES stands for Advanced Encryption Standard. AES is the first and only publicly accessible cipher approved by the National Security Agency(NSA). There is multiple AES package available in python. In this post, we will see the implementation with two different packages in python Method1 – “crypto” package Method2 – “cryptography” package Using the “Crypto” AES package In this… Read More »