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

metadata-only queries may return incorrect results with empty tables

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 2.2.0
    • None

    Description

      Queries like select 1=1 from t group by 1=1 may return rows, based on OneNullRowInputFormat, even if the source table is empty. For now, add some basic detection of empty tables and turn this off by default (since we can't know whether a table is empty or not based on there being some files, without reading them).

      Attachments

        1. HIVE-15397.patch
          13 kB
          Sergey Shelukhin
        2. HIVE-15397.01.patch
          19 kB
          Sergey Shelukhin

        Issue Links

          is cloned by

          Bug - A problem which impairs or prevents the functions of the product. HIVE-15398 change metadata-only queries to still read the original table (in some cases?)

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-23712 metadata-only queries return incorrect results with empty acid partition

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. HIVE-1003 optimize metadata only queries

          • Major - Major loss of function.
          • Closed

          Activity

            People

              sershe Sergey Shelukhin
              sershe Sergey Shelukhin
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: