Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

PutDatabaseRecord and ARRAY type

Highlighted

PutDatabaseRecord and ARRAY type

New Contributor

I have spent a few days with NiFi trying to use ExecuteSQLRecord and PutDatabaseRecord (configured with AvroRecordsetWriter) to transfer data from one PostgreSQL table to another table. Everything works find until I include an array of float column. The error shown in PutDatabaseRecord was "Cannot cast an instance of Ljavalang.Object to type Types.ARRAY"

Can anyone show me an example of how to make PutDatabaseRecord work with an array column in Postgresql database?

 

Thanks,

Andy

2 REPLIES 2

Re: PutDatabaseRecord and ARRAY type

New Contributor

Hi experts,

Could anyone shed some light on this? Or this is not yet supported?

Thanks.

Highlighted

Re: PutDatabaseRecord and ARRAY type

@AndyL Can you update original post or reply with screenshots of the Processor Configuration and Record Reader Configuration (including avro schemas)?   

 


 


If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.  


 


Thanks,



Steven

Don't have an account?
Coming from Hortonworks? Activate your account here