Hive
  1. Hive
  2. HIVE-6068

HiveServer2 client on windows does not handle the non-ascii characters properly

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.13.0
    • Fix Version/s: 0.13.0
    • Component/s: HiveServer2, JDBC
    • Labels:
      None
    • Environment:

      Windows

      Description

      When running a select query against a table which contains rows with non-ascii characters HiveServer2 Beeline client returns them wrong. Example:

      738;Garçu, Le (1995);Drama
      741;Ghost in the Shell (Kôkaku kidôtai) (1995);Animation|Sci-Fi
      

      come out from a HiveServer2 beeline client as:

      '738'	'Gar?u, Le (1995)'	'Drama'
      '741'	'Ghost in the Shell (K?kaku kid?tai) (1995)'	'Animation|Sci-Fi'
      
      1. HIVE-6068.2.patch
        4 kB
        Vaibhav Gumashta
      2. HIVE-6068.1.patch
        1 kB
        Vaibhav Gumashta

        Issue Links

          Activity

          Hide
          Vaibhav Gumashta added a comment -
          Show
          Vaibhav Gumashta added a comment - cc Thejas M Nair
          Hide
          Thejas M Nair added a comment -

          Looks good. Can you also include a test case ?

          Show
          Thejas M Nair added a comment - Looks good. Can you also include a test case ?
          Hide
          Hive QA added a comment -

          Overall: -1 at least one tests failed

          Here are the results of testing the latest attachment:
          https://issues.apache.org/jira/secure/attachment/12633681/HIVE-6068.1.patch

          ERROR: -1 due to 2 failed/errored test(s), 5376 tests executed
          Failed tests:

          org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_auto_sortmerge_join_16
          org.apache.hadoop.hive.cli.TestNegativeMinimrCliDriver.testNegativeCliDriver_mapreduce_stack_trace_hadoop20
          

          Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1698/testReport
          Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1698/console

          Messages:

          Executing org.apache.hive.ptest.execution.PrepPhase
          Executing org.apache.hive.ptest.execution.ExecutionPhase
          Executing org.apache.hive.ptest.execution.ReportingPhase
          Tests exited with: TestsFailedException: 2 tests failed
          

          This message is automatically generated.

          ATTACHMENT ID: 12633681

          Show
          Hive QA added a comment - Overall : -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12633681/HIVE-6068.1.patch ERROR: -1 due to 2 failed/errored test(s), 5376 tests executed Failed tests: org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_auto_sortmerge_join_16 org.apache.hadoop.hive.cli.TestNegativeMinimrCliDriver.testNegativeCliDriver_mapreduce_stack_trace_hadoop20 Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1698/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1698/console Messages: Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 2 tests failed This message is automatically generated. ATTACHMENT ID: 12633681
          Hide
          Vaibhav Gumashta added a comment -

          Thejas M Nair Thanks for the review. New patch incorporates the feedback.

          Show
          Vaibhav Gumashta added a comment - Thejas M Nair Thanks for the review. New patch incorporates the feedback.
          Hide
          Thejas M Nair added a comment -

          +1

          Show
          Thejas M Nair added a comment - +1
          Hide
          Hive QA added a comment -

          Overall: -1 at least one tests failed

          Here are the results of testing the latest attachment:
          https://issues.apache.org/jira/secure/attachment/12638142/HIVE-6068.2.patch

          ERROR: -1 due to 2 failed/errored test(s), 5540 tests executed
          Failed tests:

          org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_bucketmapjoin6
          org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_reduce_deduplicate
          

          Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/2077/testReport
          Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/2077/console

          Messages:

          Executing org.apache.hive.ptest.execution.PrepPhase
          Executing org.apache.hive.ptest.execution.ExecutionPhase
          Executing org.apache.hive.ptest.execution.ReportingPhase
          Tests exited with: TestsFailedException: 2 tests failed
          

          This message is automatically generated.

          ATTACHMENT ID: 12638142

          Show
          Hive QA added a comment - Overall : -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12638142/HIVE-6068.2.patch ERROR: -1 due to 2 failed/errored test(s), 5540 tests executed Failed tests: org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_bucketmapjoin6 org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_reduce_deduplicate Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/2077/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/2077/console Messages: Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 2 tests failed This message is automatically generated. ATTACHMENT ID: 12638142
          Hide
          Thejas M Nair added a comment -

          Harish Butani It will be useful to have this bug fix in 0.13, it is a small safe change.

          Show
          Thejas M Nair added a comment - Harish Butani It will be useful to have this bug fix in 0.13, it is a small safe change.
          Hide
          Harish Butani added a comment -

          +1 for 0.13

          Show
          Harish Butani added a comment - +1 for 0.13
          Hide
          Thejas M Nair added a comment -

          Patch committed to 0.13 branch and trunk.
          Thanks Vaibhav!

          Show
          Thejas M Nair added a comment - Patch committed to 0.13 branch and trunk. Thanks Vaibhav!

            People

            • Assignee:
              Vaibhav Gumashta
              Reporter:
              Vaibhav Gumashta
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development