Ok.
Please post the output of:
select ifa from ifa limit 1;
On Saturday, October 18, 2014 3:26:04 AM UTC-7, Ashwini Ahire wrote:
>
> Hello Gerald,
>
> Please ignore my Previous Reply , That was when i added "u" Prfix for each
> profile.
>
> Below is Original o/p
>
> 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"
> }
> ]
> }
>
>
> 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 Sat, Oct 18, 2014 at 3:44 PM, Ashwini Ahire <[email protected]
> <javascript:>> 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]
>> <javascript:>> 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] <javascript:>
>>> > 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] <javascript:>.
>>>> 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] <javascript:>.
>>> 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.
