You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Eugene Koifman (JIRA)" <ji...@apache.org> on 2017/11/20 16:54:01 UTC

[jira] [Commented] (HIVE-18104) Issue in HIVE Update Command for set columns

    [ https://issues.apache.org/jira/browse/HIVE-18104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16259468#comment-16259468 ] 

Eugene Koifman commented on HIVE-18104:
---------------------------------------

[~ranjanravi90], What version of Hive was this observed in?

> 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)