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

Difference in BOOLEAN cast between Hive and Calcite

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: core
    • Labels:
      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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: