Ravi Ranjan created HIVE-18104:
----------------------------------
Summary: Issue in HIVE Update Command for set columns
Key: HIVE-18104
URL: https://issues.apache.org/jira/browse/HIVE-18104
Project: Hive
Issue Type: Bug
Components: CLI
Reporter: Ravi Ranjan
Priority: Critical
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 and no value gets updated.
hive> describe test_table;OKrun_site varchar(50)run_year
intrun_month intdata_loaded_yn varchar(1)run_date
timestampmessage stringdatetime
timestampTime taken: 0.169 seconds, Fetched: 10
row(s)################################################hive> test_table set
abc='Y' where message='Processing';Query ID =
20171120052859_d95524f8-a9d3-48ad-aa84-2932696d3432Total jobs = 1Launching Job
1 out of 1Status: 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
0Reducer 2 ...... SUCCEEDED 2 2 0 0 0
0--------------------------------------------------------------------------------VERTICES:
02/02 [==========================>>] 100% ELAPSED TIME: 9.52
s--------------------------------------------------------------------------------Loading
data to table test_tableTable astir_mi_db.astir_hv_lt_scenario_run stats:
[numFiles=39, numRows=3, totalSize=56417, rawDataSize=0]OKTime taken: 10.517
seconds
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
