Usage of subqueries in Apache Hive queries   In this article we will learn how and where to use subqueries in Apache Hive. Sub-queries in Hive queries are allowed in from clause ad where clause. The following steps explain you in detail about subqueries in Hive. 1) Create a department table as explained in this article. 2) In From clause. The following query uses subquery in from clause.select namenewsalary from (select namesalary1.1 as newsalary from employee) emp_new;  Subquery columns can…

In this article, we will learn how and where to use subqueries in Apache Hive. Sub-queries in Hive queries are allowed in from clause ad wh.

Working with databases in Apache Hive    In this article We will learn how to work on databases in Apache Hive. We will learn how to create drop change and use database in Apache Hive.1) Check existing databases. We check existing databases in Hive using show databases command. Apache Hive comes with a database called default. Command : show databases;  2) Creating a new database; We can create a new database in Apache Hive using create command. Command syntax: create database [if not exist]…

In this article We will learn how to work on databases in Apache Hive. We will learn how to create, drop, change and use database in Apache.

Checking versions of Hadoop eco system tools   We need to know versions of hadoop technologies while we are trouble shooting any Hadoop issues. This article talks how to check versions of Hadoop ecosystem technologies.1) Hadoop version Hadoop version can be found using below command. hadoop version  2) Hive version Hive version can be found using below command. hive version   3) Pig version Pig version can be found using below command. pig version  4) Sqoop version Sqoop version can be found…

Checking versions of Hadoop eco system tools

Apache Hive vs Apache Pig

Difference between Apache Hive and Apache Pig

Step by step guide for execution engines usage in Apache Hive.   In this article We will learn how to use different execution engines in Apache Hive. 1) Create a table called employee to run next queries. You can check how to create a table in Hive here. 2) Check available execution engine in hive-site.xml. grep -C2 -i execution.engine /etc/hive/conf/hive-site.xml Execution engine defined in hive-site.xml is the default execution engine.The image below shows tez is the execution engine…

In this article, We will learn how to use different execution engines in Apache Hive. Create a table called employee to run next que.

the-stinger-initiative-making-apache-hive-100-times-faster by Yahoo! Developer Network via Slideshare

April 2013 HUG: The Stinger Initiative - Making Apache Hive 100 Times…

Using where clause in Apache Hive query   In this article We will learn where clause in Apache Hive. Where clause is used to filter the column data that satisfies given condition.We will learn how to use where clause in different ways in the following steps. 1) Create table called employee in Apache Hiveusing this article. 2) Check the data in Hive table employee. Select  from employee;  3) Where clause in Hive supports many operators.  The query below uses equal operator and filters the…

In this article, We will learn where clause in Apache Hive. Where clause is used to filter the column data that satisfies given condition.

How to hire a big data engineer, with Qubole co-founder, Joydeep Sen Sarma (also one half of the team behind Apache Hive)

What is NASA Doing with Big Data? Check this Out - High Scalability -

Benchmarking Apache Hive 13 for Enterprise Hadoop - Hortonworks

Benchmarking for Apache Hive 13 based on TPC Benchmark™ DS (TPC-DS) and then modeled our bench test bed after a real-world Hadoop cluster configuration.

Pinterest
Search