Re: Not able to ingest the csv data to RDBS Database

2017-05-03 Thread suman....@cuddle.ai
/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.

Re: Not able to ingest the csv data to RDBS Database

2017-05-03 Thread Matt Burgess
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.

Re: Not able to ingest the csv data to RDBS Database

2017-05-03 Thread suman....@cuddle.ai
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

Re: Not able to ingest the csv data to RDBS Database

2017-05-03 Thread Matt Burgess
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

Re: Not able to ingest the csv data to RDBS Database

2017-05-03 Thread suman....@cuddle.ai
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

Re: Not able to ingest the csv data to RDBS Database

2017-05-03 Thread suman....@cuddle.ai
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

Re: Not able to ingest the csv data to RDBS Database

2017-05-03 Thread suman....@cuddle.ai
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

Re: Not able to ingest the csv data to RDBS Database

2017-05-02 Thread Bryan Bende
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.

Not able to ingest the csv data to RDBS Database

2017-05-02 Thread suman....@cuddle.ai
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.