CouchBase에 Array로 저장된 내용을 N1QL로 SELECT 하려면!?

gomdor(32)
Published in
#couchbase
Words
31
Reading
1 min
Listen
Play
9y

CouchBase에 Array로 저장된 내용을 N1QL로 SELECT 하려면!?

  • UNNEST 를 이용!

SELECT UN.* FROM target-bucket UNNEST target-bucket as UN

CouchBase에서 document id도 함께 SELECT 하려면?

  • meta(t).id 를 이용!

SELECT meta(target-bucket).id as docId, * FROM target-bucket

couchbase
tip
via steemkr
This post was published via steemkr. Ecency is not the originator or editor of this content and displays it for discovery purposes only.
1
CouchBase에 Array로 저장된 내용을 N1QL로 SELECT 하려면!? | Ecency