About baiology

baiology · ‎09-20-2018

@Shu Ok, I will try that Shu. Hope it will load this time.

baiology · ‎09-11-2018

Hi Shu, I'm getting an error for PutDatabaseRecord though i think my settings are correct. Not sure where it failed. Here's my flow: UpdateAttribute: CSV Reader: Avro Schema Registry Tables: @Shu

baiology · ‎09-11-2018

Got it now, does this work the same way as the PutDatabaseRecord as well?

baiology · ‎09-05-2018

Hi Shu, thank you for your response. How can map the columns in my input file as the attribute? For example my insert statement is "Insert into employee values(?,?,?)" how can I replace it (question marks) with the columns in my input file to that statement?

baiology · ‎08-27-2018

How did you do it in nifi? Do you have screenshot on how did you do it?

baiology · ‎08-27-2018

Does regexr.com validates if your Nifi expression is valid as well?

baiology · ‎08-27-2018

I have a CSV flowfile below as an example and I want to pass each record to a variable/attribute to form a INSERT sql statement using ReplaceText processor then PutDatabase to write in the table. My flow is, Getfile > ExtractText > ReplaceText > PutDatabaseRecord Or is it better to use CSVReader instead then PutDatabaseRecord? which one is faster? CSV: id,fname,lname 1,John,Doe 2,Jane,Doe

Online	Offline
Last Visited	‎09-20-2018 01:13 AM

Member Since	‎08-27-2018 05:42 AM
Last Visited	‎09-20-2018 01:13 AM
Posts	9

Cloudera Community

Re: How to use ReplaceText processor in Nifi to re...

Re: How to use ReplaceText processor in Nifi to re...

Re: How to use ReplaceText processor in Nifi to re...

Re: How to use ReplaceText processor in Nifi to re...

Re: Design Pattern - NiFi Flow for Using PutSQL pr...

Re: Hi, where can i find the rules of nifi's regex...

How to use ReplaceText processor in Nifi to replac...