Hi Ashwini, The fields you want are:
select ifa.u[0] select ifa.u[1] select ifa.u[2] For your third field, I would recommend that you load it as a string. In DP4, we will also add an option to avoid scientific notation. Thanks. On Sat, Oct 18, 2014 at 3:14 AM, Ashwini Ahire <[email protected]> wrote: > Hello Gerald, > > Please see below output. > Also adding to previous email's questions , My third filed is mobile > number .. But its coming in different format > > > cbq> select * from ifa limit 1 > { > "resultset": [ > { > "u": [ > 764, > 924, > 6.689735454e+10 > ] > } > ], > "info": [ > { > "caller": "http_response:160", > "code": 100, > "key": "total_rows", > "message": "1" > }, > { > "caller": "http_response:162", > "code": 101, > "key": "total_elapsed_time", > "message": "149.476888ms" > } > ] > } > > > 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.
