Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Impala ODBC Connector Multiple Result Sets

avatar
New Contributor

Hello,

 

I am kind of new to Impala and have a question about the Impala ODBC connector.  Does it support multiple result sets?  If so, what settings are needed to make this happen?  For example if I send this script through the connector:  Select 'A'; Select 'B'.  Can I get the 2 result sets? Through the HUE Impala Query Editor this works and give me the "Next" button to see the next results.  I am using Impala ODBC connector through the .NET ODBC Provider and it works fine on single result sets. Its the multiple ones that give SQL syntax errors.  Again, the exact same SQL scripts work in HUE so I am wondering if its a limitation of the ODBC connector.  

 

Thanks in advance.

Who agreed with this topic