In this article, you will learn how to list out the properties of a database or a table in Hive. DATABASE LEVEL: DESCRIBE DATABASE db_name;DESCRIBE
Category: Apache Hive
Hive Table Properties
The TBLPROPERTIES clause enables you to use your own metadata key/value pairs to tag the table definition. There are also several predefined table properties, such
Word Count in HiveQL – Explode and Split Usage
This article aims to explain the usage of the SPLIT function in HiveQL. If you are looking for a similar function in SQL Server, then
File formats and compression in Apache Hive
The purpose of this article is to address the different file formats and compression codecs in Apache Hive that are available for different data sets.
Commonly used Apache Hive non-SQL Statements
Commands are non-SQL statements such as setting a property or adding a resource. They can be used in HiveQL scripts or directly in the CLI or Beeline. The
An alternative to ISNULL() and NVL() functions in Hive
The NVL() function enables you to substitute null for a more relevant alternative in the query results. This function accepts two arguments. If the first
Big Data & SQL 