Can you post the results of: select ifa from ifa limit 1
Thanks. On Sun, Oct 19, 2014 at 9:25 PM, Ashwini Ahire <[email protected]> wrote: > Hello Gerald, > > As i said in my previous email , i had just added "u" as prefix for > testing. > But in my Original Profile "u" is not present , Below is my profile. > > [ > 764, > 924, > 668973545410 > ] > > > cbq> select * from ifa limit 1; > { > "resultset": [ > {} > ], > "info": [ > { > "caller": "http_response:160", > "code": 100, > "key": "total_rows", > "message": "1" > }, > { > "caller": "http_response:162", > "code": 101, > "key": "total_elapsed_time", > "message": "111.904553ms" > } > ] > } > > Please let me know how to select each filed. because here u[0],u[1] wont > work. > > > 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 Sun, Oct 19, 2014 at 4:56 AM, Gerald Sangudi <[email protected]> wrote: > >> 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 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.
