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

Throw a Hive error if we're in strict mode and a the types of a partition comparison do not match.

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 0.8.1, 0.9.0
    • None
    • Query Processor
    • hive, sematic analyzer

    Description

      Oftentimes people try to write queries like
      SELECT *
      FROM table
      WHERE ds = 2011-08-03

      This won't work because quotes are missing, and it'll actually try to filter on ds = "2000".

      People run into this pretty regularly; a simple check on whether the types match exactly in partition predicates would make this a lot less likely to happen.

      Attachments

        Activity

          People

            Unassigned Unassigned
            dmitrysoshnikov Dmitry Soshnikov
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Remaining Estimate - 24h
                24h
                Logged:
                Time Spent - Not Specified
                Not Specified