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

Difference in DATE cast between Hive and Calcite

    XMLWordPrintableJSON

Details

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

    Description

      Hive CAST('<literal>' as DATE) is handled by Java's Date.valueOf and thus expects yyyy-mm-dd. In Hive SELECT CAST('1' as DATE); yields NULL but in Calcite is 0001-12-31.

      I'm opening this as Calcite issue to track HIVE-15708 (migrate to Calcite 1.12) blockers, not sure if solution will require Calcite changes.

      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: