I am loading a row-store table using file system pipelines and stored procedures. Syntax is similar to below.
INSERT INTO table SELECT * FROM batch_query WHERE condition ON DUPLICATE KEY UPDATE ROWS = values(ROWS).
Can we use the COLUMN name from the table in the WHERE condition to skip some rows from being updated. Basically i have a timestamp coming from the file and i do not want to update the row in the table if the table row timestamp is greater than the timestamp that is coming from the file.
When i tried, i am getting the below error.
Type: ER_BAD_FIELD_ERROR (1054) Message: Unknown column 'MEMSQL_CRT_TS' in 'where clause'
If this is not possible, is there any other way to skip certain rows in the table from being updated by the pipeline.