[ https://issues.apache.org/jira/browse/HIVE-18104?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ravi Ranjan updated HIVE-18104: ------------------------------- 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 and 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> 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 was: 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 > 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; > 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> 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 -- This message was sent by Atlassian JIRA (v6.4.14#64029)