Re: NIFI - PUTSQL - sql.args.1.type

2019-09-23 Thread KhajaAsmath Mohammed
This link doesn’t have any value to integer or other types. It has comparison of data types between sql and java. Sent from my iPhone > On Sep 23, 2019, at 8:20 PM, Juan Pablo Gardella > wrote: > > The values of the constants defined at >

Re: NIFI - PUTSQL - sql.args.1.type

2019-09-23 Thread Juan Pablo Gardella
The values of the constants defined at https://docs.oracle.com/javase/8/docs/api/java/sql/Types.html On Mon, Sep 23, 2019, 8:10 PM Wesley C. Dias de Oliveira < wcdolive...@gmail.com> wrote: > Hi, KhajaAsmath. > > I've search it too but found nothing. > > I think it's more easy to observe the

Re: NIFI - PUTSQL - sql.args.1.type

2019-09-23 Thread Wesley C. Dias de Oliveira
Hi, KhajaAsmath. I've search it too but found nothing. I think it's more easy to observe the type based on your query. "mapping" the arguments with the query fields. Em seg, 23 de set de 2019 às 20:02, KhajaAsmath Mohammed < mdkhajaasm...@gmail.com> escreveu: > Hi, > > I have existing flow and

NIFI - PUTSQL - sql.args.1.type

2019-09-23 Thread KhajaAsmath Mohammed
Hi, I have existing flow and trying to understand what is sql.args.1.type ? sql.args.1.type =11 sql.args.1.type=13 I understood that they are matched to column data type for sql.args.1.value. what is data type for 11 and 13 ? May I know what are all the options availabe for String, Integer,

Setup x Ingestion tasks? Or how to create structures (tables) and load data (rows) in the same flow?

2019-09-23 Thread Márcio Sugar
Hi, I'm trying to replicate a number of tables from one database to another. I'd like the flow to take care of both the DDL ("create table if not exists ...") and DML ("insert") commands automatically. Ideally, the "create table" should be executed just once, before any insert for that same

RE: Need to DELETE large recordsets from target SQL table

2019-09-23 Thread David Gallagher
Thanks, Matt! This is going to work out well. Dave -Original Message- From: Matt Burgess Sent: Friday, September 20, 2019 5:14 PM To: users@nifi.apache.org Subject: Re: Need to DELETE large recordsets from target SQL table Dave, You can use ConvertRecord or JoltTransformRecord right

node died unexpectedly

2019-09-23 Thread Jean-Sebastien Vachon
Hi, I am running a cluster of five nodes and one of them just quit for no apparent reason... at least I could not find anything wrong on the system. Here is a section of the logs. You can clearly see that there is a 8 minutes gap before I manually had to restart Nifi. I've looked in