CREATE TABLE IF NOT EXISTS employee ( eid int, name String, salary String, destination String) COMMENT ‘Employee details’ partitioned by (batch_date date)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\n’ STORED AS ORC;
I want to blank out Salary column.
Update isn't working. Update employee set salary="";
While creating a copy, blanking out the salary but this doesn't seem to work.
create table employee_bkup ( eid int, name String, salary String, destination String) partitioned by (batch_date date)
select eid, name, "", destination from employee;
I get an Error: Create Table as SELECT command cannot specify the list of columns for the target table.