@arunnalpet You should be able to just add the $. If it doesn't work, maybe have to escape it:  \$ ... View more

Great answer many thanks. For the record, I had the data in a FlowFile. I needed a bit of regex magic to remove the quotation marks after unescaping. ... View more

Thank You @stevenmatison its working now. ... View more

@Genentech I am not sure if this is the answer you are looking for, but my recommendation is to leave your original table as is and select results from that into the parquet table.  I am a firm believe of using backup copies, staging, copies or temporary copies of original data sources on the path through translation to final source.   Make a new empty table with the parquet format you want.   The format must match.   Next execute:   INSERT INTO final_table SELECT * from source_table;   If you need to retain the same original table name, you can alter or drop the original table, and execute a rename statement on the final_table above.   If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.     Thanks, Steven @ DFHZ ... View more

Use query record processor, have CSVReader and JSONWriter output.   do SELECT satellite_name FROM FLOWFILE   Next processor can grab an attribute   ... View more

@varun_rathinam Accessing json in an array object via EvaluateJsonPath can be quite confusing.   I also notice the structure of your json is kind of confusing with same values in both.  I have adjusted id2 for cc and dd for testing so that I can tell id1 and id2 values apart.   The solution you want is (see template for exact string values):             Notice we use the normal tree for each json object ( $.object ) then access the array ( 0, 1 ) then access the array's objects.   Also notice it is possible to access the json object array with or without a . before the [.   Reference: https://community.cloudera.com/t5/Support-Questions/how-to-extract-fields-in-flow-file-which-are-surrounded-by/m-p/208635   You can also find my template during testing of your issue on my GitHub: https://github.com/steven-dfheinz/NiFi-Templates/blob/master/NiFI_EvaluateJsonPath_Demo.xml     If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic.   If you have further dialogue on this topic please comment here or feel free to private message me.    If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.   Thanks, Steven @ DFHZ ... View more

Thanks for the revert mate. Much Appreciated.  ... View more