Apache Hive is a data warehouse software project built over Apache Hadoop to providing data summarization, query, and analysis. Hive gives an SQL-like interface to query data stored in various databases and file systems that integrate with Hadoop. In Strategy, it is one of a wide range of connections that allows business users to connect to, prepare, and visualize information from various Big Data environments.
Using Hive’s Batch SQL, Strategy connects to leading sources so businesses can perform large-scale, batch-style, and ETL-like transformations on data, while supporting automatic fail-over. With dynamic sourcing and push-down functionality, Strategy is able to use batch processes to deliver faster response times with the most current drivers to access HDFS.
From the security point of view, The Strategy platform supports LDAP or Kerberos authentication for users to connect to Cloudera, Hortonworks, or MapR distributions of Hive.
