Hello Akash,  Thanks for your feedback. Actually, its work fine if I change my query as below:   SELECT DISTINCT T1.block_id AS block_id, T1.block_name AS block_name, T1.block_kp_begin AS block_kp_begin, T1.block_kp_end AS block_kp_end, T2.ap_track_id AS ap_track_id, T2.ap_kp_in_track AS ap_kp_in_track, T2.ap_physical_name AS ap_physical_name, T3.track_name AS track_name, T3.track_type AS track_type FROM amsterdam.amd_block_info T1 LEFT JOIN amsterdam.amd_ap_info T2 ON T1.track_id = T2.ap_track_id LEFT JOIN amsterdam.amd_track_info T3 ON T1.track_id = T3.track_id;   Here all I needed to define my variable as Alias again then the problem fixed. ... View more

Used below formula to resolve my problem ${field.value:substring(0,21):toDate("MMM dd,yyyy HH:mm:ss"):format("yyyy-MM-dd HH:mm:ss")}.${field.value:substring(22,28)}   We separately added last 6 digit using .${field.value:substring(22,28)} after the time format.Otherwise, nifi can not process 6 digit microsecond. ... View more

Hello all, The problem has been resolved. First, I ingested the all the attributes as a text in the PostgreSQL table. Then converted the text data to integer type with flowing command. ALTER TABLE public."tab" ALTER COLUMN col type int using nullif(col,'')::int Hope this will be helpful for others. ... View more

Hello Steve, Thanks for your answer. Don't know why your provided answer is not working in my case. But I solved it in another way which I am sharing here for others timestamp : ([0-9]{4})-([0-1][0-9])-([0-3][0-9])\s([0-1][0-9]|[2][0-3]):([0-5][0-9]):([0-5][0-9]).(\d*) source_ip :  (?:[0-9]{1,3}\.){3}[0-9]{1,3} Mac : ([0-9A-Fa-f]{2}[:]){5}([0-9A-Fa-f]{2}) dbm : (\d*)\z Thanks! ... View more