Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

How to name the out flow file of QueryDatabaseTableRecord

Rising Star

I have a configuration where the QueryDatabaseTableRecord queries the table from mysql, i have used RecordWriter as CSVRecordSetWriter and used CSV Format as Tab-Delimited.


I want to store this flowfile as table-name with the extension xlsx, any help really appreciated. 


@murali2425   After you get the data from QueryDatabaseTableRecord next use updateAttribute and set filename attribute accordingly. I think (${table-name}.xls) assuming you have the attribute table-name.   Next you would store the contents of flowfile (putFile, PutHDFS, S3 Bucket, etc).

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.