atlas-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ayub Pathan (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (ATLAS-1874) V2 DSL search query does not support for count() but v1 do.
Date Wed, 12 Jul 2017 01:23:00 GMT

    [ https://issues.apache.org/jira/browse/ATLAS-1874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16083284#comment-16083284
] 

Ayub Pathan edited comment on ATLAS-1874 at 7/12/17 1:22 AM:
-------------------------------------------------------------

[~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}


Where as for the count query, response is empty. for example:
{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}


was (Author: ayubkhan):
[~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)

Mime
View raw message