Locks are used to support concurrency when many programs want to access the same table at the same time. It protects data from being corrupted
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.
Get IP Address of Hadoop & Hive
This article will show you how to get the IP address of a Hadoop server or a Hadoop NameNode. If you are using Cloudera Quickstart
Apache Hive Temporary Tables
A temporary table in Apache Hive, as the name indicates, is a table that works like a regular table but exists only temporarily in Hive’s
Replace Function in Apache Pig
The purpose of the ‘REPLACE’ function is that it returns the initial argument with all occurrences of the target string replaced by the replacement string.
Trimming Functions in Apache Pig
Trimming functions help to remove spaces from a given string. These functions are often used in data cleansing operations during the ETL cycle. This article
Substring Function in Apache Pig
String functions are used to perform an operation on an input string and return the result. Almost major RDBMS systems and big data technologies, such
Big Data & SQL 