RE: ConverJsonToSql issue

[Gadiputi, Sravani]

Hi Toivo,

Thanks for your reply.

Yes, error message contain database name and table name(database.table)

But names of the fields are same and I tried  with option “Translate Field 
Names” also but facing same issue.

GetFile-->Split-->InferAvroSchema-->convertCsvtoAvro-->ConvertAvroToJson-->ConvertJsonToSQL-->PutSQL-->LogAttribute

Please suggest me.

Thanks,
Sravani

From: Toivo Adams [mailto:toivo.ad...@gmail.com]
Sent: Friday, January 20, 2017 7:23 PM
To: users@nifi.apache.org
Subject: Re: ConverJsonToSql issue

Hi Sravani,

Weird, error message should also contain database table name.
It seems none of the database table column names match with JSON field names.
If names are different, you can use "Translate Field Names" property to specify 
mappings.

Regards,
Toivo

2017-01-20 12:04 GMT+02:00 Gadiputi, Sravani 
>:
Hi Team,

I am facing the issue with ConverJsonToSql processor in Nifi.

I am trying to read the csv file and load the data in to Teradata table.

My flow is look like below:

GetFile-->Split-->convertCsvtoAvro-->ConvertAvroToJson--->ConvertJsonToSQL-->PutSQL-->LogAttribute

When it  comes to convertJsonToSql, it is not able to map the JSON fields with 
table field.

Error:

Failed to convert Slandered Flowfile record and None of the fields in the JSON 
map to the columns defined by the table.


Any ideas/suggestions to resolve this?

Thanks in Advance!!

Regards,
Sravani





This message contains information that may be privileged or confidential and is 
the property of the Capgemini Group. It is intended only for the person to whom 
it is addressed. If you are not the intended recipient, you are not authorized 
to read, print, retain, copy, disseminate, distribute, or use this message or 
any part thereof. If you receive this message in error, please notify the 
sender immediately and delete all copies of this message.

How to download HTTP Content with multiple years in GetHTTP Processor or any processor?

[prabhu Mahendran]

I have HTTP_URL which having file in year basis(2000-2010).

In GetHTTP Processor(NiFi-0.6.1), i have given below to url to download
data for particular year like below.,

*http:\\myurl.com \year=2000*

It can download the file which i need in particular year 2000.

But now my case i need to download files in years from 2000 to 2010.

So i need to download all data's in single GetHTTP Processor.If i use
multiple processors by give year with 2000 to 2010 then it works.

I have to use single processor which updates year in url from 2000-2010 to
download data's in year wise.

Is this possible to download content across multiple years in single
processor?

Please stop me if anything am doing wrong.

Re: nifi at AWS

[Andrew Grande]

Isn't it more advisable to use the HTTP mode instead, i.e. no additional
ports to open? Make sure to change the client RPG mode to http from RAW (in
the UI).

Andrew

On Sun, Jan 22, 2017, 10:47 AM Bryan Bende  wrote:

> Hello,
>
> I'm assuming you are using site-to-site since you mentioned failing to
> create a transaction.
>
> In nifi.properties on the AWS instance, there is probably a value for  
> nifi.remote.input.socket.port
> which would also need to be opened.
>
> -Bryan
>
> On Sat, Jan 21, 2017 at 7:00 PM, mohammed shambakey 
> wrote:
>
> Hi
>
> I'm trying to send a file from a local nifi instatnce to a remote nifi
> instance in AWS. Security rules at remote instance has port 8080 opened,
> yet each time I try to send the file, local nifi says it failed to create
> transaction to the remote instance.
>
> Regards
>
> --
> Mohammed
>
>
>

Re: nifi at AWS

[Bryan Bende]

Hello,

I'm assuming you are using site-to-site since you mentioned failing to
create a transaction.

In nifi.properties on the AWS instance, there is probably a value for
nifi.remote.input.socket.port which would also need to be opened.

-Bryan

On Sat, Jan 21, 2017 at 7:00 PM, mohammed shambakey 
wrote:

> Hi
>
> I'm trying to send a file from a local nifi instatnce to a remote nifi
> instance in AWS. Security rules at remote instance has port 8080 opened,
> yet each time I try to send the file, local nifi says it failed to create
> transaction to the remote instance.
>
> Regards
>
> --
> Mohammed
>