Hive
  1. Hive
  2. HIVE-1386

HiveQL SQL Compliance (Umbrella)

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Query Processor
    • Labels:
      None
    • Tags:
      umbrella sql hql compliance sql-92

      Description

      This is an umbrella ticket to track work related to HiveQL compliance with the SQL standard, e.g. supported query syntax, data types, views, catalog access, etc.

        Issue Links

          Activity

          Hide
          Jeff Hammerbacher added a comment -

          Do we need ORDER BY as well (HIVE-61)?

          Show
          Jeff Hammerbacher added a comment - Do we need ORDER BY as well ( HIVE-61 )?
          Hide
          Ning Zhang added a comment -

          @jeff, order by is already supported.

          In addition, I see some requests for (sorry couldn't find out if they have a JIRA open since the web site is extremely slow).

          • UNION ALL without the outer SELET * wrapper
          • INSERT INTO/APPEND in addition to INSERT OVERWRITE
          Show
          Ning Zhang added a comment - @jeff, order by is already supported. In addition, I see some requests for (sorry couldn't find out if they have a JIRA open since the web site is extremely slow). UNION ALL without the outer SELET * wrapper INSERT INTO/APPEND in addition to INSERT OVERWRITE
          Hide
          Jeff Hammerbacher added a comment -

          Ning: where? http://wiki.apache.org/hadoop/Hive/LanguageManual/SortBy doesn't list it, but does show how to simulate ORDER BY. I wasn't sure if that was sufficient.

          Show
          Jeff Hammerbacher added a comment - Ning: where? http://wiki.apache.org/hadoop/Hive/LanguageManual/SortBy doesn't list it, but does show how to simulate ORDER BY. I wasn't sure if that was sufficient.
          Hide
          Ning Zhang added a comment -

          HIVE-61 (order by) has been committed long time ago. Maybe the language manual was not updated.

          Show
          Ning Zhang added a comment - HIVE-61 (order by) has been committed long time ago. Maybe the language manual was not updated.
          Hide
          Jeff Hammerbacher added a comment -

          The discussion in HIVE-61 seems to indicate that SORT BY was decided upon as the syntax and that, to simulate ORDER BY behavior, one should set the number of reduce tasks to be 1. I don't have an instance of Hive running near by, but if there is now ORDER BY in the syntax, could you please update the language guide?

          Show
          Jeff Hammerbacher added a comment - The discussion in HIVE-61 seems to indicate that SORT BY was decided upon as the syntax and that, to simulate ORDER BY behavior, one should set the number of reduce tasks to be 1. I don't have an instance of Hive running near by, but if there is now ORDER BY in the syntax, could you please update the language guide?
          Hide
          Edward Capriolo added a comment -

          As a side note maybe with something total order partitioner we can do a true map/reduce order by.

          Show
          Edward Capriolo added a comment - As a side note maybe with something total order partitioner we can do a true map/reduce order by.
          Hide
          Ning Zhang added a comment -

          I've updated the wiki to include "order by". Please check it out at http://wiki.apache.org/hadoop/Hive/LanguageManual/SortBy

          Show
          Ning Zhang added a comment - I've updated the wiki to include "order by". Please check it out at http://wiki.apache.org/hadoop/Hive/LanguageManual/SortBy

            People

            • Assignee:
              Unassigned
              Reporter:
              Carl Steinbach
            • Votes:
              0 Vote for this issue
              Watchers:
              16 Start watching this issue

              Dates

              • Created:
                Updated:

                Development