/Not-able-to-ingest-the-csv-data-to-RDBS-Database-tp15610p15641.html
Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.
rently with a sample file containing only 4 rows.
>
>
>
> --
> View this message in context:
> http://apache-nifi-developer-list.39713.n7.nabble.com/Not-able-to-ingest-the-csv-data-to-RDBS-Database-tp15610p15637.html
> Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.
I am just testing currently with a sample file containing only 4 rows.
--
View this message in context:
http://apache-nifi-developer-list.39713.n7.nabble.com/Not-able-to-ingest-the-csv-data-to-RDBS-Database-tp15610p15637.html
Sent from the Apache NiFi Developer List mailing list archive at
in table.
>
> I tested with PutFile instead of PutSql and file contains
> INSERT INTO CITY(city,count) VALUES('city',count)
>
>
>
> --
> View this message in context:
> http://apache-nifi-developer-list.39713.n7.nabble.com/Not-able-to-ingest-the-csv-data-to-RDBS
SplitText by line 1 and header count 1
Extract Text : City : (.*),.*
Count : .*,(.*)
ReplaceText : INSERT INTO CITY(City,Count) values ('${City}',${Count})
--
View this message in context:
http://apache-nifi-developer-list.39713.n7.nabble.com/Not-able-to-inge
Still not able to insert the data in table.
I tested with PutFile instead of PutSql and file contains
INSERT INTO CITY(city,count) VALUES('city',count)
--
View this message in context:
http://apache-nifi-developer-list.39713.n7.nabble.com/Not-able-to-ingest-the-csv-data-to-RDB
specify the table name where the data needs to be
inserted.
The table needs to be present before?
My file
City,Count
Mumbai,10
Mumbai,10
Pune,10
Pune,10
--
View this message in context:
http://apache-nifi-developer-list.39713.n7.nabble.com/Not-able-to-ingest-the-csv-data-to-RDBS-Database-t
lp.
>
>
>
> --
> View this message in context:
> http://apache-nifi-developer-list.39713.n7.nabble.com/Not-able-to-ingest-the-csv-data-to-RDBS-Database-tp15610.html
> Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.
x27;${city}',${count})
Please help.
--
View this message in context:
http://apache-nifi-developer-list.39713.n7.nabble.com/Not-able-to-ingest-the-csv-data-to-RDBS-Database-tp15610.html
Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.