Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4039

Query fails when non-ascii characters are used in string literals

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.1.0
    • Fix Version/s: 1.11.0
    • Component/s: Client - JDBC
    • Labels:
    • Environment:

      Linux lnxx64r6 2.6.32-131.0.15.el6.x86_64 #1 SMP Tue May 10 15:42:40 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux

      Description

      The following query against DRILL returns this error:

      SYSTEM ERROR: CalciteException: Failed to encode 'НАСТРОЕние' in character set 'ISO-8859-1'
      cc39118a-cde6-4a6e-a1d6-4b6b7e847b8a on maprd

      Query is:

         SELECT
        T1.`F01INT`,
        T1.`F02UCHAR_10`,
        T1.`F03UVARCHAR_10`
         FROM
        DPRV64R6_TRDUNI01T T1
         WHERE
        (T1.`F03UVARCHAR_10` =  'НАСТРОЕние')
         ORDER BY
        T1.`F01INT`;

      This issue looks similar to jira HIVE-12207.

      Is there a fix or workaround for this?

        Attachments

        1. DRILL-4039.patch
          3 kB
          liyun Liu

          Issue Links

          There are no Sub-Tasks for this issue.

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                sergiolob Sergio Lob
                Reviewer:
                Sudheesh Katkam
              • Votes:
                5 Vote for this issue
                Watchers:
                14 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: