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 to … Continue 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 performing … Continue 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. In … Continue 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 below … Continue 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 process … Continue 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 on … Continue 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 Commands … Continue 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 and … Continue reading MYSQL DATABASE CONNECTION THROUGH JAVA