Member since
06-30-2016
44
Posts
2
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2329 | 03-16-2018 01:56 PM |
06-29-2018
10:30 AM
Hello, My dataflow is as follow: My purpose is to create a table from a csv file and then put the data in this table. Everything is working good but I need to check if the table is created before storing the csv file. So I used the Execute SQL to run this query: select count(table_name) from information_schema.tables where table_name='warranty' But it returns only the number of rows and not the flowfile. My test is if number of row is one so I execute the rest. So I need to use dataflow which can check if the table is well created and execute the other processors if not it stop every thing. Can you help me plz I know that i can find another way but don't find ideas. Thank you for your help.
... View more
Labels:
- Labels:
-
Apache NiFi
06-27-2018
09:33 AM
@Shu Thank you for your response when I tried this regex expression : ^[!@#$%^&*(),.?":{}|<>] It changed only the first occurance of a special character. I have in input this csv file : Name,T&C_Test,Date_of_(Transformation),date_/_of _deliverance 1,1457,26/12/2016,14/12/2017 2,4789,18/04/2017,03/09/2018 I expect an output file like this one: Name,TC_Test,Date_of_Transformation,date_of _deliverance 1,1457,26/12/2016,14/12/2017 2,4789,18/04/2017,03/09/2018
... View more
06-26-2018
12:08 PM
I tried with ^ at the beginning of the expression. No results 😕
... View more
06-25-2018
04:39 PM
Hello, The header of my csv file contains some special character. Example Name,T&C_Test,Date_of_(Transformation) And I want to use the processor Replace Text to edit only the header. When I use the Append Stratesy for the entire text, it dosen't work. Help plz. Thank you
... View more
Labels:
- Labels:
-
Apache NiFi
05-30-2018
08:48 AM
@Matt Burgess I have a csv file .. I will try this approach Thank you ! I accept this answer 🙂
... View more
05-29-2018
04:33 PM
@Matt Burgess Thank you for your response I'm using hive-jdbc-2.1.0.jar. So the processor PutDatabaseRecord does not offer the insert functionality wih a hive pool connection? if it is the case ,why this connection is proposed in the processor ? Can we do an update and delete query with PutDatabaseRecord + Hive ?
... View more
05-29-2018
02:59 PM
Hello, I'm using the processor PutDatabaseRecord with a Hive connection pool to insert data in my table. But I get the following error: Error : My log file : I used the same connection pool with putHiveQL and everything is working fine. Can someone help me plz? Thank you
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache NiFi
05-20-2018
10:54 AM
Hello, I have a timestamp column in my flowfile written in this way 2008:05:17 17:23:01. I want to add a quota to this value so i can insert it in postgresql table. I used replace text like this : search value : ((\d{4})([\-\/.])([0-3]?\d)\2([0-3]?\d)|([0-3]?\d)([\-\/.])([0-3]?\d)\6(\d{4}))(?:\s+([012]?\d)([:hap])([0-5]\d))([:hap])([0-5]\d) replacement value : ' ((\d{4})([\-\/.])([0-3]?\d)\2([0-3]?\d)|([0-3]?\d)([\-\/.])([0-3]?\d)\6(\d{4}))(?:\s+([012]?\d)([:hap])([0-5]\d))([:hap])([0-5]\d) ' but didn't work need ur help plz
... View more
Labels:
- Labels:
-
Apache NiFi
03-27-2018
09:06 AM
@Matt Burgess I tried a little test with listen http i made a ListenHttp processor as follows: Then I created a little python code: pythonreq.png I have an error: and I do not know if the configurations are correct
... View more
03-26-2018
03:47 PM
Hello, I want to be able to send automatically generated data with random from python to nifi using the requests library. on the nifi side I intend to use gethttp to retrieve the data. My question: what should I put in the URL parameter? I do not understand much t the APIs I searched on the internet since this morning but it remains a little vague someone can help me? thank you
... View more
Labels:
- Labels:
-
Apache NiFi