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;
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
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
Oracle Analytical Functions
The below is the compiled list of analytical & advanced functions in Oracle SQL*Plus. Some of them are widely used ones which we will be
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
Big Data & SQL 