<?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 Re: How to create hive table entity in Apache atlas using REST  API? in Archives of Support Questions (Read Only)</title>
    <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173659#M50306</link>
    <description>&lt;P&gt;Please first validate your JSON using &lt;A target="_blank" href="https://jsonformatter.org"&gt;JSON Formatter and JSON Validator&lt;/A&gt;.&lt;/P&gt;</description>
    <pubDate>Tue, 23 May 2017 15:31:26 GMT</pubDate>
    <dc:creator>jimmi_prajapati</dc:creator>
    <dc:date>2017-05-23T15:31:26Z</dc:date>
    <item>
      <title>How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173644#M50291</link>
      <description>&lt;P&gt;Hi All,&lt;/P&gt;&lt;P&gt;I searched everywhere on internet but I don't find anywhere example to create "hive table" entity using REST API.Here the problem is that,I am very much confused on creating json body for REST api call.&lt;/P&gt;&lt;P&gt;Please send complete REST API call example &lt;STRONG&gt;with curl and json body&lt;/STRONG&gt; to create hive table entity?&lt;/P&gt;&lt;P&gt;and also please send example to create&lt;STRONG&gt; lineage link&lt;/STRONG&gt; between two datasets in Apache atlas?&lt;/P&gt;</description>
      <pubDate>Wed, 28 Dec 2016 17:30:51 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173644#M50291</guid>
      <dc:creator>Manus</dc:creator>
      <dc:date>2016-12-28T17:30:51Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173645#M50292</link>
      <description>&lt;P&gt;&lt;A rel="user" href="https://community.cloudera.com/users/10447/manoj-dhake.html" nodeid="10447" target="_blank"&gt;@Manoj Dhake&lt;/A&gt;&lt;/P&gt;&lt;P&gt;Hive table entity can be created using /atlas/api/entites REST call. &lt;/P&gt;&lt;P&gt;One such example is:&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Step1: JSON for creating table1:&lt;/STRONG&gt;&lt;/P&gt;&lt;PRE&gt;[{
  "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
  "id":{
    "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
    "id":"-11893021824425525",
    "version":0,
    "typeName":"hive_db",
    "state":"ACTIVE"
  },
  "typeName":"hive_db",
  "values":{
    "name":"default",
    "location":"hdfs://mycluster/apps/hive/warehouse",
    "description":"Default Hive database",
    "ownerType":2,
    "qualifiedName":"default@cl1",
    "owner":"public",
    "clusterName":"cl1",
    "parameters":{
 
 
    }
  },
  "traitNames":[
 
 
  ],
  "traits":{
 
 
  }
},{
  "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
  "id":{
    "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
    "id":"-11893021824425524",
    "version":0,
    "typeName":"hive_table",
    "state":"ACTIVE"
  },
  "typeName":"hive_table",
  "values":{
    "tableType":"MANAGED_TABLE",
    "name":"table1",
    "createTime":"2016-12-28T09:34:53.000Z",
    "temporary":false,
    "db":{
      "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
      "id":{
        "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
        "id":"-11893021824425525",
        "version":0,
        "typeName":"hive_db",
        "state":"ACTIVE"
      },
      "typeName":"hive_db",
      "values":{
        "name":"default",
        "location":"hdfs://mycluster/apps/hive/warehouse",
        "description":"Default Hive database",
        "ownerType":2,
        "qualifiedName":"default@cl1",
        "owner":"public",
        "clusterName":"cl1",
        "parameters":{
 
 
        }
      },
      "traitNames":[
 
 
      ],
      "traits":{
 
 
      }
    },
    "retention":0,
    "qualifiedName":"default.table1@cl1",
    "columns":[
      {
        "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
        "id":{
          "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
          "id":"-11893021824425522",
          "version":0,
          "typeName":"hive_column",
          "state":"ACTIVE"
        },
        "typeName":"hive_column",
        "values":{
          "name":"abc",
          "qualifiedName":"default.table1.abc@cl1",
          "owner":"hive",
          "type":"string",
          "table":{
            "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
            "id":"-11893021824425524",
            "version":0,
            "typeName":"hive_table",
            "state":"ACTIVE"
          }
        },
        "traitNames":[
 
 
        ],
        "traits":{
 
 
        }
      }
    ],
    "lastAccessTime":"2016-12-28T09:34:53.000Z",
    "owner":"hive",
    "sd":{
      "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
      "id":{
        "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
        "id":"-11893021824425523",
        "version":0,
        "typeName":"hive_storagedesc",
        "state":"ACTIVE"
      },
      "typeName":"hive_storagedesc",
      "values":{
        "location":"hdfs://mycluster/apps/hive/warehouse/table1",
        "serdeInfo":{
          "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
          "typeName":"hive_serde",
          "values":{
            "serializationLib":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe",
            "parameters":{
              "serialization.format":"1"
            }
          }
        },
        "qualifiedName":"default.table1@cl1_storage",
        "outputFormat":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat",
        "compressed":false,
        "numBuckets":-1,
        "inputFormat":"org.apache.hadoop.mapred.TextInputFormat",
        "parameters":{
 
 
        },
        "storedAsSubDirectories":false,
        "table":{
          "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
          "id":"-11893021824425524",
          "version":0,
          "typeName":"hive_table",
          "state":"ACTIVE"
        }
      },
      "traitNames":[
 
 
      ],
      "traits":{
 
 
      }
    },
    "parameters":{
      "rawDataSize":"0",
      "numFiles":"0",
      "transient_lastDdlTime":"1482917693",
      "totalSize":"0",
      "COLUMN_STATS_ACCURATE":"{\"BASIC_STATS\":\"true\"}",
      "numRows":"0"
    },
    "partitionKeys":[
 
 
    ]
  },
  "traitNames":[
 
 
  ],
  "traits":{
 
 
  }
}]
&lt;/PRE&gt;&lt;P&gt;Save the above json to a file.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Step2: REST API call to create the hive table entity.&lt;/STRONG&gt;&lt;/P&gt;&lt;PRE&gt;curl -v -H 'Accept: application/json, text/plain, */*' -H 'Content-Type: application/json;  charset=UTF-8' -u admin:admin -d @sample.json &lt;A href="http://&amp;lt;IP_ADDRESS&amp;gt;:21000/api/atlas/entities" target="_blank" rel="nofollow noopener noreferrer"&gt;http://&amp;lt;IP_ADDRESS&amp;gt;:21000/api/atlas/entities&lt;/A&gt;&lt;/PRE&gt;&lt;P&gt;The above will help in creating a hive table entity. &lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;
&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Step3: JSON for creating table2:&lt;/STRONG&gt;&lt;/P&gt;&lt;PRE&gt;[{
  "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
  "id":{
    "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
    "id":"-11893021824425525",
    "version":0,
    "typeName":"hive_db",
    "state":"ACTIVE"
  },
  "typeName":"hive_db",
  "values":{
    "name":"default",
    "location":"hdfs://mycluster/apps/hive/warehouse",
    "description":"Default Hive database",
    "ownerType":2,
    "qualifiedName":"default@cl1",
    "owner":"public",
    "clusterName":"cl1",
    "parameters":{
 
 
    }
  },
  "traitNames":[
 
 
  ],
  "traits":{
 
 
  }
},{
  "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
  "id":{
    "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
    "id":"-11893021824425524",
    "version":0,
    "typeName":"hive_table",
    "state":"ACTIVE"
  },
  "typeName":"hive_table",
  "values":{
    "tableType":"MANAGED_TABLE",
    "name":"table2",
    "createTime":"2016-12-28T09:34:53.000Z",
    "temporary":false,
    "db":{
      "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
      "id":{
        "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
        "id":"-11893021824425525",
        "version":0,
        "typeName":"hive_db",
        "state":"ACTIVE"
      },
      "typeName":"hive_db",
      "values":{
        "name":"default",
        "location":"hdfs://mycluster/apps/hive/warehouse",
        "description":"Default Hive database",
        "ownerType":2,
        "qualifiedName":"default@cl1",
        "owner":"public",
        "clusterName":"cl1",
        "parameters":{
 
 
        }
      },
      "traitNames":[
 
 
      ],
      "traits":{
 
 
      }
    },
    "retention":0,
    "qualifiedName":"default.table2@cl1",
    "columns":[
      {
        "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
        "id":{
          "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
          "id":"-11893021824425522",
          "version":0,
          "typeName":"hive_column",
          "state":"ACTIVE"
        },
        "typeName":"hive_column",
        "values":{
          "name":"abc",
          "qualifiedName":"default.table2.abc@cl1",
          "owner":"hive",
          "type":"string",
          "table":{
            "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
            "id":"-11893021824425524",
            "version":0,
            "typeName":"hive_table",
            "state":"ACTIVE"
          }
        },
        "traitNames":[
 
 
        ],
        "traits":{
 
 
        }
      }
    ],
    "lastAccessTime":"2016-12-28T09:34:53.000Z",
    "owner":"hive",
    "sd":{
      "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
      "id":{
        "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
        "id":"-11893021824425523",
        "version":0,
        "typeName":"hive_storagedesc",
        "state":"ACTIVE"
      },
      "typeName":"hive_storagedesc",
      "values":{
        "location":"hdfs://mycluster/apps/hive/warehouse/table2",
        "serdeInfo":{
          "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
          "typeName":"hive_serde",
          "values":{
            "serializationLib":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe",
            "parameters":{
              "serialization.format":"1"
            }
          }
        },
        "qualifiedName":"default.table2@cl1_storage",
        "outputFormat":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat",
        "compressed":false,
        "numBuckets":-1,
        "inputFormat":"org.apache.hadoop.mapred.TextInputFormat",
        "parameters":{
 
 
        },
        "storedAsSubDirectories":false,
        "table":{
          "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
          "id":"-11893021824425524",
          "version":0,
          "typeName":"hive_table",
          "state":"ACTIVE"
        }
      },
      "traitNames":[
 
 
      ],
      "traits":{
 
 
      }
    },
    "parameters":{
      "rawDataSize":"0",
      "numFiles":"0",
      "transient_lastDdlTime":"1482917693",
      "totalSize":"0",
      "COLUMN_STATS_ACCURATE":"{\"BASIC_STATS\":\"true\"}",
      "numRows":"0"
    },
    "partitionKeys":[
 
 
    ]
  },
  "traitNames":[
 
 
  ],
  "traits":{
 
 
  }
}]
&lt;/PRE&gt;&lt;P&gt;Save the above json to a file.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Step4: Repeat step2 with step3 json&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Step5: JSON to create lineage between above two hive tables:&lt;/STRONG&gt;&lt;/P&gt;&lt;PRE&gt;[{
  "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
  "id":{
    "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
    "id":"-11893021824425513",
    "version":0,
    "typeName":"hive_process",
    "state":"ACTIVE"
  },
  "typeName":"hive_process",
  "values":{
    "queryId":"hive_20161228094619_81b13647-4f7f-4f1b-9c08-0f64eb8dbb34",
    "name":"create table table2 as select * from table1",
    "startTime":"2016-12-28T09:46:19.003Z",
    "queryPlan":{
 
 
    },
    "operationType":"CREATETABLE_AS_SELECT",
    "outputs":[
      {
        "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
        "id":{
          "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
          "id":"-11893021824425516",
          "version":0,
          "typeName":"hive_table",
          "state":"ACTIVE"
        },
        "typeName":"hive_table",
        "values":{
          "tableType":"MANAGED_TABLE",
          "name":"table2",
          "createTime":"2016-12-28T09:46:30.000Z",
          "temporary":false,
          "db":{
            "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
            "id":{
              "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
              "id":"-11893021824425517",
              "version":0,
              "typeName":"hive_db",
              "state":"ACTIVE"
            },
            "typeName":"hive_db",
            "values":{
              "name":"default",
              "location":"hdfs://mycluster/apps/hive/warehouse",
              "description":"Default Hive database",
              "ownerType":2,
              "qualifiedName":"default@cl1",
              "owner":"public",
              "clusterName":"cl1",
              "parameters":{
 
 
              }
            },
            "traitNames":[
 
 
            ],
            "traits":{
 
 
            }
          },
          "retention":0,
          "qualifiedName":"default.table2@cl1",
          "columns":[
            {
              "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
              "id":{
                "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
                "id":"-11893021824425514",
                "version":0,
                "typeName":"hive_column",
                "state":"ACTIVE"
              },
              "typeName":"hive_column",
              "values":{
                "name":"abc",
                "qualifiedName":"default.table2.abc@cl1",
                "owner":"hive",
                "type":"string",
                "table":{
                  "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
                  "id":"-11893021824425516",
                  "version":0,
                  "typeName":"hive_table",
                  "state":"ACTIVE"
                }
              },
              "traitNames":[
 
 
              ],
              "traits":{
 
 
              }
            }
          ],
          "lastAccessTime":"2016-12-28T09:46:30.000Z",
          "owner":"hive",
          "sd":{
            "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
            "id":{
              "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
              "id":"-11893021824425515",
              "version":0,
              "typeName":"hive_storagedesc",
              "state":"ACTIVE"
            },
            "typeName":"hive_storagedesc",
            "values":{
              "location":"hdfs://mycluster/apps/hive/warehouse/table2",
              "serdeInfo":{
                "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
                "typeName":"hive_serde",
                "values":{
                  "serializationLib":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe",
                  "parameters":{
                    "serialization.format":"1"
                  }
                }
              },
              "qualifiedName":"default.table2@cl1_storage",
              "outputFormat":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat",
              "compressed":false,
              "numBuckets":-1,
              "inputFormat":"org.apache.hadoop.mapred.TextInputFormat",
              "parameters":{
 
 
              },
              "storedAsSubDirectories":false,
              "table":{
                "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
                "id":"-11893021824425516",
                "version":0,
                "typeName":"hive_table",
                "state":"ACTIVE"
              }
            },
            "traitNames":[
 
 
            ],
            "traits":{
 
 
            }
          },
          "parameters":{
            "rawDataSize":"0",
            "numFiles":"0",
            "transient_lastDdlTime":"1482918390",
            "totalSize":"0",
            "COLUMN_STATS_ACCURATE":"{\"BASIC_STATS\":\"true\"}",
            "numRows":"0"
          },
          "partitionKeys":[
 
 
          ]
        },
        "traitNames":[
 
 
        ],
        "traits":{
 
 
        }
      }
    ],
    "endTime":"2016-12-28T09:46:31.211Z",
    "recentQueries":[
      "create table table2 as select * from table1"
    ],
    "inputs":[
      {
        "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
        "id":{
          "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
          "id":"-11893021824425520",
          "version":0,
          "typeName":"hive_table",
          "state":"ACTIVE"
        },
        "typeName":"hive_table",
        "values":{
          "tableType":"MANAGED_TABLE",
          "name":"table1",
          "createTime":"2016-12-28T09:34:53.000Z",
          "temporary":false,
          "db":{
            "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
            "id":{
              "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
              "id":"-11893021824425521",
              "version":0,
              "typeName":"hive_db",
              "state":"ACTIVE"
            },
            "typeName":"hive_db",
            "values":{
              "name":"default",
              "location":"hdfs://mycluster/apps/hive/warehouse",
              "description":"Default Hive database",
              "ownerType":2,
              "qualifiedName":"default@cl1",
              "owner":"public",
              "clusterName":"cl1",
              "parameters":{
 
 
              }
            },
            "traitNames":[
 
 
            ],
            "traits":{
 
 
            }
          },
          "retention":0,
          "qualifiedName":"default.table1@cl1",
          "columns":[
            {
              "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
              "id":{
                "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
                "id":"-11893021824425518",
                "version":0,
                "typeName":"hive_column",
                "state":"ACTIVE"
              },
              "typeName":"hive_column",
              "values":{
                "name":"abc",
                "qualifiedName":"default.table1.abc@cl1",
                "owner":"hive",
                "type":"string",
                "table":{
                  "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
                  "id":"-11893021824425520",
                  "version":0,
                  "typeName":"hive_table",
                  "state":"ACTIVE"
                }
              },
              "traitNames":[
 
 
              ],
              "traits":{
 
 
              }
            }
          ],
          "lastAccessTime":"2016-12-28T09:34:53.000Z",
          "owner":"hive",
          "sd":{
            "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference",
            "id":{
              "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
              "id":"-11893021824425519",
              "version":0,
              "typeName":"hive_storagedesc",
              "state":"ACTIVE"
            },
            "typeName":"hive_storagedesc",
            "values":{
              "location":"hdfs://mycluster/apps/hive/warehouse/table1",
              "serdeInfo":{
                "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
                "typeName":"hive_serde",
                "values":{
                  "serializationLib":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe",
                  "parameters":{
                    "serialization.format":"1"
                  }
                }
              },
              "qualifiedName":"default.table1@cl1_storage",
              "outputFormat":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat",
              "compressed":false,
              "numBuckets":-1,
              "inputFormat":"org.apache.hadoop.mapred.TextInputFormat",
              "parameters":{
 
 
              },
              "storedAsSubDirectories":false,
              "table":{
                "jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Id",
                "id":"-11893021824425520",
                "version":0,
                "typeName":"hive_table",
                "state":"ACTIVE"
              }
            },
            "traitNames":[
 
 
            ],
            "traits":{
 
 
            }
          },
          "parameters":{
            "rawDataSize":"0",
            "numFiles":"0",
            "transient_lastDdlTime":"1482917693",
            "totalSize":"0",
            "COLUMN_STATS_ACCURATE":"{\"BASIC_STATS\":\"true\"}",
            "numRows":"0"
          },
          "partitionKeys":[
 
 
          ]
        },
        "traitNames":[
 
 
        ],
        "traits":{
 
 
        }
      }
    ],
    "qualifiedName":"default.table2@cl1:1482918390000",
    "queryText":"create table table2 as select * from table1",
    "clusterName":"cl1",
    "userName":"hive"
  },
  "traitNames":[
 
 
  ],
  "traits":{
 
 
  }
}]

&lt;/PRE&gt;&lt;P&gt;Save the above json to a file.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Step6: Repeat step2 with step5 json&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Step7: You should be able to visualize the lineage between two entities.&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="10864-atlas-2016-12-28-16-47-13.png" style="width: 2134px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/19955iC928517CF4AF41EC/image-size/medium?v=v2&amp;amp;px=400" role="button" title="10864-atlas-2016-12-28-16-47-13.png" alt="10864-atlas-2016-12-28-16-47-13.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;The curl call will be same as the above.&lt;/P&gt;</description>
      <pubDate>Sun, 18 Aug 2019 10:27:32 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173645#M50292</guid>
      <dc:creator>apathan</dc:creator>
      <dc:date>2019-08-18T10:27:32Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173646#M50293</link>
      <description>&lt;P&gt;Thank you Ayub,&lt;/P&gt;&lt;P&gt;Is above json structure is only for creating hive table entity?&lt;/P&gt;&lt;P&gt;Consider my database is already created and now I just need to create hive table entity&lt;/P&gt;</description>
      <pubDate>Wed, 28 Dec 2016 18:04:29 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173646#M50293</guid>
      <dc:creator>Manus</dc:creator>
      <dc:date>2016-12-28T18:04:29Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173647#M50294</link>
      <description>&lt;P&gt;Hi Ayub,&lt;/P&gt;&lt;P&gt;If we paste the above json data for creating hive entity in json validator there I am getting error as "multiple json root element".&lt;/P&gt;&lt;P&gt;Json Validator url:&lt;/P&gt;&lt;P&gt;&lt;A href="https://jsonformatter.curiousconcept.com/" target="_blank"&gt;https://jsonformatter.curiousconcept.com/&lt;/A&gt;&lt;/P&gt;&lt;P&gt;I think you have sent wrong json structure.&lt;/P&gt;</description>
      <pubDate>Wed, 28 Dec 2016 18:55:11 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173647#M50294</guid>
      <dc:creator>Manus</dc:creator>
      <dc:date>2016-12-28T18:55:11Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173648#M50295</link>
      <description>&lt;P&gt;&lt;A rel="user" href="https://community.cloudera.com/users/10447/manoj-dhake.html" nodeid="10447"&gt;@Manoj Dhake&lt;/A&gt; I have updated the answer with more details, please check and let me know if it works.&lt;/P&gt;&lt;P&gt;This time I have validated the json structure &lt;span class="lia-unicode-emoji" title=":slightly_smiling_face:"&gt;🙂&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 28 Dec 2016 19:24:14 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173648#M50295</guid>
      <dc:creator>apathan</dc:creator>
      <dc:date>2016-12-28T19:24:14Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173649#M50296</link>
      <description>&lt;P&gt;As I was seeing frequent questions on REST API usage to create entity and lineage I have posted it as an HCC article.&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.hortonworks.com/content/kbentry/74919/how-to-create-hive-table-and-lineage-using-rest-ap.html" target="_blank"&gt;https://community.hortonworks.com/content/kbentry/74919/how-to-create-hive-table-and-lineage-using-rest-ap.html&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 28 Dec 2016 19:59:39 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173649#M50296</guid>
      <dc:creator>apathan</dc:creator>
      <dc:date>2016-12-28T19:59:39Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173650#M50297</link>
      <description>&lt;P&gt;Thank you for reply Ayub,&lt;/P&gt;&lt;P&gt;I am trying to create entity using above json and within json I just have changed &lt;STRONG&gt;"mycluster" and "cl1" with my own cluster values but getting below error:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;STRONG&gt;&lt;/STRONG&gt;&lt;STRONG&gt;&lt;/STRONG&gt;&lt;STRONG&gt;&lt;P&gt;{"error":"For field 'tableName'","stackTrace":"org.apache.atlas.typesystem.types.ValueConversionException$NullConversionException: For field 'tableName'&lt;/P&gt;&lt;/STRONG&gt;</description>
      <pubDate>Wed, 28 Dec 2016 20:13:40 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173650#M50297</guid>
      <dc:creator>Manus</dc:creator>
      <dc:date>2016-12-28T20:13:40Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173651#M50298</link>
      <description>&lt;P&gt;&lt;A href="https://community.hortonworks.com/users/10447/manoj-dhake.html"&gt;@Manoj Dhake&lt;/A&gt; Which HDP version are you using? This JSON would work with HDP-2.5.x release.&lt;/P&gt;</description>
      <pubDate>Wed, 28 Dec 2016 20:28:04 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173651#M50298</guid>
      <dc:creator>apathan</dc:creator>
      <dc:date>2016-12-28T20:28:04Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173652#M50299</link>
      <description>&lt;P&gt;Ok i was using hdp2.4 hdp sandbox ,so i will try this json on HDP 2.5 &lt;/P&gt;</description>
      <pubDate>Wed, 28 Dec 2016 22:59:01 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173652#M50299</guid>
      <dc:creator>Manus</dc:creator>
      <dc:date>2016-12-28T22:59:01Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173653#M50300</link>
      <description>&lt;P&gt;Thank you Ayub,&lt;/P&gt;&lt;P&gt;I checked your json on HDP 2.5 and it's working fine their.&lt;/P&gt;</description>
      <pubDate>Thu, 29 Dec 2016 13:50:59 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173653#M50300</guid>
      <dc:creator>Manus</dc:creator>
      <dc:date>2016-12-29T13:50:59Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173654#M50301</link>
      <description>&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hi Ayub,&lt;/P&gt;&lt;P&gt;As we have created two dataset entities and set the lineage between them also,now my requirement is like ,&lt;/P&gt;&lt;P&gt;Consider I have already created hive table using hive query(i.e. patient_info_raw), it's metadata is also present in atlas repository and now I want to create lineage between this existing dataset and the one which I will create by using POST api (i.e. patient_validated_info).&lt;/P&gt;&lt;P&gt;so &lt;STRONG&gt;what changes I need to make in json file of lineage data (i.e.  in 3rd step)? so that I can see the lineage&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;I can create third table(i.e. hive_entity) by using same json file that is fine but what about json data for lineage?&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;How can I link them from patient_info_raw---&amp;gt;patient_validated_info.&lt;/STRONG&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 29 Dec 2016 18:35:01 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173654#M50301</guid>
      <dc:creator>Manus</dc:creator>
      <dc:date>2016-12-29T18:35:01Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173655#M50302</link>
      <description>&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hi Ayub,&lt;/P&gt;&lt;P&gt;As we have created two dataset entities and set the lineage between them also.&lt;/P&gt;&lt;P&gt;Consider I have already created hive table(i.e .patient_raw_info) and it's metadata is also present in atlas and now I want to create lineage between already exist dataset(i.e. patient_raw_info) and the one which I will going to create by using your REST  API (i.e. patient_validated_dataset) so my question is &lt;/P&gt;&lt;P&gt;How can I create hive_process between already exist dataset and the other one?&lt;/P&gt;&lt;P&gt; &lt;STRONG&gt;what changes I need to make in json file which we are using to create hive_process (i.e.  lineage) ?&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;I can create third table(i.e. hive_entity) by using same json file that is fine but what about json data for lineage?&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;How can I link them from, &lt;/STRONG&gt;&lt;/P&gt;&lt;STRONG&gt;&lt;/STRONG&gt;&lt;STRONG&gt;&lt;/STRONG&gt;&lt;STRONG&gt;&lt;P&gt;patient_raw_info---&amp;gt;patient_validated_dataset&lt;/P&gt;&lt;/STRONG&gt;</description>
      <pubDate>Thu, 29 Dec 2016 19:16:11 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173655#M50302</guid>
      <dc:creator>Manus</dc:creator>
      <dc:date>2016-12-29T19:16:11Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173656#M50303</link>
      <description>&lt;P&gt;&lt;A rel="user" href="https://community.cloudera.com/users/10447/manoj-dhake.html" nodeid="10447"&gt;@Manoj Dhake&lt;/A&gt; Currently the hive process json links table1 and table2. For creating lineage between table2 and table3: in the json change table1 references to table2 and table2 references to table3 and submit the json.&lt;/P&gt;&lt;P&gt;This should create lineage like table1--&amp;gt;table2--&amp;gt;table3&lt;/P&gt;</description>
      <pubDate>Thu, 29 Dec 2016 19:22:14 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173656#M50303</guid>
      <dc:creator>apathan</dc:creator>
      <dc:date>2016-12-29T19:22:14Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173657#M50304</link>
      <description>&lt;P&gt;Hi Ayub,&lt;/P&gt;&lt;P&gt;I am able to set lineage between table1 and table2 successfully but now my requirement like,&lt;/P&gt;&lt;P&gt;Consider,I already have created hive table using hive query, it's metadata is also present in altas  and I want to link  or create lineage between this already created table and the one which i will going to create using REST API,to do this&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;what changes I need to make in json file which we are using to create hive_process?&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;which one is that property, you have set in json file because of it we can link table1 and table2?&lt;/STRONG&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 29 Dec 2016 19:36:52 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173657#M50304</guid>
      <dc:creator>Manus</dc:creator>
      <dc:date>2016-12-29T19:36:52Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173658#M50305</link>
      <description>&lt;P&gt;I have working atlas api examples here&lt;/P&gt;&lt;P&gt;&lt;A href="https://github.com/sunileman/Atlas-API-Examples" target="_blank"&gt;https://github.com/sunileman/Atlas-API-Examples&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Fri, 30 Dec 2016 12:20:40 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173658#M50305</guid>
      <dc:creator>sunile_manjee</dc:creator>
      <dc:date>2016-12-30T12:20:40Z</dc:date>
    </item>
    <item>
      <title>Re: How to create hive table entity in Apache atlas using REST  API?</title>
      <link>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173659#M50306</link>
      <description>&lt;P&gt;Please first validate your JSON using &lt;A target="_blank" href="https://jsonformatter.org"&gt;JSON Formatter and JSON Validator&lt;/A&gt;.&lt;/P&gt;</description>
      <pubDate>Tue, 23 May 2017 15:31:26 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-hive-table-entity-in-Apache-atlas-using-REST/m-p/173659#M50306</guid>
      <dc:creator>jimmi_prajapati</dc:creator>
      <dc:date>2017-05-23T15:31:26Z</dc:date>
    </item>
  </channel>
</rss>

