<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question NiFi: Applying an Avro Schema in ConvertCSVToAvro in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/NiFi-Applying-an-Avro-Schema-in-ConvertCSVToAvro/m-p/148547#M111073</link>
    <description>&lt;P&gt;EDIT: I noticed that my REAL record schema was occasionally using integers as the name, and that violated the field name requirements for avro.  So, the schema worked once I added a character before the integers.&lt;/P&gt;&lt;P&gt;With NiFi's ConvertCSVToAvro, I have not found much guidance or example regarding the Record Schema Property.  The documentation says to use an Avro schema, and it seems like a canonical Avro schema does not work.  &lt;STRONG&gt;How do I set it up??&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;My efforts resulted in the caution symbol saying the message below, and the inability to actually use the processor.&lt;/P&gt;&lt;P&gt;'Record schema' validated against '&amp;lt;text of record schema&amp;gt;'&lt;/P&gt;&lt;P&gt;Here are the properties as I set them...&lt;/P&gt;&lt;P&gt;Record schema:&lt;/P&gt;&lt;PRE&gt;{
  "type": "record",
  "name": "sensor_data",
  "fields":
  [
    { "name": "TimeStamp", "type": "string"},
    { "name": "Sensor", "type": "string"},
    { "name": "Measure", "type": "string"},
    { "name": "MeasureValue", "type": ["int","null"], "default":"null"},
    { "name": "AdditionalInfo", "type": ["string","null"], "default":"null"}
  ]
}&lt;/PRE&gt;&lt;P&gt;CSV charset: utf8&lt;/P&gt;&lt;P&gt;CSV delimiter: |&lt;/P&gt;&lt;P&gt;CSV quote character: "&lt;/P&gt;&lt;P&gt;CSV escape character: \&lt;/P&gt;&lt;P&gt;Use CSV header line: false&lt;/P&gt;&lt;P&gt;Lines to skip: 0&lt;/P&gt;&lt;P&gt;Here's some sample data:&lt;/P&gt;&lt;PRE&gt;2016-02-01T00:03:09Z|Temp_1|TempF|212|"WARNING|Overheating"
2016-02-01T00:05:03Z|Power|N/A||"STATE_CHANGE|Active"
2016-02-02T12:30:00Z|EmployeeCount|0|&lt;/PRE&gt;</description>
    <pubDate>Fri, 19 Feb 2016 01:01:37 GMT</pubDate>
    <dc:creator>scardella</dc:creator>
    <dc:date>2016-02-19T01:01:37Z</dc:date>
  </channel>
</rss>

