Как проверить/игнорировать необязательное значение при его проверке с помощью процессора «Проверить CSV» в Apache NiFi? ⇐ Apache

[Anonymous]

I'm new to Apache Nifi Community and I got stuck at one point - please help me for the below problem :

In Validate CSV processor I'm giving below schema(schema_used) to validate the CSV input. But, processor is showing error(err_screenshot).

Validate CSV - enter image description here

Schema_Used - StrNotNullOrEmpty(), ParseDate("MM/dd/yyyy"), StrNotNullOrEmpty(), StrNotNullOrEmpty(), Optional(), StrNotNullOrEmpty(), StrNotNullOrEmpty(), StrNotNullOrEmpty(), StrNotNullOrEmpty(), Optional(), Optional(), StrNotNullOrEmpty()

The above schema is showing below error - err_screenshot - enter image description here

Note: The Schema is working totally fine, if I remove 'Optional()'.

Problem - Please tell me how can I use 'Validate CSV' processor in Apache Nifi and validate Mandatory/Optional Fields of CSV. Also, suggest/share any script(groovy/python) if that can validate the CSV.


Источник: https://stackoverflow.com/questions/781 ... date-csv-p