Hi @Scharan, I have not backed up the ambari DB, does it back up automatically? And if it does where can I find that back up? ... View more

Hi, Welcome to the community. Can you elaborate more on how you want to flatten the input specially when you have multiple arrays with different cardinalities where sometimes you match by index and other (when the array count = 1) you seem to assign to all. Also your sample input seem to have some matching values which makes it ambiguous  in figuring which value is being assigned to what array. When I look at the output all I see is  two identical objects where all the values seem to match which makes it even more confusing.  ... View more

Thanks @VidyaSargur  Also I have replied which seems to be solution (property Support Framgmented Transactions as false in PutSql Processor) which seems to be helping. ... View more

an we know why are you using GET command to update the entity ?  is it typo ? ... View more

Hello, For the try.csv input, I've successfully configured it. However, what I didn't succeed is when I change the content of the input file to have strings at the front and the back of the words that need to be replaced. So my try.csv currently looks like this: (testing input file) and the output is like this: How do i fix this? This is my nifi setup currently: Thank you!   ... View more

@Adhitya, Did the response assist in resolving your query? If it did, kindly mark the relevant reply as the solution, as it will aid others in locating the answer more easily in the future. ... View more

@badsha, Did the response assist in resolving your query? If it did, kindly mark the relevant reply as the solution, as it will aid others in locating the answer more easily in the future.  ... View more

@smruti  I've validated it with the user, and here's what happens. The date field comes in string format and it only comes with 8 fields "Yyyy-mm-dd" and it was converting to time stamp which in this case aggregates the time fields, and that's where the divergence was. Is there anything in the tool that can be done to standardize this or do I need to change the data engineering? ... View more

I think this issue is caused by something else. My suspicion is a wrong behavior of org.apache.shiro.web.filter.InvalidRequestFilter (we are using). ... View more

@Seunggoo, did the response help resolve your query? If it did, kindly mark the relevant reply as the solution, as it will aid others in locating the answer more easily in the future.  ... View more