we are using powerbi with hortonworks odbc driver to connect to hive in cluster ambari 22.214.171.124, hdp 2.6.5
the connection is made successfully, but when making a query on a table that has 23 thousand rows, it returns the following error below:
Erro do OLE DB ou do ODBC : [DataSource.Error] ERROR [HY000] [Hortonworks][Hardy] (35) Error from server: error code: '0' error message: 'Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=0345789f-6c9a-4990-adf5-f823232338]'..
if we make a query putting a limiter of at most 10,000 thousand lines in the select, the result is ok
what could be causing this problem?
PS: there are queries in powerbi with the same ODBC in other tables that have more than 200 thousand rows and the result is OK too