ExecuteSQLRecord - org.apache.avro.SchemaParseException:

Question

Hi ,Am using MSSQL version 12+ , I have connected to DB successfully . I could able to fetch the data eg : Select * from dbname.sys.tables But If i try to query fetch the table records using below processor   Getting below error  :

ckumar · Accepted Answer

This error has to do with the schema used in Record Writer controllers used by ExecuteSQLRecord.

I would validate the provided schema and check if it is in the correct Avro format as it Avro schema parser is complaining about an illegal character in the provided schema.

If you found this response assisted with your issue, please take a moment and click on "Accept as Solution" below this post.

Thank you

VidyaSargur · Answer

@swanifi, Welcome to our community! To help you get the best possible answer, I have tagged in our NiFi experts @ckumar @MattWho @SAMSAL @cotopaul may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.