[
https://issues.apache.org/jira/browse/ATLAS-876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15374640#comment-15374640
]
Shwetha G S commented on ATLAS-876:
-----------------------------------
Lineage for deleted entity:
http://localhost:21000/api/atlas/lineage/e7ea0f4b-f0c1-476e-829c-1995ede3b2b5/inputs/graph
{noformat}
{
"requestId":"qtp277249057-315 - 0d90bfe2-f80b-4b98-8586-be5508dc8ee9",
"results":{
"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
"typeName":"__tempQueryResultStruct89",
"values":{
"vertices":{
"e7ea0f4b-f0c1-476e-829c-1995ede3b2b5":{
"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
"typeName":"__tempQueryResultStruct88",
"values":{
"qualifiedName":"default.myt_ctas@primary",
"vertexId":{
"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
"typeName":"__IdType",
"values":{
"guid":"e7ea0f4b-f0c1-476e-829c-1995ede3b2b5",
"state":"DELETED",
"typeName":"hive_table"
}
},
"name":"myt_ctas"
}
},
"336de92b-5e48-447e-8eda-3060b13b1ed1":{
"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
"typeName":"__tempQueryResultStruct88",
"values":{
"qualifiedName":"default.myt@primary",
"vertexId":{
"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
"typeName":"__IdType",
"values":{
"guid":"336de92b-5e48-447e-8eda-3060b13b1ed1",
"state":"ACTIVE",
"typeName":"hive_table"
}
},
"name":"myt"
}
}
},
"edges":{
"e7ea0f4b-f0c1-476e-829c-1995ede3b2b5":[
"6a5612c1-a0b6-46bd-9fdc-172b04350214"
],
"6a5612c1-a0b6-46bd-9fdc-172b04350214":[
"336de92b-5e48-447e-8eda-3060b13b1ed1"
]
}
}
}
}
{noformat}
Lineage for new table created:
http://localhost:21000/api/atlas/lineage/99ebf802-6624-4f91-a91d-c7338ef07d02/inputs/graph
{noformat}
{
"requestId":"qtp277249057-340 - 1e0ad6a7-1c3a-4d35-a4dd-b30b12abb9a1",
"results":{
"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
"typeName":"__tempQueryResultStruct83",
"values":{
"vertices":{
"99ebf802-6624-4f91-a91d-c7338ef07d02":{
"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
"typeName":"__tempQueryResultStruct82",
"values":{
"qualifiedName":"default.myt_ctas@primary",
"vertexId":{
"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
"typeName":"__IdType",
"values":{
"guid":"99ebf802-6624-4f91-a91d-c7338ef07d02",
"state":"ACTIVE",
"typeName":"hive_table"
}
},
"name":"myt_ctas"
}
},
"336de92b-5e48-447e-8eda-3060b13b1ed1":{
"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
"typeName":"__tempQueryResultStruct82",
"values":{
"qualifiedName":"default.myt@primary",
"vertexId":{
"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
"typeName":"__IdType",
"values":{
"guid":"336de92b-5e48-447e-8eda-3060b13b1ed1",
"state":"ACTIVE",
"typeName":"hive_table"
}
},
"name":"myt"
}
}
},
"edges":{
"99ebf802-6624-4f91-a91d-c7338ef07d02":[
"6a5612c1-a0b6-46bd-9fdc-172b04350214"
],
"6a5612c1-a0b6-46bd-9fdc-172b04350214":[
"336de92b-5e48-447e-8eda-3060b13b1ed1"
]
}
}
}
}
{noformat}
> No lineage for a re-created ctas table
> --------------------------------------
>
> Key: ATLAS-876
> URL: https://issues.apache.org/jira/browse/ATLAS-876
> Project: Atlas
> Issue Type: Bug
> Affects Versions: 0.7-incubating
> Reporter: Ayub Khan
> Assignee: Shwetha G S
> Priority: Critical
>
> No lineage for a re-created ctas table
> Steps to reproduce:
> create table account (name String, balance Int);
> create table account_ctas as select * from account;
> drop table account_ctas;
> create table account_ctas as select * from account;
> Empty responses from server for recreated ctas
> {noformat}
> curl
> 'http://localhost:21000/api/atlas/lineage/ebd6a5a9-8453-4dbd-b8d9-1575a464ebc3/inputs/graph'
> -H 'Cookie: JSESSIONID=12rn8aybkawa5ewiqdb2hv663' -H 'Accept-Encoding: gzip,
> deflate, sdch' -H 'Accept-Language: en-US,en;q=0.8' -H 'User-Agent:
> Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML,
> like Gecko) Chrome/50.0.2661.102 Safari/537.36' -H 'Accept: application/json,
> text/javascript, */*; q=0.01' -H 'Referer: http://localhost:21000/index.html'
> -H 'X-Requested-With: XMLHttpRequest' -H 'Connection: keep-alive'
> --compressed | python -m json.tool
> % Total % Received % Xferd Average Speed Time Time Time
> Current
> Dload Upload Total Spent Left Speed
> 100 237 0 237 0 0 281 0 --:--:-- --:--:-- --:--:-- 281
> {
> "requestId": "qtp1211076369-876 - ad29b29b-7faf-44f2-a2bd-8bbb00f07120",
> "results": {
> "jsonClass":
> "org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
> "typeName": "__tempQueryResultStruct135",
> "values": {
> "edges": {},
> "vertices": {}
> }
> }
> }
> curl
> 'http://localhost:21000/api/atlas/lineage/ebd6a5a9-8453-4dbd-b8d9-1575a464ebc3/outputs/graph'
> -H 'Cookie: JSESSIONID=12rn8aybkawa5ewiqdb2hv663' -H 'Accept-Encoding: gzip,
> deflate, sdch' -H 'Accept-Language: en-US,en;q=0.8' -H 'User-Agent:
> Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML,
> like Gecko) Chrome/50.0.2661.102 Safari/537.36' -H 'Accept: application/json,
> text/javascript, */*; q=0.01' -H 'Referer: http://localhost:21000/index.html'
> -H 'X-Requested-With: XMLHttpRequest' -H 'Connection: keep-alive'
> --compressed | python -m json.tool
> % Total % Received % Xferd Average Speed Time Time Time
> Current
> Dload Upload Total Spent Left Speed
> 100 238 0 238 0 0 271 0 --:--:-- --:--:-- --:--:-- 271
> {
> "requestId": "qtp1211076369-1104 - ee65b8d3-0cf9-4477-a644-d93aab6b625b",
> "results": {
> "jsonClass":
> "org.apache.atlas.typesystem.json.InstanceSerialization$_Struct",
> "typeName": "__tempQueryResultStruct141",
> "values": {
> "edges": {},
> "vertices": {}
> }
> }
> }
> {noformat}
> UI snapshot: https://monosnap.com/file/3XcCcffPjrayjLaIByWcjBHU4k2pgV
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
