Performance tuning is the process of ensuring that an application’s SQL queries execute as quickly as feasible. The procedures may or may not differ from
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.
Reading and Sampling Data From HDFS
Shell commands on the Hadoop file system are organized similarly to those in Unix/Linux systems. It’s simple to use Hadoop shell commands if you’re familiar
MERGE in Apache Hive
The MERGE command synchronizes two tables by adding, removing, and modifying target table rows based on the source table’s join condition. In other words, when
Locking In Apache Hive
In most RDBMSs, locking is an important element of the isolation requirement, and it helps to lock the objects affected by a transaction. The SQL
List, Detail, Describe and Call Functions in Hive
In Apache Hive, there are hundreds of built-in functions, such as aggregate, statistical, date-time, string, type conversion, conditional, table creation, windowing, and more functions that
Sqoop Complete Tutorial Part-13
This is continuation part to “SQOOP Complete Tutorial” and in this part we will see how to create and save the jobs in Sqoop. Instead
Big Data & SQL 