Follow

GADM-0001: Ingesting NULL Values via Advanced CSV Import

Overview: 

While ingesting data via the Advanced CSV Import tool in Kinetica, values may be nullified from the .csv file. Upon selecting the .csv file to use, a few options will be presented to the user. One of these is the "Null String" option for string values only. The default flag is '\N' but this may be altered to suit your personal conventions and works in the same fashion:

 

null.png

 

Action:

In the .csv file itself, we should use this Null String to nullify any values of string type. However, for numerical data types such as, double, float, int etc.. we will need to leave those values blank in the .csv file. They will be imported into Kinetica as <null> as intended.

Note: If we attempt to use the NULL String value to nullify a numerical data type such as double, the following error will be encountered:

Failed (0%): Error parsing line 2. => Error in line 2. Invalid class java.lang.Double for field myTestValue (null). => null

 

Should you have any questions or concerns, please visit our Official Documentation and Support Page.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.