I am using an ODBC connection to connect to hive environment using the hortonworks hive odbc driver that was installed. I have ran a test and able to connect to the environment without issues. The problem I'm having is when I attempt to run a pass-through query joining two tables, I receive an error message
"finished with operation state: ERROR_STATE".
I can run a pass-through query on a single table without issue its just when I perform a join on another table is when the issue appears. Is it something to do with my configuration ODBC Administrator or is it something to do with Microsoft Access itself? Thanks in advance.