[
https://issues.apache.org/jira/browse/ATLAS-1874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16082381#comment-16082381
]
Graham Wallis commented on ATLAS-1874:
--------------------------------------
[~ayubkhan] [~ssainath] Thanks for the explanation. I tried running some DSL
queries (from the UI) and was not getting any results from any queries that
included any 'select' of an attribute or count.
For example, using the sample data generated by quick_start.py:
Table where db.name="Reporting" - works correctly,
returns two tables that belong to the Reporting DB
Table where db.name="Reporting" select owner - returns nothing
So I think the problem may be broader than just affecting 'count'
> 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)
