Configuring the AEL daemon for the Hive Warehouse Connector on your Hortonworks cluster

You can use PDI with the Hive Warehouse Connector (HWC) to access Hive managed tables in an ORC format or large unmanaged tables in Hive on secure supported HDP clusters. You can set the access controls and the LLAP queue by configuring the application.properties file of the AEL daemon.

Note: As a best practice, enable LLAP on HDP and follow the instructions outlined in Apache Hive Performance Tuning.