CODEWITHSUNDEEP
hadoophive
shinchaan
shinchaan

Reputation: 136

Showing NULL values after adding column in hive

i am using hive-version 1.2.1. i m newbie to hive.
i have added a column to TABLE_2 and shows NULL value. i want to put DATE part from timestamp column to newly created column. i tried with below query:

ALTER TABLE table_2 ADD COLUMNS(DATE_COL string);
INSERT INTO table_2 (DATE_COL) AS SELECT SUBSTRING(TIMESTAMP_COL,-19,10) FROM table_1 ;

this is working bt still it shows NULL values in newly created DATE_COL. i want just date in DATE_COL.

table_1 has 13 columns, table_2 has 14 columns (13 + DATE_COL).

TIMESTAMP_COL :- STRING.

DATE_COL - STRING.

please tell me how to solve this problem.

Upvotes: 1

Views: 1925

Answers (1)

Jack
Jack

Reputation: 520

Use UPDATE command : Syntax:

UPDATE tablename SET column = value [, column = value ...] [WHERE expression]

Hive version 0.14.0: INSERT...VALUES, UPDATE, and DELETE are now available with full ACID support.

Upvotes: 0

Related Questions