...
CREATE TABLE will be updated to let user specify DEFAULT if following waysas follows:
With column definition
CREATE TABLE <tableName> (<columnName> <dataType> DEFAULT <defaultValue>)
With constraint specificationCREATE TABLE <tableName> (<columnName> <dataType>, …, CONSTRAINT <constraintName> DEFAULT <defaultValue> (<columnName>)
To be compliant with SQL standard standards, Hive will only permit default values which falls fall in one of the following categorycategories:
LITERALLITERAL
DATE TIME VALUE FUNCTION i.e. , that is, CURRENT_TIME, CURRENT_DATEDATE
- CURRENT_USER()
- NULLNULL
- CAST (<expression in above category> as PRIMITIVE TYPE)
INSERT
Anytime user doesn’t specify a value explicitly for a column its default value will be used if defined e.g
...