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

introducing the "dual" table

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Query Processor
    • None

    Description

      The "dual" table in MySQL and Oracle is very convenient in testing UDFs or constructing rows without reading any other tables.

      If dual is the only data source we could leverage the local mode execution.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-9840 select count(*) <tablename> should give exception

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. HIVE-4144 Add "select database()" command to show the current database

          • Major - Major loss of function.
          • Resolved

          Wish - General wishlist item. HIVE-178 SELECT without FROM should assume a one-row table with no columns.

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Activity

            People

              marcink Marcin Kurczych
              nzhang Ning Zhang
              Votes:
              13 Vote for this issue
              Watchers:
              13 Start watching this issue

              Dates

                Created:
                Updated: