Member since
06-07-2018
23
Posts
1
Kudos Received
0
Solutions
07-04-2018
09:31 AM
Trying to insert data in postgresql database. In pgAdmin this statement is working. What's wrong?
... View more
Labels:
- Labels:
-
Apache NiFi
07-03-2018
09:17 AM
How can I parsing html file in nifi? I need remove the first two <table> and take data from every <th> in <tr>. Which processors I need to use and how? Example of a file structure on pic.
... View more
Labels:
- Labels:
-
Apache NiFi
06-27-2018
02:25 PM
Perfect! Thanks! I'll try QueryDatabaseTable for it. It'll be better!
... View more
06-27-2018
11:32 AM
Processor reads data from database an infinite number of times. How can I limit this so that he reads the data only once and does not repeat?
... View more
Labels:
- Labels:
-
Apache NiFi
06-27-2018
10:14 AM
Hello! Can't understand whats wrong... I've got processors group to take data from json to sql. When I try to "view as formatted" - I see this: Use SplitJson to split file after it use ReplaceText... and he doesn't work correctly. Unable to generate view of data: Unrecognized token 'INSERT': was expecting 'null', 'true', 'false' or NaN
at [Source: (BufferedInputStream); line: 1, column: 8"
... View more
Labels:
- Labels:
-
Apache NiFi
06-20-2018
12:26 PM
Files on FTP server. I got them with ListFTP and FetchFTP. Then I use RouteText(I think) to filter them by name. And after it I need to parsing data with divide into parts(with SplitContent, I'll try). And unload data on sql server with PutDatabaseRecord.
... View more
06-20-2018
10:32 AM
If you could show me an example, it would be rly nice, 'cause I don't quite understand the principle of action... Thanks!
... View more
06-19-2018
04:43 PM
I've got a data file that needs to be divided. Inside the text file, the sections are divided: # @ - the beginning of the section with data, # $ is the start of the data block, Next # means the end of the Section. How can I do it?
... View more
Labels:
- Labels:
-
Apache NiFi
06-19-2018
04:31 PM
I figured out how to add data from the server to the database *applause*. But the question arose: can I add an extra column with file name/id in the data that I load into the database to understand the data from which file I'm using. Mbe nifi got some processor toadd persistent data to each line before we take them into database?
... View more
Labels:
- Labels:
-
Apache NiFi
06-19-2018
10:22 AM
-- New day - new problem.
I download the CSV file into the InferAvroScheme to determine the scheme of the avro file.
After that file's sent to the ConvertCSVToAvro where it is converted.
1. InferAvroSchema incorrectly defines the scheme, outputting in a single cell all the values.
2. ConvertCSVToAvro "Cannot find schema", although I indicated ${inferred.avro.schema} in Record schema.
... View more
Labels:
- Labels:
-
Apache NiFi
06-18-2018
01:45 PM
Thanks, but it's not really what I wanted to know... What I need to specify in the field "remote file"? *and I use ListFTP before FetchFTP
... View more
06-18-2018
01:11 PM
I got a new problem... - can't understand what need to enter and in what format into "Remote File" in "FetchFTP" ...
... View more
Labels:
- Labels:
-
Apache NiFi
06-18-2018
08:35 AM
I'm using template from https://gist.github.com/ijokarumawak/b37db141b4d04c2da124c1a6d922f81f and see this error. Whats wrong?
... View more
Labels:
- Labels:
-
Apache NiFi
06-07-2018
11:02 AM
1 Kudo
And thanks again! I hope this will be enough for the first time.
... View more
06-07-2018
10:27 AM
Thx a lot! But I still got a few questions. If you can help - it will be perfect! At the output FetchFTP, we get a file of the CSV format?
... View more
06-07-2018
09:55 AM
Hi. It's my first days with nifi, so I need a lot of help! Firstly, I've got ftp from which I need to get data. After it need to parsing and processing data. And download them on sql database. P.S. As I understand, need to use ListFTP and FetchFTP to take data from ftp and transform them into FlowFile. But what after it? Which processors should I use? P.S.S. Hope clearly explained.
... View more
Labels:
- Labels:
-
Apache NiFi