In this section, we will discuss data definition language parts of HIVE Query Language(HQL), which are used for creating, altering and dropping databases, tables, views, functions, and indexes. We will also look into SHOW and DESCRIBE commands for listing and …
In the below post we are going to understand about HIVE Partition and Concepts of HIVE partitioning in detail. Partitions are essentially horizontal slices of data that divides the larger set of data into small manageable chunks. In HIVE, partitioning …
HIVE UDF (User Defined Functions) allow the user to extend HIVE Query Language. Once the UDF is added in the HIVE script, it works like a normal built-in function. To check which all UDFs are loaded in current hive session, …
Unlike partitioning, HIVE bucketing is another way to decompose data into more manageable sets. Consider our requirement is to create the partition based on date and then on user ID’s. In this case, there will be more numbers of small …
It is important to note that HiveQL data manipulation doesn’t offer any row-level insert, update or delete operation. Therefore, data can be inserted into hive tables using either “bulk” load operations or writing the files into correct directories by other …