[jira] [Created] (DRILL-7892) Parameter not working

["Christian (Jira)" <ji...@apache.org>]

Christian created DRILL-7892:
--------------------------------

             Summary: Parameter not working
                 Key: DRILL-7892
                 URL: https://issues.apache.org/jira/browse/DRILL-7892
             Project: Apache Drill
          Issue Type: Test
          Components: Client - ODBC
    Affects Versions: 1.18.0
            Reporter: Christian


Hi,

I'm accessing Drill (Docker version) through the MapR/Odbc driver (from within C# with Dapper). All works great but supplying parameters does not. I'm copied the code below but maybe this is a broader question as to whether parameters are supported at all - I was not able to find any documentation regarding that.

var tmpIndex = (await connection.QueryAsync<DataPoint>(@" var tmpIndex = (await connection.QueryAsync<DataPoint>(@" SELECT dir0 AS parquetindex, dealkey, rundate AS `date`, value FROM dfs.`/mnt/linuxshare/blazortest/20210331/mergepervariable` WHERE value IS NOT NULL AND dir0=@id LIMIT 1 ", new \{ id = 1 })).ToList();

The error I'm getting is this:

[30038]Query execution error. Details:[ PARSE ERROR: Lexical error at line 4, column 37.  Encountered: "@" (64), after : ""
SQL Query:  SELECT dir0 AS parquetindex, dealkey, rundate AS `date`, value FROM dfs.`/mnt/linuxshare/blazortest/20210331/mergepervariable` WHERE value IS NOT NULL AND dir0=@id                                    ^ LIMIT 1

 

I tried multiple ways of specifying the parameter (e.g. placeholder through ?) - the error message changes but it never succeeds.

 

Any insight whether this is even doable would be appreciated.

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)