Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-23515

Hive2.1.1 use 'union all' merge subquery,the result an exception

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • 2.1.1
    • None
    • Clients
    • None

    Description

      hive version:2.1.1

      cdh version:6.1.1

      when i use 'union all' func to merge subquery into a table,if subquery's order is different,the resultset also different,What is the cause of this?

      Attachments

        1. hive.sql
          44 kB
          charles
        2. query-hive-5928.csv
          117 kB
          charles
        3. query-hive-5931.csv
          117 kB
          charles

        Activity

          People

            Unassigned Unassigned
            karuna_yeh charles
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: