Details
-
Bug
-
Status: Open
-
Critical
-
Resolution: Unresolved
-
None
-
None
-
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
- relates to
-
HIVE-10481 ACID table update finishes but values not really updated if column names are not all lower case
- Closed