Most of the data-sets (CSV files, Text files, and so forth.) do have header row inside the data, and loading them in the Hive tables
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.
Hive Internal Table – With External Data
Have you ever wonder what will happen if you miss the “external” keyword while creating an external table? It will be an internal table at
Regular Expressions – RLIKE in Hive
Either SQL Developers or Data Analysts often use arithmetic operators in their queries such as =, >, <, != Apart from this, LIKE, EXISTS, IN,
“Target-Dir” vs “Warehouse-Dir” in Sqoop
This article is about using “Target-Directory” and “Warehouse-Directory” while Sqoop Import. Please refer to the below codes. Code-1: Usage of “Target-Directory” sqoop import –connect jdbc:mysql://localhost/empinfo
"Target-Dir" vs "Warehouse-Dir" in Sqoop
This article is about using “Target-Directory” and “Warehouse-Directory” while Sqoop Import. Please refer to the below codes. Code-1: Usage of “Target-Directory” sqoop import –connect jdbc:mysql://localhost/empinfo
Sqoop Import All – Copying MySQL Database to Hive
At the point when I began learning Sqoop, I confronted such huge numbers of blunders for which I was unable to get a lot of
Big Data & SQL 