SQL-0004: Syntax Error While Attempting to Use SQL to Specify Default Column Values

Overview:

There may be a time where we would to specify a default value for a column that may not have data directly inserted during ingest. The purpose of this article is to publish that fact that specifying default column values via SQL in other databases may be supported, in Kinetica is not a supported feature. The process will fail with error.

Example Use Case:

Creation of a progress table with a completion column to identify if a task is complete "c" or incomplete "i". We would like the default value to be "i" for this column until manually updated. Attempting to use the following SQL will fail: