Null Value Initialization

VOID type can only be applied to scalars. VOID vectors cannot be directly created.

x=NULL;
typestr x;
// output: VOID

take(NULL, 4);
// output: Not allowed to create void vector

VOID columns cannot be added to a table.

t = table(rand(10,10) as x)
addColumn(t, `col1, VOID)
Invalid data type: 0
t[`col1]=NULL
Not allowed to create void vector

To add a VOID column to a table, use a select statement with NULL.

tmp=select *, NULL from t
typestr(tmp[`NULL])
VOID VECTOR

To initialize null temporal scalars or null values of integral/floating type, use 00<data type symbol>.

To initialize null vectors, use take (00<data type symbol>, n), where n is the number of elements in the vector.

x=00b;
// b indicates a BOOL constant
typestr x;
// output: BOOL

bool();
// output: 00b
// Use type functions such as bool, char, short, int to create a null scalar if no argument is provided

x=00i;
// i indicates a INT constant

typestr x;
// output: INT

x=00l;
// l indicates a LONG constant

typestr x;
// output: LONG

x=take(00b, 10);
// Initialize a null BOOL vector with 10 elements

x;
// output: [,,,,,,,,,]

typestr x;
// output: FAST BOOL VECTOR

x=take(00i, 10)
// Initialize a null INT vector with 10 elements

x;
// output: [,,,,,,,,,]

x=array(INT, 10, 100, NULL);
// Initialize a null INT vector with 10 elements and an initial size of 100

x;
// output: [,,,,,,,,,]

x=true false NULL true;
x;
// output: [1,0, ,1]

m=matrix(DOUBLE,3,3)*NULL;
m;

shape m;
// output: 3:3

typestr m;
// output: DOUBLE MATRIX