You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@nifi.apache.org by prabhu Mahendran <pr...@gmail.com> on 2018/02/14 06:14:31 UTC

Is this possible to create table from JSON?

Hi All,

I can able to get avro schema from json.

It could be look like below.

{
"type" : "array",
"items" : {
"type" : "record",
"name" : "AvroSchema",
"fields" : [
{
"name" : "Name",
"type" : "String",
"doc" : "Type inferred from 'S'"
},
{ "name" : "Age",
"type" : "int", "doc" : "Type inferred from '23'"
}
}
}

With help of that, i should extract fields(name & type) and create table in
DB from that schema.

Can any one suggest me the best way to create table in SQL Server from NiFi
based on avro schema?