Forum Discussion

tonmcg's avatar
tonmcg
Icon for Resolver II rankResolver II
8 years ago

Using the Tez Engine on an ODBC Connection to Hive

I currently use Power BI Desktop to connect to Apache Hive through a HortonWorks Hive ODBC connection. I pass SQL-like statements to Hive in Power BI to process the statements on the server and then ...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

It can be done on the DSN config....go to advanced in your ODBC config...Server Side Properties...Add...put in hive.execution.engine as the key and tez as the value...OK...OK...OK.  Worked for me...took an hour long query down to 12 minutes.  Not perfect but way more palatable.