Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-3690

Query parameters with Impala ODBC driver

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Cannot Reproduce
    • Affects Version/s: Kudu_Impala
    • Fix Version/s: None
    • Component/s: Clients
    • Labels:

      Description

      Query parameters with Impala ODBC driver not working
      example

      OdbcCommand command = DbConnection.CreateCommand();
      command.CommandText = "INSERT INTO Test VALUES(?, ?)";
      command.Parameters.Add("name", OdbcType.VarChar).Value = "PSUN";
      command.Parameters.Add("code", OdbcType.VarChar).Value = "EMP001";
      command.ExecuteNonQuery();

      when executed getting below error

      ERROR [HY000] [Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: Syntax error in line 1:\n...Test VALUES(?, ?)\n ^\nEncountered: Unexpected character\nExpected: CASE, CAST, EXISTS, FALSE, IF, INTERVAL, NOT, NULL, TRUNCATE, TRUE, IDENTIFIER\n\nCAUSED BY: Exception: Syntax error\n

        Attachments

          Activity

            People

            • Assignee:
              shashmi Syed A. Hashmi
              Reporter:
              psun_impala_2e3a Prasanna
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: