N1QL - Insert-Select

Question

I'm trying to execute an insert-select statement in N1QL (inserting documents that their key/value are the result of a select statement) and I'm failing to understand the syntax.

I tried executing:

insert into tempbucket (KEY payload.id,VALUE select * from default where payload.fooId in [100,101 ] )  RETURNING * ;

in some variations but nothing worked.

Edit: The SELECT statement is

select * from default where payload.fooId in [100,101 ]

The KEY of the documents I want to create is the value of the field key and the VALUE is the entire JSON of the SELECT statement mentioned above.

Please edit your question and separate out the following the 3 things: the SELECT statement to be used as your source; the part of the SELECT to be used as the KEY; the part of the SELECT to be used as the VALUE. Please put each in a separate paragraph for clarity. — geraldss, Jun 19 '16 at 19:01

score 2 · Accepted Answer · answered Jun 19 '16 at 22:05

2

The KEY and VALUE must reference expressions from your query.

INSERT INTO tempbucket (KEY d.`key`, VALUE d)
SELECT d
FROM default d
WHERE payload.fooId IN [100,101 ]
;

answered Jun 19 '16 at 22:05

geraldss

2,415
1
11
12

N1QL - Insert-Select

1 Answers1