Apache Hive is a data warehouse software which is built on top of Apache Hadoop to process structured data, summarize big data, to query and to analyze it.
Sprinkle Data integrates with Apache Hive’s warehouse which provides SQL-esque language for querying called HQL(Hive Query Language)
It is specifically designed for online analytical processing, And it stores schema in a database and processes data into Hadoop Distributed File System.
Let’s dive deep on the configuration part of Apache Hive data warehouse in Sprinkle?
Admin -> Drivers
The drivers tab routes the user to Storage, Warehouse and Compute tabs.
Create new warehouse -> Apache Hive
On clicking the Create new warehouse, the screen displays a number of data warehousing options, Apache Hive is selected in this case.
Unique credentials need to be filled to carry out the process of creating a new data warehouse.