Post 41 | HDPCD | Loading compressed data into a Hive table

Hello, everyone. Thanks for returning for the next tutorial in the HDPCD certification series. In the last tutorial, we saw how to load data into a Hive table from a SELECT query. In this tutorial, we are going to see how to load the compressed data from into the Hive table. Let us begin then. The above … Continue reading Post 41 | HDPCD | Loading compressed data into a Hive table

Post 40 | HDPCD | Load data into hive table as a result of a query

Hi, everyone. Thanks for coming back for one more tutorial in this HDPCD certification series. In the last tutorial, we saw how to load data into a Hive table from an HDFS directory. In this tutorial, we are going to see how to load the data into a Hive table as a result of a Hive query. … Continue reading Post 40 | HDPCD | Load data into hive table as a result of a query

Post 39 | HDPCD | Load data into a Hive table from an HDFS directory

Hello, everyone. Thanks for returning for the next tutorial in the HDPCD certification series. In the last tutorial, we saw how to load data into a Hive table from a local directory. In this tutorial, we are going to see how to load the data from the local Directory into the Hive table. Let us begin then. … Continue reading Post 39 | HDPCD | Load data into a Hive table from an HDFS directory

Post 37 | HDPCD | Specifying delimiter of a Hive table

Hello, everyone. Thanks for coming back for one more tutorial in this HDPCD certification series. In the last tutorial, we saw how to specify the storage format of a Hive table. In this tutorial, we are going to see how to specify the delimiter of a Hive table. We are going to follow the process … Continue reading Post 37 | HDPCD | Specifying delimiter of a Hive table

Post 35 | HDPCD | Insert records from NON-ORC table into ORC table

Hello, everyone. Thanks for going through the tutorials. The increasing views and visitors act as a motivation for me. In the last tutorial, we saw how to define a hive ORC table. In this tutorial, we are going to load data in that ORC table from an NON-ORC table. For doing this, we are going … Continue reading Post 35 | HDPCD | Insert records from NON-ORC table into ORC table

Post 34 | HDPCD | Defining Hive Table using an ORC File Format

Hi, everyone. Thanks for joining me today for this tutorial. In the last tutorial, we saw how to create a hive table using the SELECT query. In this tutorial, we are going to see how to create a hive table which stores the data in the ORC File Format. The process of creating this table … Continue reading Post 34 | HDPCD | Defining Hive Table using an ORC File Format

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

Hive 1.1.1 Installation on single node hadoop 2.6.0 on ubuntu 14.04

sudo su hduser cd sudo wget http://mirror.tcpdiag.net/apache/hive/hive-1.1.1/apache-hive-1.1.1-bin.tar.gz sudo cp apache-hive-1.1.1-bin.tar.gz /usr/local/ cd /usr/local/ sudo tar -xvf apache-hive-1.1.1-bin.tar.gz sudo mv apache-hive-1.1.1-bin hive sudo chown hduser:hadoop -R hive cd sudo nano ~/.bashrc #HIVE VARIABLES START export HIVE_HOME=/usr/local/hive export PATH=$PATH:$HIVE_HOME/bin #HIVE VARIABLES END ctrl+x Y <enter> source ~/.bashrc hive if you get some error related to found class … Continue reading Hive 1.1.1 Installation on single node hadoop 2.6.0 on ubuntu 14.04