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

For time related functions arguments may not be casted to a non nullable type

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.0.0
    • Component/s: None
    • Labels:
      None

      Description

      create table t (a string); insert into t values (null),('1988-11-11');
      set hive.cbo.enable=true;
      select 'expected 1 (second)', count(1) from t where second(a) is null;
      

      this may only cause trouble if Calcite is exploiting the datatype nullability; it will be need after CALCITE-2469 (1.18.0)

        Attachments

        1. HIVE-20898.01.patch
          5 kB
          Zoltan Haindrich
        2. HIVE-20898.02.patch
          25 kB
          Zoltan Haindrich

          Activity

            People

            • Assignee:
              kgyrtkirk Zoltan Haindrich
              Reporter:
              kgyrtkirk Zoltan Haindrich
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: