Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1650

Difference in BOOLEAN cast between Hive and Calcite

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • None
    • None
    • core
    • None

    Description

      Hive CAST( ... AS BOOLEAN) gives true for anything 'not zero' (eg. CAST(1 as BOOLEAN) is true) while Calcite uses strict Java Boolean.valueOf(...) which yields true only for the string 'true'.

      Attachments

        Issue Links

          Blocked

          Task - A task that needs to be done. HIVE-15708 Upgrade calcite version to 1.12

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-1653 Pass an expression executor to RexUtil.simplify for constant reduction

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-1653 Pass an expression executor to RexUtil.simplify for constant reduction

          • Major - Major loss of function.
          • Closed

          Activity

            People

              julianhyde Julian Hyde
              rusanu Remus Rusanu
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: