Hello Gerald,
Thanks for your reply , It got resolve when i reset my bucket pwd to blank.
I have one quick question if could help me with this.
how to query below data , If my profile is stored in plain array.
[
123, - > country Code
865, -> Telco
456789079 -> Mobilenumber
]
My If i want to select Telco count by country wise , then how to use this
array in query.
select doc[0] from ifa limit 1 ;
above query is not working.
Or i will have to update my all profiles with at list one key , eg
{
"u": [
123,
865,
456789097
]
}
Then i did query like select u[0] from ifa limit 1 ; and it works
SO , DO i Need to ADD "u" for all profiles which are already exist
Regards,*Ashwini Ahire *| Database Administrator
*m.* 9819012750
<http://www.vserv.com/>
*Media Company Of The Year.* MMA Smarties
*Red Herring Top 100.* Asia
*mBillionth Award.* South Asia
*MEET US AT*
*GamesBeat:* 15-16 Sep 2014; San Francisco, USA
*GMIC Bangalore:* 26 Sep 2014; Bangalore, India
*etailing India Summit:* 27 Sep 2014; Delhi, India*Mumbai* | New Delhi |
Singapore | London | San Francisco | Jakarta | Kuala Lumpur | Cape Town[image:
Facebook] <https://www.facebook.com/vserv>[image: Twitter]
<https://twitter.com/vserv>[image: Google Plus]
<https://plus.google.com/101344714192429270043/posts>[image: You Tube]
<https://www.youtube.com/user/vservmobi>[image: Linked In]
<http://www.linkedin.com/company/vserv-mobi>
On Thu, Oct 16, 2014 at 12:57 PM, 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.
>
--
*************************
*CONFIDENTIALITY CAUTION*
*This communication (including any accompanying documents) is intended only
for the use of the addressee(s) and contains PRIVATE AND CONFIDENTIAL
information. Unauthorized reading, dissemination, distribution or copying
of this communication is prohibited. If you have received this
communication in error, please notify us immediately by e-mail and promptly
destroy the original communication. Please do not copy it or use it for any
other purposes, or disclose its contents to any other person. Unless stated
to the contrary, any opinions or comments are personal to the writer and do
not represent the official view of the Company. In case where it represents
our official view, it needs to be revalidated and is subject to the terms
of our engagement.*
*Thank you for your co-operation.*
*************************
--
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.
