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 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.