Simple select seems to return nothing

SELECT * from uv_DIST.EMAIL WHERE id = “000000000”

returns:

{
“results”: []
}

and it takes a day and forever to return that, I am running 5.0 of couchbase server (community) on a laptop and by bucket memory size is 2048 and only 50,000 records per bucket

I have verified that the data is in the bucket and I edited the document and it appears to be a properly formatted json object

any help/advice is greatly appreciated

Post the explain. Sample document.

The query is not valid (uv_DIST.EMAIL is not valid ) you should have got error.

From clause needs to be IDENTIFIER (bucket name)
Equivalent query is

SELECT EMAIL.* from uv_DIST WHERE EMAIL.id = “000000000”

I created a new bucket and did a select of:

SELECT * from uv_CBBUCKET WHERE id = “000000000”

below is the explain:

{
“plan”: {
#operator”: “Sequence”,
“~children”: [
{
#operator”: “PrimaryScan”,
“index”: “id”,
“keyspace”: “uv_CBBUCKET”,
“namespace”: “default”,
“using”: “gsi”
},
{
#operator”: “Fetch”,
“keyspace”: “uv_CBBUCKET”,
“namespace”: “default”
},
{
#operator”: “Parallel”,
“~child”: {
#operator”: “Sequence”,
“~children”: [
{
#operator”: “Filter”,
“condition”: “((uv_CBBUCKET.id) = “000000000”)”
},
{
#operator”: “InitialProject”,
“result_terms”: [
{
“expr”: “self”,
“star”: true
}
]
},
{
#operator”: “FinalProject”
}
]
}
}
]
},
“text”: "SELECT * from uv_CBBUCKET WHERE id = “000000000"”
}

What is the id in your select statment? Is that meant to be the documentId or do you have a field called id?
Can you post an example document.

{
“0”: “000000000”,
“1”: "junk@junk.com",
“2”: “13331”,
“3”: "junk@junk.com",
“4”: “AA.MAS.MT.RES.NM”,
“5”: “13331.13331.13331.13331”,
“6”: “…17349.17349”,
“7”: "junk@junk.com",
“8”: “”,
“9”: “TEST”,
“10”: “\n”
}

{
“id”: “000000000”,
“rev”: “1-15224bd3d45a00000000000002000000”,
“expiration”: 0,
“flags”: 33554432
}

thank you

this may be my problem I never created a ID field I just it in the gui, and document edit screen I am able to do a lookup ID using what I think is the id and it works but maybe selects are different?

If you want to use document key use META().id

SELECT * from uv_CBBUCKET WHERE META().id = “000000000”