Apache Presto – HIVE Connector
The Hive connector allows querying data stored in a Hive data warehouse. Prerequisites HadoopHive Hopefully you have installed Hadoop and Hive on your machine. Start all the services one by…
Hive..
HiveQL – Select-Joins
JOIN is a clause that is used for combining specific fields from two tables by using values common to each one. It is used to combine records from two or…
HiveQL – Select-Group By
In this section we will explains the details of GROUP BY clause in a SELECT statement. The GROUP BY clause is used to group all the records in a result…
HiveQL – Select-Order By
In this section we will explains how to use the ORDER BY clause in a SELECT statement. The ORDER BY clause is used to retrieve the details based on one…
HiveQL – Select-Where
The Hive Query Language (HiveQL) is a query language for Hive to process and analyze structured data in a Metastore. This chapter explains how to use the SELECT statement with…
Hive – View and Indexes
In this section we will describes how to create and manage views. Views are generated based on user requirements. You can save any result set data as a view. The…
Hive – Built-in Functions
In this section we will explains the built-in functions available in Hive. The functions look quite similar to SQL functions, except for their usage. Built-In Functions Hive supports the following…
Hive – Built-in Operators
In this section we will explains the built-in operators of Hive. There are four types of operators in Hive: Relational OperatorsArithmetic OperatorsLogical OperatorsComplex Operators Relational Operators These operators are used…
Hive – Partitioning
Hive organizes tables into partitions. It is a way of dividing a table into related parts based on the values of partitioned columns such as date, city, and department. Using…
Hive – Drop Table
In this section we describes how to drop a table in Hive. When you drop a table from Hive Metastore, it removes the table/column data and their metadata. It can…