In Apache Hive, there are hundreds of built-in functions, such as aggregate, statistical, date-time, string, type conversion, conditional, table creation, windowing, and more functions that
Category: Apache Hive
Import and Export Partitioned Data in Hive
Developers and analysts can take use of Apache Hive’s numerous built-in capabilities without putting in a lot of effort, and they won’t have to rely
Import and Export Commands in Hive
Earlier blogs described several methods for importing data or inserting data into Hive tables. Similarly, I described how to export data from Hive to HDFS,
Indexes in Apache Hive
The aim of indexing in Hive is the same as it is in any RDBMS: to improve query performance by enhancing the speed of query
ACID Properties and DML Operations in Hive
Despite the fact that Apache Hive is not meant for OLTP, it does allow DML operations, but not in the same manner that SQL does.
Inserting Values Into Tables – HIveQL
Since Hive is a data warehouse and not designed for OLTP operations like SQL, data must be ingested from a variety of sources. It might
Big Data & SQL 