The below command helps in creating a table in Hive based on the MySQL table’s definition. sqoop create-hive-table –connect=jdbc:mysql://localhost/retail_db –username=root –password=cloudera –table employees –hive-table emp;
Category: Apache Hive
COMPLETE DDL Commands in Hive
This article is to cover all the DDL commands in Hive. “CREATE” DATABASE LEVEL: To create the database with properties CREATE DATABASE TestDB WITH dbProperties(‘Creator:
Usage of ALTER in Hadoop Hive
Alter is a DDL command which helps in modifying the structure of the database objects. We can change the user provided properties of the database,
Hive Analytical Functions
The below is the compiled list of aggregate, analytical & advanced functions in Apache Hive. Some of them are widely used ones which we will
Concatenate rows (group concatenation) in MySQL, Hive, SQL Server and Oracle
The CONCAT() function joins the input strings or different column values and returns as a single string. However, if we need to concatenate rows of
DISTINCT vs APPROXIMATE DISTINCT
As all (or most) of us know, SELECT DISTINCT eliminates duplicate records from the results and returns only unique values. But it’s very expensive in
Big Data & SQL 