Tutorials
Courses

Similar Topics

Web Technologies32.1K+ articles

DSA19.9K+ articles

Linux-Unix2.4K+ articles

Software Engineering2.3K+ articles

DBMS1.3K+ articles

Data Analysis295+ articles

Data Engineering143+ articles

BigData55+ articles

Hadoop30+ articles

Apache Pig6+ articles

Apache-Hive

12 posts

Apache Hive - Getting Started With HQL Database Creation And Drop Database

Last Updated: 21 September 2021

Pre-requisite: Hive 3.1.2 Installation, Hadoop 3.1.2 InstallationHiveQL or HQL is a Hive query language that we used to process or query structured data on Hive. HQL synta...read more

article_image

Apache HIVE - Database Options

Last Updated: 04 November 2020

Apache hive is a data-warehousing tool built on top of Hadoop. The structured data can be handled with the Hive query language. In this article, we are going to see option...read more

article_image

Hive - Alter Database

Last Updated: 24 November 2020

Apache Hive comes with an already created database with the name default. The default database can not be altered in the Hive because it is restricted. For every successfu...read more

article_image

How to Create Table in Hive?

Last Updated: 04 November 2020

In Apache Hive we can create tables to store structured data so that later on we can process it. The table in the hive is consists of multiple columns and records. The tab...read more

article_image

Data Engineering

Hive - Drop Table

Last Updated: 04 November 2020

Apache hive is a data warehousing tool that we use to manage our structure data on Hadoop. The tables in the hive are used for storing data in tabular format(structured). ...read more

article_image

Data Engineering

Hive - Load Data Into Table

Last Updated: 24 November 2020

Hive tables provide us the schema to store data in various formats (like CSV). Hive provides multiple ways to add data to the tables. We can use DML(Data Manipulation Lang...read more

article_image

Data Engineering

Hive - Alter Table

Last Updated: 24 November 2020

Hive provides us the functionality to perform Alteration on the Tables and Databases. ALTER TABLE command can be used to perform alterations on the tables. We can modify m...read more

article_image

Creating Database Table Using Hive Query Language (HQL)

Last Updated: 03 January 2021

Hive is a data warehouse solution built on top of Hadoop. In Hive data is managed at Hadoop Distributed file system (HDFS). In this schema, on reading no constraint check ...read more

article_image

Database Operations in HIVE Using CLOUDERA - VMWARE Work Station

Last Updated: 17 January 2021

We are going to create a database and create a table in our database. And will cover Database operations in HIVE Using CLOUDERA - VMWARE Work Station. Let's discuss one by...read more

Hive - One Shot Commands

Last Updated: 22 January 2021

Hive comes with various "One Shot" commands that a user can use through Hive CLI(Command Line Interface) without entering the Hive shell to execute one or more than one qu...read more

article_image

Software Engineering

Proof of Concept on News Aggregator using Big Data Technologies

Last Updated: 02 February 2021

Big Data is a huge dataset that can have a high volume of data, velocity, and variety of data. For example, billions of users searching on Google at the same time and that...read more

article_image

Apache Hive - Static Partitioning With Examples

Last Updated: 04 July 2021

Partitioning in Apache Hive is very much needed to improve performance while scanning the Hive tables. It allows a user working on the hive to query a small or desired por...read more

article_image