You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@nifi.apache.org by Srinath Thota <sr...@outlook.com> on 2017/02/16 20:49:49 UTC

ConvertJSONToSQL in combination with PutCassandraQL

Hi All,


For one of my requirements, I will get data in JSON and need to upload it to Cassandra. So, I have planned to use ConvertJSONToSQL processor to convert JSON to CQL and PutCassandraQL processor will execute those CQL statements for inserting the data. For this purpose, I have modified PutCassandraQL processor read attribute values to accept sql.args.N.value and sql.args.N.type instead of cql.args.N.value and cql.args.N.type. I also made few changes for type conversion in PutCassandraQL. The code is working fine.



Is there any alternate way, Where I can achieve my requirement without changing  PutCassandraQL processor code?


Thanks & Regards,

Srinath Thota

Re: ConvertJSONToSQL in combination with PutCassandraQL

Posted by Pierre Villard <pi...@gmail.com>.
Hi Srinath,

Not sure there is an alternate way. However I believe the changes you made
to get your use case working are interesting and we should think of a way
to get the changes in the processor. Would you mind filing a JIRA? and
maybe share your changes through a PR?

Thanks

2017-02-16 21:49 GMT+01:00 Srinath Thota <sr...@outlook.com>:

> Hi All,
>
>
> For one of my requirements, I will get data in JSON and need to upload it
> to Cassandra. So, I have planned to use ConvertJSONToSQL processor to
> convert JSON to CQL and PutCassandraQL processor will execute those CQL
> statements for inserting the data. For this purpose, I have modified PutCassandraQL
> processor read attribute values to accept sql.args.N.value and sql.args.N.type
> instead of cql.args.N.value and cql.args.N.type. I also made few changes
> for type conversion in PutCassandraQL. The code is working fine.
>
>
>
> Is there any alternate way, Where I can achieve my requirement without
> changing  PutCassandraQL processor code?
>
>
> Thanks & Regards,
>
> Srinath Thota
>