[ https://issues.apache.org/jira/browse/ATLAS-3866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pinal updated ATLAS-3866: ------------------------- Description: Tried below API of ATLAS {code:java} v2/search/relationship?limit=10&offset=0&guid=3e424245-0676-4d47-96a1-e17228b38367&relation=__hive_table.sd&sortBy=name&sortOrder=ASCENDING&excludeDeletedEntities=true{code} error Response: {code:java} { "errorCode": "ATLAS-500-00-001", "errorMessage": "Internal server error Relationship search query failed" } {code} *Cause of issue:* Above Request contains sortBy=name, 'name' attribute is not in hive_storagedesc definition, hence the issue. Also if sortBy is not passed, default attribute is 'name' was: Tried below API of ATLAS [CDH-7.2.0 runtime] {code:java} v2/search/relationship?limit=10&offset=0&guid=3e424245-0676-4d47-96a1-e17228b38367&relation=__hive_table.sd&sortBy=name&sortOrder=ASCENDING&excludeDeletedEntities=true{code} error Response: {code:java} { "errorCode": "ATLAS-500-00-001", "errorMessage": "Internal server error Relationship search query failed" } {code} *Cause of issue:* Above Request contains sortBy=name, 'name' attribute is not in hive_storagedesc definition, hence the issue. Also if sortBy is not passed, default attribute is 'name' > Relationship search API for hive storage desc throws error code 500 > ------------------------------------------------------------------- > > Key: ATLAS-3866 > URL: https://issues.apache.org/jira/browse/ATLAS-3866 > Project: Atlas > Issue Type: Bug > Components: atlas-core > Affects Versions: 2.0.0 > Reporter: Pinal > Assignee: Pinal > Priority: Major > Labels: Relationships > Fix For: 2.1.0, 3.0.0 > > > Tried below API of ATLAS > {code:java} > v2/search/relationship?limit=10&offset=0&guid=3e424245-0676-4d47-96a1-e17228b38367&relation=__hive_table.sd&sortBy=name&sortOrder=ASCENDING&excludeDeletedEntities=true{code} > error Response: > {code:java} > { > "errorCode": "ATLAS-500-00-001", > "errorMessage": "Internal server error Relationship search query failed" > } > {code} > > *Cause of issue:* > Above Request contains sortBy=name, 'name' attribute is not in > hive_storagedesc definition, hence the issue. > Also if sortBy is not passed, default attribute is 'name' -- This message was sent by Atlassian Jira (v8.3.4#803005)