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

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.0.0-alpha-1
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: