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

Date: date + int fails to add days

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 4.0.0
    • 4.0.0-alpha-1
    • Types
    • None

    Description

      select current_date + 5;

FAILED: SemanticException [Error 10014]: Line 1:7 Wrong arguments '5': No matching method for class org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPDTIPlus with (date, int)

      This works in Postgres 9.6 - http://sqlfiddle.com/#!17/9eecb/19253/0

      Attachments

        1. HIVE-20385.1.patch
          7 kB
          Bruno Pusztahazi
        2. HIVE-20385.2.patch
          9 kB
          Bruno Pusztahazi
        3. HIVE-20385.3.patch
          17 kB
          Bruno Pusztahazi
        4. HIVE-20385.4.patch
          17 kB
          Bruno Pusztahazi
        5. HIVE-20385.5.patch
          17 kB
          Bruno Pusztahazi
        6. HIVE-20385.6.patch
          17 kB
          Bruno Pusztahazi

        Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-22012 Support timestamp type + string type

          • Major - Major loss of function.
          • Open

          Activity

            People

              bpusztahazi Bruno Pusztahazi
              gopalv Gopal Vijayaraghavan
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: