Ashwini, Does your bucket have a password? N1QL does not yet work with SASL buckets.
On Thu, Oct 16, 2014 at 12:27 AM, ashwini ahire <[email protected]> wrote: > Hello Gerald, > > Please see below o/p > > cbq> SELECT b FROM ifa AS b LIMIT 1 > { > "error": > { > "caller": "view_index:200", > "code": 5000, > "key": "Internal Error", > "message": "Bucket ifa not found." > } > } > > > Also Group by not working in N1QL > > cbq> select count(u[1]) as telco , u[0] as country from ifa group by u[0] > { > "error": > { > "caller": "view_index:200", > "code": 5000, > "key": "Internal Error", > "message": "Bucket ifa not found." > } > } > > > > Regards, > Ashwini Ahire > > > On Wed, Oct 15, 2014 at 11:27 PM, Gerald <[email protected]> wrote: > >> Hi Ashwini, >> >> Please post the results of the following: >> >> SELECT b FROM __your-bucket-name__ AS b LIMIT 1 >> >> >> On Tuesday, October 14, 2014 6:08:50 AM UTC-7, Ashwini Ahire wrote: >>> >>> couchbase 3.0 Enterprise is compatible with N1QL Developer Preview 3 ? >>> What are the steps to connect to bucket.? >>> >>> I have one bucket having document like below >>> >>> >>> [ >>> 356, >>> 422, >>> 9170******* >>> ] >>> >>> If i want to select mobile number where telco is 356 then what will be >>> query in n1ql >>> >>> -- >> 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 a topic in the > Google Groups "Couchbase" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/couchbase/2WSS4bG4dc0/unsubscribe. > To unsubscribe from this group and all its topics, 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.
