Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

The results returned from "http://192.168.1.144:21000/api/atlas/lineage/hive/table/default.russ@erietp/inputs/graph" proivde edges & veticies - how do produce the lineage from the edges in the correct order? Source-to-Target

The results returned from "http://192.168.1.144:21000/api/atlas/lineage/hive/table/default.russ@erietp/inputs/graph" proivde edges & veticies - how do produce the lineage from the edges in the correct order? Source-to-Target

Explorer

JSON cannot assure any order returned - see references on the internet regarding JSON ordered results.

So how do i create the correct source-to-target lineage ; meaning ; set the proper order for each edge?

http://192.168.1.144:21000/api/atlas/lineage/hive/table/default.russ@erietp/inputs/graph

Yields the JSON result :

{"results":{"typeName":"__tempQueryResultStruct875","values":{"edges":{"cb09a6f5-f76d-4208-8a62-17c3ca1e3e9d":["b0092981-6bcf-41a8-b0c9-34f3c5b6efd4"],"5591f85d-054a-4264-a8ee-c5ec250ccccb":["aff53ced-c48a-4b18-a321-4862a6ab84ac"],"6875ac4e-45a3-458a-b586-16e484567f9a":["cb09a6f5-f76d-4208-8a62-17c3ca1e3e9d"],"b0092981-6bcf-41a8-b0c9-34f3c5b6efd4":["5591f85d-054a-4264-a8ee-c5ec250ccccb"]},"vertices":{"aff53ced-c48a-4b18-a321-4862a6ab84ac":{"typeName":"__tempQueryResultStruct874","values":{"vertexId":{"typeName":"__IdType","values":{"typeName":"sqoop_dbdatastore","guid":"aff53ced-c48a-4b18-a321-4862a6ab84ac"},"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct"},"name":"mysql --url jdbc:mysql://localhost/test?zeroDateTimeBehavior=convertToNull --table test_table_sqoop"},"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct"},"6875ac4e-45a3-458a-b586-16e484567f9a":{"typeName":"__tempQueryResultStruct874","values":{"vertexId":{"typeName":"__IdType","values":{"typeName":"hive_table","guid":"6875ac4e-45a3-458a-b586-16e484567f9a"},"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct"},"name":"default.russ@erietp"},"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct"},"b0092981-6bcf-41a8-b0c9-34f3c5b6efd4":{"typeName":"__tempQueryResultStruct874","values":{"vertexId":{"typeName":"__IdType","values":{"typeName":"hive_table","guid":"b0092981-6bcf-41a8-b0c9-34f3c5b6efd4"},"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct"},"name":"default.test_hive_table@erietp"},"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct"}}},"jsonClass":"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct"},"requestId":"qtp1635546341-126 - b940f9b4-2a9b-43b4-93d8-ad4c0cf7ecc5","tableName":"default.russ@erietp"}

1 REPLY 1
Highlighted

Re: The results returned from "http://192.168.1.144:21000/api/atlas/lineage/hive/table/default.russ@erietp/inputs/graph" proivde edges & veticies - how do produce the lineage from the edges in the correct order? Source-to-Target

Mentor

My understanding is you get the relationships from the underlying graph database not from raw JSON

Don't have an account?
Coming from Hortonworks? Activate your account here