Most individuals erroneously believe that DML statements are not supported by Hive. This is a result of the out-of-date information on the internet. DML commands
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.
UPDATE and DELETE in SQL Server
This article is meant for people who are just learning SQL. DML commands typically touch the database through apps; users don’t sit down and manually
mysqldump – Dump only specific rows
It is possible to dump a specific table and specific rows from a table using mysqldump. This article explains how to do that. The mysqldump
MySQL – Single Transaction or Skip Lock Tables
When using mysqldump to backup databases, many people are unsure whether to use the –skip-lock-tables or –single-transaction options to prevent locking the tables. This article
MySQL Status through mysqldump
You can easily run the following line at command prompt to retrieve the MySQL server uptime statistics along with the number of connected threads, the
Corelated Sub-Queries
A correlated subquery is one that makes use of values from the outer query. Because of this dependency, a correlated subquery cannot be executed as
Big Data & SQL 