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

Issue in HIVE Update Command for set columns

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: CLI, Transactions
    • Labels:
      None

      Description

      When Updating a table, error comes in when a wrong column name is entered in where clause but Mapreduce executes successfully when column name in set clause is wrong, though no value gets updated.

      hive> describe test_table;
      OK
      run_site varchar(50)
      run_year int
      run_month int
      data_loaded_yn varchar(1)
      run_date timestamp
      message string
      datetime timestamp
      Time taken: 0.169 seconds, Fetched: 10 row(s)

      ################################################
      hive> update test_table set abc='Y' where message='Processing';
      Query ID = 20171120052859_d95524f8-a9d3-48ad-aa84-2932696d3432
      Total jobs = 1
      Launching Job 1 out of 1

      Status: Running (Executing on YARN cluster with App id application_1508354216914_35481)

      --------------------------------------------------------------------------------
      VERTICES STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED
      --------------------------------------------------------------------------------
      Map 1 .......... SUCCEEDED 2 2 0 0 0 0
      Reducer 2 ...... SUCCEEDED 2 2 0 0 0 0
      --------------------------------------------------------------------------------
      VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 9.52 s
      --------------------------------------------------------------------------------
      Loading data to table test_table
      Table test_table stats: [numFiles=39, numRows=3, totalSize=56417, rawDataSize=0]
      OK
      Time taken: 10.517 seconds

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                ranjanravi90 Ravi Ranjan
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated: