Join query not working

[krishnaj...@gmail.com]

Hi, Following queries are not working in the Slamdata:

Select PS.ProductID
From `/Couchbase/ProductSlot`  as PS
Left Outer Join `/Couchbase/ProductSlot` as P
on OID(PS.ProductID) = OID(P.ProductID)

Error:  An unknown error occurred: 500 ""

and another query executes successfully returning ProductID and duration. but when I create a pie chart by mentioning ProductID as dimension and Duration as the measure, I get the error saying:

Failed to plan query.: unimplemented EquiJoin: Not currently mapped to N1QL's key join

The query is :

SELECT  P.ProductID ,P.Duration From `/localCB/Product` as P limit 5

and the preview table is in the attached image: Please help

[Damon LaCaille]

Hi,

Based on your error you are using Couchbase:

Failed to plan query.: unimplemented EquiJoin: Not currently mapped to N1QL's key join

Recent changes in our backend might have caused this issue. Please see the following (possibly) related issues:

https://github.com/quasar-analytics/quasar/issues/2128  <-- may be your first problem

https://github.com/quasar-analytics/quasar/issues/2117

https://github.com/quasar-analytics/quasar/issues/2403  <-- may be your chart problem w/ Couchbase

[Damon LaCaille]

Have you tried using MongoDB as a backend data source? It is the most mature connector in the SlamData suite. While we do support MarkLogic, Couchbase, Spark and others, MongoDB has been supported the longest and thus has enhanced functionality.

Migrating JSON documents from one NoSQL database to another can be done relatively easily.

On Thursday, August 3, 2017 at 2:46:32 AM UTC-5, krishnaj...@gmail.com wrote: