Support Questions

Find answers, ask questions, and share your expertise

Problem with Impala ODBC Parameter Values and Prepared Statements

avatar
New Contributor

Hi, I'm trying to connect via unixODBC and Cloudera Impala driver.
I managed to retrieve data with some simple queries. 

As soon I use prepared statements, seems Impala driver can not handle it. 

 

 

Jun 22 22:23:38.596 ERROR 749795712 Simba::ODBC::ClassicQueryExecutor::Execute: [Cloudera][ODBC] (10920) No data can be obtained from an input parameter whose value has already been pushed down.
Jun 22 22:23:38.601 ERROR 749795712 Simba::ODBC::StatementState10::SQLParamData: [Cloudera][ODBC] (10920) No data can be obtained from an input parameter whose value has already been pushed down.

My code is a simple snippet for now for testing, I could track the parameter inunixODBC side, seems Impala driver can not map them somehow.

 
I appreciate any help on this. 




1 REPLY 1

avatar
Community Manager

Welcome to the community @samans 

I'm not an expert but I did some searching and may have found something for you. I would review the Cloudera ODBC Connector for Apache Impala documentation as I see some references to transaction statements not being supported and how to work around it. Not sure if that is the issue here, but hope it helps. 


Cy Jervis, Manager, Community Program
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.