Last Updated: Oct 5, 2021
When using Dataset node to retrieve columns by using the query: Select * from ‘/Basic Training/Advance_Training/TravelData’, I am getting the error "...mismatched input...". This error occurs when the query syntax is incorrect. Query syntax must be: Select * from `/{app_group}/{app}/{dataset_name}` Ensure that the symbol used must be backquote` and not single quote'.
When I try to insert the data using Jiffy Insert/Update node, I get an error “Validated but not processed” This can occur if the input value does not match the column field type.
Ensure the input values have the same field type as the column you are inserting or updating.Table Column is of field type Datetime, but the input value mapped is not of type Datetime.