hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ravi Ranjan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-18104) Issue in HIVE Update Command for set columns
Date Mon, 20 Nov 2017 05:41:00 GMT
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)

Mime
View raw message