Support Questions
Find answers, ask questions, and share your expertise

Issue with parametrized query on Impala

New Contributor

Can i run parameterized query on impala (version 1.1) through pentaho CDE 5.0.1? 

 

I stuck at some point while building Dashboard using Pentaho CDE 5.0.1 and Datasource Impala 1.1

 

I need to pass a parameter to run a query on Impala like 

 

Select account_id from accounts where account_name = ${account_name}

 

but the query fails

 

Is there any jar that i am missing or Impala 1.1 does not support parametrized query.

 

Any help will be greatly appreciated.

 

Thanks & Regards

LKM

 

2 REPLIES 2

Re: Issue with parametrized query on Impala

Cloudera Employee

Hi LKM,

 

Impala doesn't support parametrized query.

 

If you want to do varaible subsitution, you will have to modify your query with the desired value yourself and then submit the query to impala.

 

Thanks,

Alan

Re: Issue with parametrized query on Impala

New Contributor

Also to note, Pentaho does not currently support Impala with CDE 5.0.1. We are currently working on this capability. Please contact the Pentaho team for more details on future integration with Cloudera.

 

Thanks,

 

Paul

Pentaho