[jira] [Resolved] (IMPALA-6721) Unable to pass parameters from SSRS using Impala ODBC

["Tim Armstrong (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-6721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tim Armstrong resolved IMPALA-6721.
-----------------------------------
    Resolution: Information Provided

The components (SSRS and Impala ODBC driver) aren't developed by the Apache Impala project. We use this tracker exclusively to track defects and potential improvements in code owned by the Apache Impala project. I saw this question was asked in a Cloudera forum: http://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Unable-to-pass-parameter-to-Impala-from-SSRS/m-p/65620/highlight/false#M4261 , which is a better venue, so I answered over there.

> Unable to pass parameters from SSRS using Impala ODBC 
> ------------------------------------------------------
>
>                 Key: IMPALA-6721
>                 URL: https://issues.apache.org/jira/browse/IMPALA-6721
>             Project: IMPALA
>          Issue Type: Bug
>            Reporter: Debasish P
>            Priority: Major
>
> Hi Team,
> We are unable to pass parameters from Microsoft SSRS using Impala ODBC. Have tried with @,?,${ }, but it's giving an error that "Unable to parse query text"
> Error Source: Cloudera ODBC Driver for Impala
> Error Message: ERROR [HY000] [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: Syntax error in line 3:
> WHERE
> sample query:
> select * from impala_table where col_name = $ \{ param_name}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)