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

Support auto-casting non-boolean where condition into boolean

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Patch Available
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      Hive should support

      select 1 where 1

      currently it throws an execption (at least with mr)...complaining about Integer / Boolean casting difficulties.

      Current behaviour is a bit inconsistent; because using tez / vectorization this is supported.

      related tickets:
      HIVE-15089
      HIVE-1478
      HIVE-13659

      Attachments

        1. HIVE-15408.01.patch
          17 kB
          Zoltan Haindrich
        2. HIVE-15408.02.patch
          22 kB
          Zoltan Haindrich
        3. HIVE-15408.03.patch
          25 kB
          Zoltan Haindrich
        4. HIVE-15408.04.patch
          47 kB
          Zoltan Haindrich
        5. HIVE-15408.05.patch
          45 kB
          Zoltan Haindrich

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-15089 Error: java.lang.RuntimeException: Hive Runtime Error while closing operators: java.lang.Integer cannot be cast to java.lang.Boolean

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. HIVE-1478 Non-boolean expression in WHERE should be rejected

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

          Bug - A problem which impairs or prevents the functions of the product. HIVE-13659 An empty where condition leads to vectorization exceptions instead of throwing a compile time error

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              kgyrtkirk Zoltan Haindrich
              kgyrtkirk Zoltan Haindrich
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: