How to configure the Push Down Engine for Non Cube Queries.

Prerequisites in Hive

Please ensure that the below settings enabled in hive.

set hive.cbo.enable=true;

set hive.vectorized.execution.enabled = true;

set hive.vectorized.execution.reduce.enabled = true;

set hive.compute.query.using.stats=true;

set hive.stats.fetch.column.stats=true;

set hive.stats.fetch.partition.stats=true;

Steps to Configure Push Down Engine in Infoworks

1. Login into infoworks Edge node as Infoworks User

2. Navigate to $IW_HOME/bin

3. source

4. /   [ Make sure that cube-engine is running ]

5. Login to Infoworks UI as Admin

6. Navigate to admin -> configurations -> cube tab

7. select Hive as the engine from drop down menu 

8. Provide the Exact JDBC URL

9. Save the settings

10. Login to Infoworks Edge node as Infoworks User

11. Navigate to $IW_HOME/bin

12. source

13. restart the hangman . [ ./ hangman && ./ hangman]

14. Check ./ to validate all the services are up and running.

Above steps will enable the Push down Engine in Hive from Infoworks.