I have table in hive with below format.
hive> describe heorders_rank;
OK
order_id int
order_date string
order_cust_id int
order_status string
Below is the hdfs data.
1:2000-01-01:100:Y
2:2018-01-01:200:Y
3:2017-01-01:100:Y
4:2018-01-01:null:N
5:2018-10-10:150:N
Getting error when I try to load the hive table with the data using the below command. Can you please help.
hive> load data inpath "/user/edureka_212418/heorders_rank" into table heorders_rank ROW FORMAT DELIMITED FIELDS TERMINATED BY ":";
FAILED: ParseException line 1:80 missing EOF at "ROW" near "heorders_rank"