Hive Delete and Update Records Using ACID Transactions

Post author:Prabha
Post category:Apache Hive Big Data Hadoop

Since Hive Version 0.14, Hive supports ACID transactions like delete and update records/rows on Table with similar syntax as traditional SQL queries. You need to enable Hive ACID support and create a transactional table. On a table with transactional property, hive supports ACID transactions like Update and Delete operations. You…

Hive – Create Database Examples

Post author:Prabha
Post category:Apache Hive Big Data Hadoop

Using CREATE DATABASE statement you can create a new Database in Hive, like any other RDBMS Databases, the Hive database is a namespace to store the tables. In this article, I will explain how to create a database, its syntax, and usage with examples in hive shell, Java and Scala…