Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Impala ODBC Connector Multiple Result Sets

Impala ODBC Connector Multiple Result Sets

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.

2 REPLIES 2

Re: Impala ODBC Connector Multiple Result Sets

New Contributor

Hi, have you got any response on this issue? I'm also connectioning Impala in .NET and trying to execute mutiple queries together and got syntax error.

 

Thanks in advance.

Highlighted

Re: Impala ODBC Connector Multiple Result Sets

Cloudera Employee

Impala does not support multi-statement commands.  Hue works by parsing these on the client side and sending two SQL commands.