[
https://issues.apache.org/jira/browse/ATLAS-5032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Paresh Devalia reassigned ATLAS-5032:
-------------------------------------
Assignee: Paresh Devalia
> 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: Paresh Devalia
> 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
> *Steps to Reproduce:*
> # Create an entity with a long name and corresponding qualified name using
> the following curl command:
> |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": {}
> }'|
>
> # Perform a basic search using attribute filters:
> # qualifiedName starts with default.<370_char_string>
> # qualifiedName ends with @primary
> # Curl request as below
> |curl 'http://127.0.0.1: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
> }'|
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
