Search

Data Node

Last Updated: Oct 5, 2021

Articles

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...".
Image description

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” Image description

This can occur if the input value does not match the column field type.

Table Column is of field type Datetime, but the input value mapped is not of type Datetime.

Ensure the input values have the same field type as the column you are inserting or updating.

Did you find what you were looking for?