HADOOP… Complex Data Types in Hive 19 Jan 2020 What are Complex Data Types in Hive? Complex Data types are also known as nested types which allow storing multiple values within a single row/column position in a Hive table.…
hive… Sqoop to Hive Table 8 Jul 2019 What is Sqoop Import? Sqoop is a tool from Apache using which bulk data can be imported or exported from a database like MySQL or Oracle into HDFS. Now, we…
HADOOP… HIVE Scripting 27 Jun 2019 In this blog, we will learn how to execute Script File in Hive. Hive is a critical component of HADOOP,and your expertise in Hive can land you top-paying jobs! Three…
HADOOP… HIVE-Use Case 5 Apr 2018 Practice Query Creation This blog of Big Data will be a good practice for Hive Beginners, for practicing query creation. At the end, you will be able to create a table, load data…
HADOOP… Loading and Storing Hive Data into Pig 5 Apr 2018 In this tutorial, we will be giving a demo on how to load Hive data into Pig using HCatLoader and how to store the data in Pig into Hive. To…
HADOOP… Join Optimization in Apache Hive 30 Nov 2017 Hive, like other SQL databases, allows users to join various tables. However, Join can be computationally expensive, especially on big tables. Hive on top of Hadoop makes data processing so straightforward and…
HADOOP… Hadoop Tutorial : Joins in Hive 30 Nov 201730 Nov 2017 In this Hadoop tutorial post, we will understand various types of JOIN operation that Hive supports. Hive, like alternative SQL database, permits users to join various tables. However, hive doesn’t…
HADOOP… Top 15 Hive Interview Questions 22 Sep 2017 Top 15 Hive Interview Questions 1.What is Hive? Hive is a data warehousing tool. It is an abstraction and it gives SQL queries to perform an analysis. It gives you…
hive Transactions in Hive 7 Jul 2017 In this blog post, we have explained about the row-level transactions available in Hive. This post will provide you a good idea of how to implement the row-level transactions on…
hive Bucketing in Hive 7 Jul 2017 In our previous post, we have discussed on the concept of Partitioning in Hive. In this post, we will be discussing the concept of Bucketing in Hive, which gives a…