Cloudera Community
Announcements
We’ve updated our product names and community labels - click here for full details
grimcha
user rank
Frequent Visitor
My Accepted Solutions
Show All

Re: QueryDatabaseTableRecord converting varbinary ...

by Frequent Visitor in Support Questions
‎03-17-2026 09:11 AM
1 Kudo
‎03-17-2026 09:11 AM
1 Kudo
I have resolved this by forcing a CONVERT with a style of 1 to ensure binary output in the sql query with a 0x primer.  Documentation here: https://learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver17  ... View more

QueryDatabaseTableRecord converting varbinary colu...

by Frequent Visitor in Support Questions
‎03-17-2026 07:53 AM
‎03-17-2026 07:53 AM
Edit: Tried using CSVWriter, XMLWriter and AvroWriter. All NG.   Nifi Version 2.5.0 Processor QueryDatabaseTableRecord  Driver com.microsoft.sqlserver.jdbc.SQLServerDriver   I have a requirement to pull varbinary data from a table however the  output is always text.  I expect a result starting with 0x. According to the jdbc driver within nifi, varbinary is supported however I see it gets converted to bytes. Is there a way to maintain the 0x format for the writer?  Notes JDBC source for statement varbinary is supported at https://github.com/apache/nifi/blob/main/nifi-extension-bundles/nifi-extension-utils/nifi-database-utils/src/main/java/org/apache/nifi/util/db/JdbcCommon.java (line 360) ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎03-17-2026 07:36 AM
Community Statistics
Member Since ‎03-17-2026 07:36 AM
Last Visited ‎03-17-2026 07:36 AM
Posts 2
Kudos received 1