Arangodb distinct. Please see the most recent stable version.

Arangodb distinct. . Enhance your ArangoDB queries with expert insights from the ArangoDB Blog. You can use the AQL functions listed below to work with lists of items. 11 reached End of Life (EOL) and is no longer supported. For example, the following query will apply DISTINCT on its subquery results, but not inside the subquery: ArangoDB v3. Jan 18, 2019 · What RETURN DISTINCT does is to remove duplicate values, but only after the traversal. This documentation is outdated. Aug 15, 2014 · Hi, I'm trying to retrieve the equivalent of a SELECT DISTINCT from a large (> 4,000,000) collection of documents via arangosh. You can set traversal options to eliminate paths during the traversal, which can be more efficient especially if you have a highly interconnected graph and a high traversal depth: May 4, 2022 · That said, if you are applying COLLECT or RETURN DISTINCT on full documents, they will always be distinct, because each document in a collection will at least have different _key values. Also see the numeric functions for functions that work on number arrays. Jul 27, 2015 · Last week saw the addition of the RETURN DISTINCT for AQL queries. Please see the most recent stable version. This is a new shortcut syntax for making result sets unique. For this purpose it can be used as an easier-to-memorize alternative for the already existing COLLECT statement. So far I've tried two approaches: using COLLECT using the UNIQUE function Sample queries used. Jul 27, 2015 · Unlock the power of AQL with tips on efficiently returning distinct values. Mar 11, 2014 · To make the result of an array or a subquery unique, simply apply the DISTINCT for the array or the subquery. cjhqy govb hbq wqast aabybfr kkll rccx awvxcsy wckoo zkkac