[
https://issues.apache.org/jira/browse/ATLAS-5032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yuvraj Chavan updated ATLAS-5032:
---------------------------------
Description:
We created a hive_table entity in Apache Atlas with the following details:
* name: A string with 370 characters.
* qualifiedName: In the format default.<entity_name>@primary, where
<entity_name> is the same 370-character string.
Despite the entity being successfully created and visible through direct entity
retrieval, *basic search queries using attribute filters on* *qualifiedName*
*are not returning results* when using an AND condition with the following
filters:
# qualifiedName *starts with* default.<entity_name>
# qualifiedName *ends with* @primary
*Observation:*
The search query returns an empty result list for the specified entities.
*Expected Outcome:*
The search should return a list of Hive table entities matching the query.
*Steps to Reproduce:*
# Create an entity with a long name and corresponding qualified name using the
following curl command:
{code:java}
curl --location --request POST 'http://localhost:21000/api/atlas/v2/entity' \
-u <username>:<password> \
--header 'Content-Type: application/json' \
--data-raw '{
"entity": {
"typeName": "hive_table",
"attributes": {
"aliases": [],
"comment": null,
"createTime": "1669974016149",
"description": "entity_370",
"displayName": null,
"lastAccessTime": 1234567890999,
"name":
"name370oootphvx6vovxzedvv0sjaivlmn0b9pdkdd8lbctngkptfxv5yibzaffjtr7aa7n8cnlqcnamcxhsul8vxx6spcwoy5l6bmov44r8ympwm3hidmrztzcgvgyyuhi4h6egtanqb7t1aws0aodvpd3bqvl5ji1frfsznupfw4uqrsrdfdcy39hetlhq3aan8ogzr3nshgnpurskhkzvt8xov12yplobpfqble2b1zsq2gz1s5vliud1fihec4i2euiuqwiuyiyiwyeiuewawdsedvkjsljh234jh23k4h2j3h4k234hj23h4hj2h3j4j2h34kjkjh23k4jhk23k23jh4kh234kj32h4j32jh4j3a",
"owner": "dev",
"parameters": null,
"qualifiedName":
"default.name370oootphvx6vovxzedvv0sjaivlmn0b9pdkdd8lbctngkptfxv5yibzaffjtr7aa7n8cnlqcnamcxhsul8vxx6spcwoy5l6bmov44r8ympwm3hidmrztzcgvgyyuhi4h6egtanqb7t1aws0aodvpd3bqvl5ji1frfsznupfw4uqrsrdfdcy39hetlhq3aan8ogzr3nshgnpurskhkzvt8xov12yplobpfqble2b1zsq2gz1s5vliud1fihec4i2euiuqwiuyiyiwyeiuewawdsedvkjsljh234jh23k4h2j3h4k234hj23h4hj2h3j4j2h34kjkjh23k4jhk23k23jh4kh234kj32h4j32jh4j3a@primary",
"replicatedFrom": [],
"replicatedTo": [],
"retention": null,
"tableType": null,
"temporary": null,
"userDescription": null,
"viewExpandedText": null,
"viewOriginalText": null
}
},
"referredEntities": {}
}'{code}
# Perform a basic search using attribute filters:
## qualifiedName starts with default.<370_char_string>
## qualifiedName ends with @primary
Curl Request:
{code:java}
curl 'http://localhost:21000/api/atlas/v2/search/basic' \
-u <username>:<password> \
--header 'Content-Type: application/json' \
--data-raw '{
"excludeDeletedEntities": true,
"includeSubClassifications": true,
"includeSubTypes": true,
"includeClassificationAttributes": true,
"entityFilters": {
"condition": "AND",
"criterion": [
{
"attributeName": "qualifiedName",
"operator": "startsWith",
"attributeValue":
"default.name370oootphvx6vovxzedvv0sjaivlmn0b9pdkdd8lbctngkptfxv5yibzaffjtr7aa7n8cnlqcnamcxhsul8vxx6spcwoy5l6bmov44r8ympwm3hidmrztzcgvgyyuhi4h6egtanqb7t1aws0aodvpd3bqvl5ji1frfsznupfw4uqrsrdfdcy39hetlhq3aan8ogzr3nshgnpurskhkzvt8xov12yplobpfqble2b1zsq2gz1s5vliud1fihec4i2euiuqwiuyiyiwyeiuewawdsedvkjsljh234jh23k4h2j3h4k234hj23h4hj2h3j4j2h34kjkjh23k4jhk23k23jh4kh234kj32h4j32jh4j3a"
},
{
"attributeName": "qualifiedName",
"operator": "endsWith",
"attributeValue": "@primary"
}
]
},
"tagFilters": null,
"attributes": [
"qualifiedName"
],
"limit": 25,
"offset": 0,
"typeName": "hive_table",
"classification": null,
"termName": null
}'{code}
was:
We created a hive_table entity in Apache Atlas with the following details:
* name: A string with 370 characters.
* qualifiedName: In the format default.<entity_name>@primary, where
<entity_name> is the same 370-character string.
Despite the entity being successfully created and visible through direct entity
retrieval, *basic search queries using attribute filters on* *qualifiedName*
*are not returning results* when using an AND condition with the following
filters:
# qualifiedName *starts with* default.<entity_name>
# qualifiedName *ends with* @primary
*Steps to Reproduce:*
# Create an entity with a long name and corresponding qualified name using the
following curl command:
{code:java}
curl --location --request POST 'http://localhost:21000/api/atlas/v2/entity' \
-u <username>:<password> \
--header 'Content-Type: application/json' \
--data-raw '{
"entity": {
"typeName": "hive_table",
"attributes": {
"aliases": [],
"comment": null,
"createTime": "1669974016149",
"description": "entity_370",
"displayName": null,
"lastAccessTime": 1234567890999,
"name":
"name370oootphvx6vovxzedvv0sjaivlmn0b9pdkdd8lbctngkptfxv5yibzaffjtr7aa7n8cnlqcnamcxhsul8vxx6spcwoy5l6bmov44r8ympwm3hidmrztzcgvgyyuhi4h6egtanqb7t1aws0aodvpd3bqvl5ji1frfsznupfw4uqrsrdfdcy39hetlhq3aan8ogzr3nshgnpurskhkzvt8xov12yplobpfqble2b1zsq2gz1s5vliud1fihec4i2euiuqwiuyiyiwyeiuewawdsedvkjsljh234jh23k4h2j3h4k234hj23h4hj2h3j4j2h34kjkjh23k4jhk23k23jh4kh234kj32h4j32jh4j3a",
"owner": "dev",
"parameters": null,
"qualifiedName":
"default.name370oootphvx6vovxzedvv0sjaivlmn0b9pdkdd8lbctngkptfxv5yibzaffjtr7aa7n8cnlqcnamcxhsul8vxx6spcwoy5l6bmov44r8ympwm3hidmrztzcgvgyyuhi4h6egtanqb7t1aws0aodvpd3bqvl5ji1frfsznupfw4uqrsrdfdcy39hetlhq3aan8ogzr3nshgnpurskhkzvt8xov12yplobpfqble2b1zsq2gz1s5vliud1fihec4i2euiuqwiuyiyiwyeiuewawdsedvkjsljh234jh23k4h2j3h4k234hj23h4hj2h3j4j2h34kjkjh23k4jhk23k23jh4kh234kj32h4j32jh4j3a@primary",
"replicatedFrom": [],
"replicatedTo": [],
"retention": null,
"tableType": null,
"temporary": null,
"userDescription": null,
"viewExpandedText": null,
"viewOriginalText": null
}
},
"referredEntities": {}
}'{code}
# Perform a basic search using attribute filters:
# qualifiedName starts with default.<370_char_string>
# qualifiedName ends with @primary
# Curl request as below
{code:java}
curl 'http://localhost:21000/api/atlas/v2/search/basic' \
-u <username>:<password> \
--header 'Content-Type: application/json' \
--data-raw '{
"excludeDeletedEntities": true,
"includeSubClassifications": true,
"includeSubTypes": true,
"includeClassificationAttributes": true,
"entityFilters": {
"condition": "AND",
"criterion": [
{
"attributeName": "qualifiedName",
"operator": "startsWith",
"attributeValue":
"default.name370oootphvx6vovxzedvv0sjaivlmn0b9pdkdd8lbctngkptfxv5yibzaffjtr7aa7n8cnlqcnamcxhsul8vxx6spcwoy5l6bmov44r8ympwm3hidmrztzcgvgyyuhi4h6egtanqb7t1aws0aodvpd3bqvl5ji1frfsznupfw4uqrsrdfdcy39hetlhq3aan8ogzr3nshgnpurskhkzvt8xov12yplobpfqble2b1zsq2gz1s5vliud1fihec4i2euiuqwiuyiyiwyeiuewawdsedvkjsljh234jh23k4h2j3h4k234hj23h4hj2h3j4j2h34kjkjh23k4jhk23k23jh4kh234kj32h4j32jh4j3a"
},
{
"attributeName": "qualifiedName",
"operator": "endsWith",
"attributeValue": "@primary"
}
]
},
"tagFilters": null,
"attributes": [
"qualifiedName"
],
"limit": 25,
"offset": 0,
"typeName": "hive_table",
"classification": null,
"termName": null
}'
{code}
> Basic search using qualifiedName with "starts with" and "ends with"
> operators does not return results for long entity names.
> -----------------------------------------------------------------------------------------------------------------------------
>
> Key: ATLAS-5032
> URL: https://issues.apache.org/jira/browse/ATLAS-5032
> Project: Atlas
> Issue Type: Bug
> Reporter: Paresh Devalia
> Assignee: Yuvraj Chavan
> Priority: Major
>
> We created a hive_table entity in Apache Atlas with the following details:
> * name: A string with 370 characters.
> * qualifiedName: In the format default.<entity_name>@primary, where
> <entity_name> is the same 370-character string.
> Despite the entity being successfully created and visible through direct
> entity retrieval, *basic search queries using attribute filters on*
> *qualifiedName* *are not returning results* when using an AND condition with
> the following filters:
> # qualifiedName *starts with* default.<entity_name>
> # qualifiedName *ends with* @primary
>
> *Observation:*
> The search query returns an empty result list for the specified entities.
>
> *Expected Outcome:*
> The search should return a list of Hive table entities matching the query.
>
> *Steps to Reproduce:*
> # Create an entity with a long name and corresponding qualified name using
> the following curl command:
> {code:java}
> curl --location --request POST 'http://localhost:21000/api/atlas/v2/entity' \
> -u <username>:<password> \
> --header 'Content-Type: application/json' \
> --data-raw '{
> "entity": {
> "typeName": "hive_table",
> "attributes": {
> "aliases": [],
> "comment": null,
> "createTime": "1669974016149",
> "description": "entity_370",
> "displayName": null,
> "lastAccessTime": 1234567890999,
> "name":
> "name370oootphvx6vovxzedvv0sjaivlmn0b9pdkdd8lbctngkptfxv5yibzaffjtr7aa7n8cnlqcnamcxhsul8vxx6spcwoy5l6bmov44r8ympwm3hidmrztzcgvgyyuhi4h6egtanqb7t1aws0aodvpd3bqvl5ji1frfsznupfw4uqrsrdfdcy39hetlhq3aan8ogzr3nshgnpurskhkzvt8xov12yplobpfqble2b1zsq2gz1s5vliud1fihec4i2euiuqwiuyiyiwyeiuewawdsedvkjsljh234jh23k4h2j3h4k234hj23h4hj2h3j4j2h34kjkjh23k4jhk23k23jh4kh234kj32h4j32jh4j3a",
> "owner": "dev",
> "parameters": null,
> "qualifiedName":
> "default.name370oootphvx6vovxzedvv0sjaivlmn0b9pdkdd8lbctngkptfxv5yibzaffjtr7aa7n8cnlqcnamcxhsul8vxx6spcwoy5l6bmov44r8ympwm3hidmrztzcgvgyyuhi4h6egtanqb7t1aws0aodvpd3bqvl5ji1frfsznupfw4uqrsrdfdcy39hetlhq3aan8ogzr3nshgnpurskhkzvt8xov12yplobpfqble2b1zsq2gz1s5vliud1fihec4i2euiuqwiuyiyiwyeiuewawdsedvkjsljh234jh23k4h2j3h4k234hj23h4hj2h3j4j2h34kjkjh23k4jhk23k23jh4kh234kj32h4j32jh4j3a@primary",
> "replicatedFrom": [],
> "replicatedTo": [],
> "retention": null,
> "tableType": null,
> "temporary": null,
> "userDescription": null,
> "viewExpandedText": null,
> "viewOriginalText": null
> }
>
> },
> "referredEntities": {}
> }'{code}
> # Perform a basic search using attribute filters:
> ## qualifiedName starts with default.<370_char_string>
> ## qualifiedName ends with @primary
> Curl Request:
> {code:java}
> curl 'http://localhost:21000/api/atlas/v2/search/basic' \
> -u <username>:<password> \
> --header 'Content-Type: application/json' \
> --data-raw '{
> "excludeDeletedEntities": true,
> "includeSubClassifications": true,
> "includeSubTypes": true,
> "includeClassificationAttributes": true,
> "entityFilters": {
> "condition": "AND",
> "criterion": [
> {
> "attributeName": "qualifiedName",
> "operator": "startsWith",
> "attributeValue":
> "default.name370oootphvx6vovxzedvv0sjaivlmn0b9pdkdd8lbctngkptfxv5yibzaffjtr7aa7n8cnlqcnamcxhsul8vxx6spcwoy5l6bmov44r8ympwm3hidmrztzcgvgyyuhi4h6egtanqb7t1aws0aodvpd3bqvl5ji1frfsznupfw4uqrsrdfdcy39hetlhq3aan8ogzr3nshgnpurskhkzvt8xov12yplobpfqble2b1zsq2gz1s5vliud1fihec4i2euiuqwiuyiyiwyeiuewawdsedvkjsljh234jh23k4h2j3h4k234hj23h4hj2h3j4j2h34kjkjh23k4jhk23k23jh4kh234kj32h4j32jh4j3a"
> },
> {
> "attributeName": "qualifiedName",
> "operator": "endsWith",
> "attributeValue": "@primary"
> }
> ]
> },
> "tagFilters": null,
> "attributes": [
> "qualifiedName"
> ],
> "limit": 25,
> "offset": 0,
> "typeName": "hive_table",
> "classification": null,
> "termName": null
> }'{code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
