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

[hive] lot of mappers due to a user error while specifying the partitioning column

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.3.0
    • Component/s: Query Processor
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      A common scenario when the table is partitioned on 'ds' column which is of type 'string' of a certain format 'yyyy-mm-dd'

      However, if the user forgets to add quotes while specifying the query:

      select ... from T where ds = 2009-02-02

      2009-02-02 is a valid integer expression. So, partition pruning makes all partitions unknown, since 2009-02-02 to double conversion is null.

      If all partitions are unknown, in strict mode, we should thrown an error

        Attachments

        1. hive.347.1.patch
          3 kB
          Namit Jain
        2. hive.347.2.patch
          3 kB
          Namit Jain
        3. hive.347.3.patch
          3 kB
          Namit Jain
        4. hive.347.4.patch
          3 kB
          Namit Jain

          Activity

            People

            • Assignee:
              namit Namit Jain
              Reporter:
              namit Namit Jain
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: