[
https://issues.apache.org/jira/browse/ATLAS-4955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Paresh Devalia updated ATLAS-4955:
----------------------------------
Description:
Currently, on the UI, in Hive database detail page, the tables tab and
relationship tab are designed to only display Hive tables. We trying to have
multiple table types (such as Hive, table_a_type, table_b_type, etc) within the
same hive_db entity.
We are attaching the sample model file showing relation between hive_db and
table_a_type
The current design only supports showing tables of a single typename (e.g.,
hive_table) under the tables tab and relationship tab. This creates a gap where
other types of tables, such as table_a_type,etc, are not displayed, even if
they are within the same hive_db.
The relationship tab and tables tab uses the getRelationshipByName API call,
which takes in only single relationship name as a parameter
For example, if the hive db has 2 hive_table entities and 2 table_a_type
entities, the following API call gives response:
{code:java}
{
"queryType": "RELATIONSHIP",
"entities": [
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1737021605000,
"qualifiedName": "default.hive_1_table_qokst@cm",
"name": "hive_1_table_qokst",
"description": ""
},
"guid": "9c82d462-c5c9-4ef0-a57b-77e36f36b0cb",
"status": "ACTIVE",
"displayText": "hive_1_table_qokst",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1736842757000,
"qualifiedName": "default.hive_test_1@cm",
"name": "hive_test_1",
"description": ""
},
"guid": "e0a5006c-f2fa-4298-90bf-dd4f3e121e82",
"status": "ACTIVE",
"displayText": "hive_test_1",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1736842845000,
"qualifiedName": "default.hive_test_2@cm",
"name": "hive_test_2",
"description": ""
},
"guid": "f2151a91-8f26-429f-9589-2c2aa23fef85",
"status": "ACTIVE",
"displayText": "hive_test_2",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1737624635000,
"qualifiedName": "default.hive_test_3@cm",
"name": "hive_test_3",
"description": ""
},
"guid": "b0bf5e88-2d83-4380-818a-694a4499e04d",
"status": "ACTIVE",
"displayText": "hive_test_3",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
],
"approximateCount": -1
}
{code}
The expected response is :-
{code:java}
{
"queryType": "RELATIONSHIP",
"entities": [
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1737021605000,
"qualifiedName": "default.hive_1_table_qokst@cm",
"name": "hive_1_table_qokst",
"description": ""
},
"guid": "9c82d462-c5c9-4ef0-a57b-77e36f36b0cb",
"status": "ACTIVE",
"displayText": "hive_1_table_qokst",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1736842757000,
"qualifiedName": "default.hive_test_1@cm",
"name": "hive_test_1",
"description": ""
},
"guid": "e0a5006c-f2fa-4298-90bf-dd4f3e121e82",
"status": "ACTIVE",
"displayText": "hive_test_1",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1736842845000,
"qualifiedName": "default.hive_test_2@cm",
"name": "hive_test_2",
"description": ""
},
"guid": "f2151a91-8f26-429f-9589-2c2aa23fef85",
"status": "ACTIVE",
"displayText": "hive_test_2",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1737624635000,
"qualifiedName": "default.hive_test_3@cm",
"name": "hive_test_3",
"description": ""
},
"guid": "b0bf5e88-2d83-4380-818a-694a4499e04d",
"status": "ACTIVE",
"displayText": "hive_test_3",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "table_a_type",
"attributes": {
"owner": "hive",
"createTime": 1736842899000,
"qualifiedName": "default.hive_temp_1@cm",
"name": "hive_temp_1",
"description": ""
},
"guid": "90ee3772-23c3-4a7a-bd92-07f9fe411240",
"status": "ACTIVE",
"displayText": "hive_temp_1",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "table_a_type",
"attributes": {
"owner": "hive",
"createTime": 1736843025000,
"qualifiedName": "default.hive_temp_3@cm",
"name": "hive_temp_3",
"description": ""
},
"guid": "b08446e5-28f6-4a62-baf3-92b5b092b1f5",
"status": "ACTIVE",
"displayText": "hive_temp_3",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
}
],
"approximateCount": -1
}
{code}
was:
In hive_db entity's table tab and relationship tab Apart from hive_table
typeDef, we are not able to show the relationShip of other tables.
When we create hive tables and different typeDef table under same hive_db it
doesn't show both types of tables under tables tab table. It only show
hive_table typeDef table.
Currently, on the UI, in Hive database detail page, the tables tab and
relationship tab are designed to only display Hive tables. We trying to have
multiple table types (such as Hive, table_a_type, table_b_type, etc) within the
same hive_db entity.
We are attaching the sample model file showing relation between hive_db and
table_a_type
The current design only supports showing tables of a single typename (e.g.,
hive_table) under the tables tab and relationship tab. This creates a gap where
other types of tables, such as table_a_type,etc, are not displayed, even if
they are within the same hive_db.
The relationship tab and tables tab uses the getRelationshipByName API call,
which takes in only single relationship name as a parameter
For example, if the hive db has 2 hive_table entities and 2 table_a_type
entities, the following API call gives response:
{code:java}
{
"queryType": "RELATIONSHIP",
"entities": [
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1737021605000,
"qualifiedName": "default.hive_1_table_qokst@cm",
"name": "hive_1_table_qokst",
"description": ""
},
"guid": "9c82d462-c5c9-4ef0-a57b-77e36f36b0cb",
"status": "ACTIVE",
"displayText": "hive_1_table_qokst",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1736842757000,
"qualifiedName": "default.hive_test_1@cm",
"name": "hive_test_1",
"description": ""
},
"guid": "e0a5006c-f2fa-4298-90bf-dd4f3e121e82",
"status": "ACTIVE",
"displayText": "hive_test_1",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1736842845000,
"qualifiedName": "default.hive_test_2@cm",
"name": "hive_test_2",
"description": ""
},
"guid": "f2151a91-8f26-429f-9589-2c2aa23fef85",
"status": "ACTIVE",
"displayText": "hive_test_2",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1737624635000,
"qualifiedName": "default.hive_test_3@cm",
"name": "hive_test_3",
"description": ""
},
"guid": "b0bf5e88-2d83-4380-818a-694a4499e04d",
"status": "ACTIVE",
"displayText": "hive_test_3",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
],
"approximateCount": -1
}
{code}
The expected response is :-
{code:java}
{
"queryType": "RELATIONSHIP",
"entities": [
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1737021605000,
"qualifiedName": "default.hive_1_table_qokst@cm",
"name": "hive_1_table_qokst",
"description": ""
},
"guid": "9c82d462-c5c9-4ef0-a57b-77e36f36b0cb",
"status": "ACTIVE",
"displayText": "hive_1_table_qokst",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1736842757000,
"qualifiedName": "default.hive_test_1@cm",
"name": "hive_test_1",
"description": ""
},
"guid": "e0a5006c-f2fa-4298-90bf-dd4f3e121e82",
"status": "ACTIVE",
"displayText": "hive_test_1",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1736842845000,
"qualifiedName": "default.hive_test_2@cm",
"name": "hive_test_2",
"description": ""
},
"guid": "f2151a91-8f26-429f-9589-2c2aa23fef85",
"status": "ACTIVE",
"displayText": "hive_test_2",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "hive_table",
"attributes": {
"owner": "hive",
"createTime": 1737624635000,
"qualifiedName": "default.hive_test_3@cm",
"name": "hive_test_3",
"description": ""
},
"guid": "b0bf5e88-2d83-4380-818a-694a4499e04d",
"status": "ACTIVE",
"displayText": "hive_test_3",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "table_a_type",
"attributes": {
"owner": "hive",
"createTime": 1736842899000,
"qualifiedName": "default.hive_temp_1@cm",
"name": "hive_temp_1",
"description": ""
},
"guid": "90ee3772-23c3-4a7a-bd92-07f9fe411240",
"status": "ACTIVE",
"displayText": "hive_temp_1",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
},
{
"typeName": "table_a_type",
"attributes": {
"owner": "hive",
"createTime": 1736843025000,
"qualifiedName": "default.hive_temp_3@cm",
"name": "hive_temp_3",
"description": ""
},
"guid": "b08446e5-28f6-4a62-baf3-92b5b092b1f5",
"status": "ACTIVE",
"displayText": "hive_temp_3",
"classificationNames": [],
"classifications": [],
"meaningNames": [],
"meanings": [],
"isIncomplete": false,
"labels": []
}
],
"approximateCount": -1
}
{code}
> Different TypeDef table were created, but not able to seen under hive_db
> entity.
> --------------------------------------------------------------------------------
>
> Key: ATLAS-4955
> URL: https://issues.apache.org/jira/browse/ATLAS-4955
> Project: Atlas
> Issue Type: Bug
> Components: atlas-core
> Reporter: Paresh Devalia
> Assignee: Paresh Devalia
> Priority: Major
> Attachments: 1111-table_a_type_model.json
>
>
> Currently, on the UI, in Hive database detail page, the tables tab and
> relationship tab are designed to only display Hive tables. We trying to have
> multiple table types (such as Hive, table_a_type, table_b_type, etc) within
> the same hive_db entity.
> We are attaching the sample model file showing relation between hive_db and
> table_a_type
> The current design only supports showing tables of a single typename (e.g.,
> hive_table) under the tables tab and relationship tab. This creates a gap
> where other types of tables, such as table_a_type,etc, are not displayed,
> even if they are within the same hive_db.
> The relationship tab and tables tab uses the getRelationshipByName API call,
> which takes in only single relationship name as a parameter
> For example, if the hive db has 2 hive_table entities and 2 table_a_type
> entities, the following API call gives response:
> {code:java}
> {
> "queryType": "RELATIONSHIP",
> "entities": [
> {
> "typeName": "hive_table",
> "attributes": {
> "owner": "hive",
> "createTime": 1737021605000,
> "qualifiedName": "default.hive_1_table_qokst@cm",
> "name": "hive_1_table_qokst",
> "description": ""
> },
> "guid": "9c82d462-c5c9-4ef0-a57b-77e36f36b0cb",
> "status": "ACTIVE",
> "displayText": "hive_1_table_qokst",
> "classificationNames": [],
> "classifications": [],
> "meaningNames": [],
> "meanings": [],
> "isIncomplete": false,
> "labels": []
> },
> {
> "typeName": "hive_table",
> "attributes": {
> "owner": "hive",
> "createTime": 1736842757000,
> "qualifiedName": "default.hive_test_1@cm",
> "name": "hive_test_1",
> "description": ""
> },
> "guid": "e0a5006c-f2fa-4298-90bf-dd4f3e121e82",
> "status": "ACTIVE",
> "displayText": "hive_test_1",
> "classificationNames": [],
> "classifications": [],
> "meaningNames": [],
> "meanings": [],
> "isIncomplete": false,
> "labels": []
> },
> {
> "typeName": "hive_table",
> "attributes": {
> "owner": "hive",
> "createTime": 1736842845000,
> "qualifiedName": "default.hive_test_2@cm",
> "name": "hive_test_2",
> "description": ""
> },
> "guid": "f2151a91-8f26-429f-9589-2c2aa23fef85",
> "status": "ACTIVE",
> "displayText": "hive_test_2",
> "classificationNames": [],
> "classifications": [],
> "meaningNames": [],
> "meanings": [],
> "isIncomplete": false,
> "labels": []
> },
> {
> "typeName": "hive_table",
> "attributes": {
> "owner": "hive",
> "createTime": 1737624635000,
> "qualifiedName": "default.hive_test_3@cm",
> "name": "hive_test_3",
> "description": ""
> },
> "guid": "b0bf5e88-2d83-4380-818a-694a4499e04d",
> "status": "ACTIVE",
> "displayText": "hive_test_3",
> "classificationNames": [],
> "classifications": [],
> "meaningNames": [],
> "meanings": [],
> "isIncomplete": false,
> "labels": []
> },
> ],
> "approximateCount": -1
> }
> {code}
> The expected response is :-
> {code:java}
> {
> "queryType": "RELATIONSHIP",
> "entities": [
> {
> "typeName": "hive_table",
> "attributes": {
> "owner": "hive",
> "createTime": 1737021605000,
> "qualifiedName": "default.hive_1_table_qokst@cm",
> "name": "hive_1_table_qokst",
> "description": ""
> },
> "guid": "9c82d462-c5c9-4ef0-a57b-77e36f36b0cb",
> "status": "ACTIVE",
> "displayText": "hive_1_table_qokst",
> "classificationNames": [],
> "classifications": [],
> "meaningNames": [],
> "meanings": [],
> "isIncomplete": false,
> "labels": []
> },
> {
> "typeName": "hive_table",
> "attributes": {
> "owner": "hive",
> "createTime": 1736842757000,
> "qualifiedName": "default.hive_test_1@cm",
> "name": "hive_test_1",
> "description": ""
> },
> "guid": "e0a5006c-f2fa-4298-90bf-dd4f3e121e82",
> "status": "ACTIVE",
> "displayText": "hive_test_1",
> "classificationNames": [],
> "classifications": [],
> "meaningNames": [],
> "meanings": [],
> "isIncomplete": false,
> "labels": []
> },
> {
> "typeName": "hive_table",
> "attributes": {
> "owner": "hive",
> "createTime": 1736842845000,
> "qualifiedName": "default.hive_test_2@cm",
> "name": "hive_test_2",
> "description": ""
> },
> "guid": "f2151a91-8f26-429f-9589-2c2aa23fef85",
> "status": "ACTIVE",
> "displayText": "hive_test_2",
> "classificationNames": [],
> "classifications": [],
> "meaningNames": [],
> "meanings": [],
> "isIncomplete": false,
> "labels": []
> },
> {
> "typeName": "hive_table",
> "attributes": {
> "owner": "hive",
> "createTime": 1737624635000,
> "qualifiedName": "default.hive_test_3@cm",
> "name": "hive_test_3",
> "description": ""
> },
> "guid": "b0bf5e88-2d83-4380-818a-694a4499e04d",
> "status": "ACTIVE",
> "displayText": "hive_test_3",
> "classificationNames": [],
> "classifications": [],
> "meaningNames": [],
> "meanings": [],
> "isIncomplete": false,
> "labels": []
> },
> {
> "typeName": "table_a_type",
> "attributes": {
> "owner": "hive",
> "createTime": 1736842899000,
> "qualifiedName": "default.hive_temp_1@cm",
> "name": "hive_temp_1",
> "description": ""
> },
> "guid": "90ee3772-23c3-4a7a-bd92-07f9fe411240",
> "status": "ACTIVE",
> "displayText": "hive_temp_1",
> "classificationNames": [],
> "classifications": [],
> "meaningNames": [],
> "meanings": [],
> "isIncomplete": false,
> "labels": []
> },
> {
> "typeName": "table_a_type",
> "attributes": {
> "owner": "hive",
> "createTime": 1736843025000,
> "qualifiedName": "default.hive_temp_3@cm",
> "name": "hive_temp_3",
> "description": ""
> },
> "guid": "b08446e5-28f6-4a62-baf3-92b5b092b1f5",
> "status": "ACTIVE",
> "displayText": "hive_temp_3",
> "classificationNames": [],
> "classifications": [],
> "meaningNames": [],
> "meanings": [],
> "isIncomplete": false,
> "labels": []
> }
> ],
> "approximateCount": -1
> }
>
> {code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
