RE: CREATE TABLE code is generated automatically from csv.

2021-05-03 Thread Carlos Manuel Fernandes (DSI)
Hi Cristiano, Take a look on Nifi processor PutDatabaseRecord wich can read from a csv source (and others json, avro,ect) and put the records on a existent table on database. If you need to create a table based on the schema of CSV you probably need a custom script, take a look in this post:

Re: CREATE TABLE code is generated automatically from csv.

2021-05-03 Thread Cristiano Silva
Thank you Carlos. I used the Pentaho PDI (Pentaho Data Integration - Spoon). --- In Pentaho there is a block: Input / CSV file input. - this block, reads a CSV file, specifies the column names, specifies the data type of each column, that is, obtains the fields from the CSV file. --- Then