I am having trouble requesting anything other than couchmusic1.country docs. Here's how it looks: link
So if i do
select * from couchmusic1.country limit 1;
this is fine, but if I do this:
select * from couchmusic1.playlist limit 1; //or any other number
I get empty results as follows:
"results": [
],
"status": "success".....................
Has anyone had a similar problem? All the documents are there, I tried to delete the primary index (only one so far) and recreate it, the same thing. Does anyone know why?
EDIT: The problem only occurs when I have a LIMIT parameter in the request ... I am sorry that I forgot to mention this the first time.
EDIT2: If anyone is interested, this can be used as a workaround:
SELECT * FROM couchmusic1 WHERE playlist IS NOT MISSING limit 1;
. , .