The ID field should be spalled lowercase as “id”. There are a few examples here: http://blog.couchbase.com/2016/january/how-to-create-a-copy-of-your-bucket--how-to-transform-bucket-data-with-bulk-mutations-insert-update-delete-merge-in-n1ql
Thanks -cihan From: <[email protected]> on behalf of K Lakshmi <[email protected]> Reply-To: <[email protected]> Date: Sunday, April 24, 2016 at 10:38 PM To: Couchbase <[email protected]> Subject: Copying data from one bucket to another bucket Hi, I am new to couchbase. Can any one give suggestion on how to copy data from bucket 1 to bucket2? When i tried like INSERT INTO bucket_2(KEY,VALUE) SELECT META().ID,* FROM bucket_1 where $condition; It is showing error at SELECT. Thanks in advance. Lakshmi -- You received this message because you are subscribed to the Google Groups "Couchbase" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Couchbase" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
