You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@atlas.apache.org by "Ashutosh Mestry (JIRA)" <ji...@apache.org> on 2018/02/14 22:05:00 UTC
[jira] [Updated] (ATLAS-2447) Advanced Search DSL: Improve Select
Queries Using De-duplication During Query Formation
[ https://issues.apache.org/jira/browse/ATLAS-2447?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashutosh Mestry updated ATLAS-2447:
-----------------------------------
Attachment: ATLAS-2447-Added-Dedup.patch
> Advanced Search DSL: Improve Select Queries Using De-duplication During Query Formation
> ---------------------------------------------------------------------------------------
>
> Key: ATLAS-2447
> URL: https://issues.apache.org/jira/browse/ATLAS-2447
> Project: Atlas
> Issue Type: Bug
> Components: atlas-core
> Affects Versions: trunk
> Reporter: Ashutosh Mestry
> Assignee: Ashutosh Mestry
> Priority: Major
> Fix For: trunk
>
> Attachments: ATLAS-2447-Added-Dedup.patch
>
>
> In the provided Atlas instance , there are many 1000+ hive_table entities .
> Few of them :
> db2.table1
> db1.table1
> db1.table2
> db3.table2
> DSL query :
> {code:java}
> typename = hive_table
> query = name > "table1"
> {code}
> listed all the hive_table entities whose name>"table1" ,
> With limit 25 per page ,
> db3.table2 is in 19th page (467th entity)
> db1.table2 is in 21st page (521th entity)
> *+Error scenario :+*
> DSL query :
> {code:java}
> typename = hive_db
> query = where name > "table1" select db
> {code}
> limit = 25 , lists only 1 db .
> Expected that it would result db3 and db1 along with other db's since "table2" is greater than "table1" and "table2" is in db3 and db1.
> when same query with limit =1000 , lists many results along with db1 and db3.
> When limit is 25 , "select db" is done on the returned 25 results of "name > table1" and selects the db.
> Since table2 doesn't appear in the first 25 entities , db3 and db1 didn't result.
> Attaching the screenshots for limit 10000 and limit 25.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)