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.

Passing Parameters from SSRS to Hive

Highlighted

Passing Parameters from SSRS to Hive

Hi guys,

Have any of you tried this?

Im using SSRS for my reporting and im using hive as source.

Thank you.

8 REPLIES 8
Highlighted

Re: Passing Parameters from SSRS to Hive

Expert Contributor

do you mean query parameters ex. where transaction_dt=[date from parameter] , like that. SSRS has the capability to create parameters on reports.

https://technet.microsoft.com/en-us/library/aa337401(v=sql.105).aspx

Highlighted

Re: Passing Parameters from SSRS to Hive

For example sir is, select * from table where date = @date;

Hive is not reading that style of parameter. I've searched that they are making somewhat like ${hiveconf:param}, but if i do that, there is an error in ssrs.

Highlighted

Re: Passing Parameters from SSRS to Hive

Expert Contributor

i think you can add date, as a parameter in your sirs report and query, SSRS will replace it for you at runtime.

Highlighted

Re: Passing Parameters from SSRS to Hive

Expert Contributor

may be date is a reserved word, try some other name like @mydate

Re: Passing Parameters from SSRS to Hive

No sir, its just a sample. any param name causes error.

Highlighted

Re: Passing Parameters from SSRS to Hive

Expert Contributor

please provide the error and some screenshots if possible

Highlighted

Re: Passing Parameters from SSRS to Hive

Contributor

Hi @regie canada,

You can use ? to pass the parameters in place of the usual @.

Using @ is specific to Transact-SQL. The driver supports SQL-92 syntax where parameter markers in the SQL statement are expected to be question marks.

Thanks,

Rohit Rai Malhotra

Highlighted

Re: Passing Parameters from SSRS to Hive

New Contributor

Folks

Has anyone been able to get the parameter from SSRS sent over to HIVE using HortonWorks ??

I am facing the same issue as posted above and have tried $ and ? and both does not work - attached are the error that popup....

Any suggestions ??

Goal to acheive : Pick a parameter value from Paramert of SSRS report and send to HIVE through Hortonworks

42684-state.png

42683-stateq.png

Don't have an account?
Coming from Hortonworks? Activate your account here