You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Ravi Ranjan (JIRA)" <ji...@apache.org> on 2017/11/20 05:43:00 UTC
[jira] [Updated] (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: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)