https://community.cloudera.com/t5/Support-Questions/How-to-create-a-table-with-a-one-of-the-column-having/m-p/186049#M148151 <P>I'm searching for the equivalent of default syntax in Hive</P><P>Hana Syntax :</P><PRE>Create column table Employee ( NAME NVARCHAR(10), JOIN_DATE SECONDDATE DEFAULT CURRENT_TIMESTAMP)</PRE> Wed, 18 Jul 2018 17:24:17 GMT prathamesh_h 2018-07-18T17:24:17Z