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

Vectorized unix_timestamp is inconsistent with non-vectorized counterpart

    XMLWordPrintableJSON

Details

    Description

      create table t (d string);
      insert into t values('2020-11-16 22:18:40 UTC');
      
      select
        '>' || d || '<' , unix_timestamp(d), from_unixtime(unix_timestamp(d)), to_date(from_unixtime(unix_timestamp(d)))
      from t
      ;
      
      set hive.fetch.task.conversion=none;
      
      select
        '>' || d || '<' , unix_timestamp(d), from_unixtime(unix_timestamp(d)), to_date(from_unixtime(unix_timestamp(d)))
      from t
      ;
      
      

      results:

      -- std udf:
      >2020-11-16 22:18:40 UTC<       1605593920      2020-11-16 22:18:40     2020-11-16
      -- vectorized udf
      >2020-11-16 22:18:40 UTC<       NULL    NULL    NULL
      

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m