Does Myria support null column value during scanning CSV file?

[RonyMin]

Hi,

When I read TPC-DS benchmark dataset, some foreign key column values are null, so loading relations from CSV which contains null value fails.
For instance, table store_sales (fact table) contains multiple foreign keys that may contain null value.
(e.g., 1||2|3||4|5|6|7|8|9|) where consecutive delimiters such as || indicate null value.

How can I prevent such null-related error?

Thanks,
Yoon-Min

[senderista]

Myria does not support NULL values. @jingjingwang should be able to tell you how she dealt with this issue.

[RonyMin]

Thank you @senderista,
@jingjingwang Is there any alternative way to handle null value for loading CSV to Myria system?