JSON Document not validated against JSON schema using file connector

Legacy Contributor

Hi All,

I have published a JSON file using file connector,imported JSON schema in data catalog. 

I have included "warehouse" and required in JSON schema but when JSON file is published without required attribute there is no error and able to query in compass.

JSON Schema: which includes required property and maxlength.

Compass:

in the above result warehouse is displayed as blank if we don't inculde it in json data file, it is displaying warehouse data which is having more length than the schema definition.

is this behavior expected in infor datalake and could you let me know is this a bug?

Thanks,

Anish Kulkarni.

Legacy Contributor

Hi Anish,

I'm not 100% clear what might be the result you're seeing here but we can try to figure this out 

In the file you pushed or uploaded to Data Lake for Warehouse1, does it include values for columns like accountingEntityId, country, etc.? If there were no values passed, then this is effectively a NULL result for that tuple's column. You do have some data visible in the euState field so I'm not sure or clear if this is because that record in the file only contains a value there but for no other column?

Alternatively, if you have data for all of those columns in your file but your maxLength values are too narrow, you can re-register or update your metadata definition to extend the maxLength value and then run the EXEC INFOR.CLEAR_TABLE stored procedure against your table before attempting to re-query it.