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]> 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 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.
