[
https://issues.apache.org/jira/browse/ATLAS-1874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16083284#comment-16083284
]
Ayub Pathan commented on ATLAS-1874:
------------------------------------
[~grahamwallis] DSL query works fine for the above query you mentioned, it's
only that UI does not display anything, because query is requesting for
specific attribute (in this case, owner) of that entity. Please check the below
response for same query.
Response for query: "`hive_table` where db.name=\"default\" select owner"
{noformat}
{
"queryType":"DSL",
"queryText":"`hive_table` where db.name=\"default\" select owner",
"attributes":{
"name":[
"owner"
],
"values":[
[
"hive"
]
]
}
}
{noformat}
> V2 DSL search query does not support for count() but v1 do.
> -----------------------------------------------------------
>
> Key: ATLAS-1874
> URL: https://issues.apache.org/jira/browse/ATLAS-1874
> Project: Atlas
> Issue Type: Bug
> Components: atlas-core
> Affects Versions: 0.8.1-incubating
> Reporter: Ayub Pathan
> Fix For: 0.9-incubating, 0.8.1-incubating
>
>
> v1 DSL query supports count()
> {noformat}
> curl -u admin:admin
> 'http://ctr-e133-1493418528701-113468-01-000002.hwx.site:21000/api/atlas/discovery/search/dsl?query=hive_table%20where%20db.name%3D%22default%22%20select%20count()%20as%20%27count%27'
> | python -m json.tool
> % Total % Received % Xferd Average Speed Time Time Time
> Current
> Dload Upload Total Spent Left Speed
> 100 537 0 537 0 0 339 0 --:--:-- 0:00:01 --:--:-- 339
> {
> "count": 1,
> "dataType": {
> "attributeDefinitions": [
> {
> "dataTypeName": "long",
> "isComposite": false,
> "isIndexable": false,
> "isUnique": false,
> "multiplicity": {
> "isUnique": false,
> "lower": 0,
> "upper": 1
> },
> "name": "count",
> "reverseAttributeName": null
> }
> ],
> "typeDescription": null,
> "typeName": "__tempQueryResultStruct286",
> "typeVersion": "1.0"
> },
> "query": "hive_table where db.name=\"default\" select count() as 'count'",
> "queryType": "dsl",
> "requestId": "pool-2-thread-9 - 47389e3f-bbf1-4209-8e50-8a3235a7e5a9",
> "results": [
> {
> "$typeName$": "__tempQueryResultStruct286",
> "count": 68
> }
> ]
> }
> {noformat}
> v2 DSL search query does not
> {noformat}
> curl -u admin:admin
> 'http://ctr-e133-1493418528701-113468-01-000002.hwx.site:21000/api/atlas/v2/search/dsl?limit=25&excludeDeletedEntities=true&query=where+db.name%3D%22default%22+select+count()+as+%27count%27&typeName=hive_table&_=1497434602692'
> | python -m json.tool
> {
> "queryText": "`hive_table` where db.name=\"default\" select count() as
> 'count'",
> "queryType": "DSL"
> }
> {noformat}
> *From the initial analysis, it seems like, V2 API response does not have the
> count attribute which is cause for this failure.* might want to consider
> adding the count in V2?
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
