Thanks a lot, @SAMSAL for the technical suggestion! Please find below our comments on both the proposed solutions, Solution 1: Using Sql Calcite function TIMESTAMPADD This method does not perform the conversion. Please refer to the below screenshot for more details and let us know if we are making any mistakes. It returned the same output Solution 2: Using Expression Language This solution works fine when we pass the data directly into the query record. However, we wanted to apply this conversion for the batch of data in the CSV input file. Please refer below for the complete flow Complete NiF Flow : Input File : Id,username,load_date 1,test@test.com,1725000090 Error Message : QueryRecord[id=2cc603e4-0191-1000-f3c7-ef830564cf72] Unable to query FlowFile[filename=convertfunctionsample.csv] due to org.apache.nifi.attribute.expression.language.exception.AttributeExpressionLanguageException: Invalid Expression: select '${literal(load_date):multiply(1000):format('yyyy-MM-dd HH:mm:ss')}' mytimestamp from flowfile due to Unexpected token 'load_date' at line 1, column 10. Query: ${literal(load_date):multiply(1000):format(yyyy-MM-dd HH:mm:ss)}: {} Please help us with your expertise if there is any way to pass the column from the flowfile to the Expression language. Thanks in advance!
... View more
