Details
Description
https://forums.couchbase.com/t/analytics-group-by-behaviour-duplicate-alias/17526
Error: “Duplicate alias definitions: description” when running the following query:
SELECT g.description AS account_name
|
, p.description AS parent_account_name
|
FROM `bucketname` g
|
LEFT JOIN `bucketname` p
|
ON g.parent_account_name = p.name
|
AND p.`type` = 'group'
|
WHERE g.`type` = 'group'
|
GROUP BY g.description
|
, p.description
|