...

INSERT INTO VALUES will be updated to let user specify DEFAULT keyword. If corresponding column has DEFAULT constraint Hive will use that otherwise NULL will be used.

Examples:

• INSERT INTO TABLE1 VALUES(DEFAULT, DEFAULT)
• INSERT INTO TABLE1(COL1) VALUES(DEFAULT)

UPDATE

UPDATE will be updated to let user specify DEFAULT keyword.

Example:

• UPDATE TABLE1 SET COL1=DEFAULT, COL2=DEFAULT WHERE <CONDITION>

Proposed Design

During first phase of AST analysis AST for DEFAULT will be replaced with corresponding DEFAULT value AST or NULL AST.