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; ...

The TBLPROPERTIES clause enables you to use your own metadata key/value pairs to tag the table definition. There are also several predefined...

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 please...

The purpose of this article is to address the different file formats and compression codecs in Apache Hive that are available for different ...

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 ...

This article will explore some Hadoop basic commands that help in our day-to-day activities. Hadoop file system shell commands are organized...

HDFS is a distributed file system designed to run on top of the local file system. Many times we may need to copy files from different sourc...

The purpose of this article is to let you know about few HDFS commands that are identical  in behavior but distinct. CopyFromLocal and Put: ...

The NVL() function enables you to substitute null for a more relevant alternative in the query results. This function accepts two arguments....

This  article  offers  a  summary  of  the  situations  in  which  you  would  need  to  create  internal (managed)  tables  and  external  ...