Member since
06-30-2016
44
Posts
2
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1557 | 03-16-2018 01:56 PM |
07-09-2018
02:37 PM
Hello, I'm using the processor inferAvroSchema to infer the schema table from a csv. I want to use the GetAvroMetadata processor to extract the record name from the results of inferAvroSchema but I don't know how to configure the processor. I know that I can use a groovy code to extract the record name but I think GetAvroMetadata is used for this purpose too. capture.png Can someone help me plz. Thank you
... View more
Labels:
- Labels:
-
Apache NiFi
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
05-14-2018
09:28 AM
Hello @Rahul Soni, I set up a nifi registry but I could not connect it with my version nifi 1.4. The GUI does not offer me registry clients. Do you have a solution to unlock this problem ? Thank you
... View more