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

Date: date + int fails to add days

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 4.0.0
    • Fix Version/s: 4.0.0
    • Component/s: Types
    • Labels:
      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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: