Post 52 | HDPCD | The conclusion

Hi everyone. Finally, we have reached the end of this tutorial series. It’s been so long. We started this journey together on January 15th, 2017, and, 276 days later this beautiful journey is coming to an end. But, we do not need to worry, because, I am working on something new and would love toContinue reading “Post 52 | HDPCD | The conclusion”

Post 49 | HDPCD | Using a subquery within a Hive query

Hello, everyone. Welcome to one more tutorial in the HDPCD certification series. In the last tutorial, we saw how to enable vectorization in Hive. In this tutorial, we are going to see how to run a subquery within a Hive query. Let us begin, then. As you can see from the above screenshot, the process of performingContinue reading “Post 49 | HDPCD | Using a subquery within a Hive query”

Post 48 | HDPCD | Printing the execution plan of a Hive query

Hello, everyone. Welcome to one more tutorial in the HDPCD certification series. In the last tutorial, we saw how to enable vectorization in Hive. In this tutorial, we are going to see how to print the execution plan of a Hive query. Let us begin, then. This is one of the simplest tutorials in this certification series. InContinue reading “Post 48 | HDPCD | Printing the execution plan of a Hive query”

Post 33 | HDPCD | Define a Table from a SELECT Query

Hello everyone and welcome to one more tutorial in the HDPCD certification series. In the last tutorial, we saw how to define a BUCKETED hive table. In this tutorial, we are going to see how to create a Hive table from a SELECT query. Let us begin then. We are going to follow the belowContinue reading “Post 33 | HDPCD | Define a Table from a SELECT Query”

Post 30 | HDPCD | Define a Hive External Table

Hello, everyone! Welcome to the third tutorial in the Data Analysis section of the HDPCD certification. In the last tutorial, we saw how to create the hive-managed or internal table. In this tutorial, we are going to create the hive external table. So, let us start with the process. The following infographics show the processContinue reading “Post 30 | HDPCD | Define a Hive External Table”

Prerequisites for Hadoop – Part 2

Hello all, welcome to the part 2 of Prerequisites for Hadoop. In this post, we are going to look over the SQL part required in order to start Hadoop. We are going to use MySQL Database Server to demonstrate basic SQL queries. We are going to go through following parts in SQL. MySQL Installation onContinue reading “Prerequisites for Hadoop – Part 2”

Prerequisites for Hadoop – Part 1

Hello everyone, welcome back to another post related to Hadoop Ecosystem. Lot of people have approached me regarding the prerequisites required before learning Hadoop, so this is for those poeple who are beginners and want to learn Hadoop Ecosystem. I consider following three components as the prerequisites for learning Hadoop. Linux File System and CommandsContinue reading “Prerequisites for Hadoop – Part 1”

MYSQL DATABASE CONNECTION THROUGH JAVA

MySQL can be connected with the help of JAVA programming language. For this we require a driver which will enable us to create a connection to connect to MySQL database. A connection object is created with the help of getConnection() method of DriverManager class. The standard syntax of this getConncetion() method contains one, two andContinue reading “MYSQL DATABASE CONNECTION THROUGH JAVA”