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