Hi Ashwini, Please post the output of:
select ifa from ifa limit 1 On Thu, Oct 16, 2014 at 11:51 PM, Ashwini Ahire <[email protected]> wrote: > 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 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.
