Hive
  1. Hive
  2. HIVE-2885

select distinct <string> from table returns wrong result

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 0.8.1
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      None

      Description

      Give the following table:

      CREATE TABLE `MYTAB` (`a` DOUBLE)....

      containing the values 1, 2, 3, and 4, the following SQL fails to produce the correct result:

      select distinct 'FOO' from `MYTAB`

      Note that this issue didn't show up with Hive 7. Only 8.1 seems to be affected.

        Activity

          People

          • Assignee:
            Unassigned
            Reporter:
            Mauro Cazzari
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development