@Saba BaigFew aggregate functions are not working in V2 APIs. There are few Apache JIRAs filed for the same : https://issues.apache.org/jira/browse/ATLAS-1874 https://issues.apache.org/jira/browse/ATLAS-1639 However V1 APIs work perfectly . For example :
Query : hive_table groupby(owner) select owner,count()
URL encoded :
http://localhost:21000/api/atlas/discovery/search/dsl?limit=25&query=hive_table+groupby(owner)+select+owner%2Ccount()
Response :
{requestId: "pool-2-thread-9 - 8a45b7a6-0cd9-4e9d-8b71-66e313f5abf1",
query: "hive_table groupby(owner) select owner,count()",
queryType: "dsl",
count: 2,
results:
[
{$typeName$: "__tempQueryResultStruct74",
count(): 9,
owner: "hrt_qa"
},
{$typeName$: "__tempQueryResultStruct74",
count(): 2,
owner: "anonymous"
}
],
dataType:
{typeName: "__tempQueryResultStruct74",
typeDescription: null,
typeVersion: "1.0",
attributeDefinitions:
[
{name: "owner",
dataTypeName: "string",
multiplicity:
{lower: 0,
upper: 1,
isUnique: false
},
isComposite: false,
isUnique: false,
isIndexable: false,
reverseAttributeName: null
},
{name: "count()",
dataTypeName: "long",
multiplicity:
{lower: 0,
upper: 1,
isUnique: false
},
isComposite: false,
isUnique: false,
isIndexable: false,
reverseAttributeName: null
}
]
}
}
This query groups the owner of hive_table and and lists the owner ,count in each group . The concept is similar to that of SQL. Since the UI currently uses V2 query , you may not see the results on UI. But you can always rely on REST APIs. For this particular kind of queries , please use V1 APIs for now .
... View more
