Mailing-List: contact dev-help@asterixdb.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@asterixdb.incubator.apache.org
MIME-Version: 1.0
In-Reply-To: <FF01F07D-A0AA-49B3-9BD8-CB22D7104C8A@gmail.com>
References: <FF01F07D-A0AA-49B3-9BD8-CB22D7104C8A@gmail.com>
Date: Wed, 9 Dec 2015 10:41:14 -0800
Message-ID: 
 <CALjEsF5FDgCUEJfA6wpkJjBhx-n379UnWSnhOD4j8kQ1_gCK-Q@mail.gmail.com>
Subject: Re: How to calculate the word count in AQL?
From: Yingyi Bu <buyingyi@gmail.com>
To: dev@asterixdb.incubator.apache.org
Content-Type: multipart/alternative; boundary=94eb2c0b7316539c1905267b6fec

--94eb2c0b7316539c1905267b6fec
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

This probably is the query you want:

for $ts in $hashtags
for $t in $ts
group by $tag:=3D$t with $t
return {"g": $tag, count($t)}


On Wed, Dec 9, 2015 at 10:34 AM, Jianfeng Jia <jianfeng.jia@gmail.com>
wrote:

> Hi devs,
>
> Here is my use case, each tweets has a set of hashtags. Here is the
> hashtags example for the first five tweets:
> [ {{ "Samibeigi" }}, {{ "LeadwithGiants" }}, {{ "MountainView",
> "Healthcare", "Job" }}, {{ "SanFrancisco", "job", "NettempsJobs", "IT",
> "Hiring", "CareerArc" }}, {{ "BeGreat" }} ]
> I want to calculate the most frequent hashtag in all tweets.
>
> I could generate a internal group count as following
>
> let $inner :=3D for $x in $hashtags
> return
> for $xx in $x
> group by $xx with $xx
> return { "g": $xx[0], "c": count($xx)}
>
> It will return a list of list,
> [ { "g": "Samibeigi", "c": 1 } ]
> [ { "g": "LeadwithGiants", "c": 1 } ]
> [ { "g": "Healthcare", "c": 1 }, { "g": "Job", "c": 1 }, { "g":
> "MountainView", "c": 1 } ]
> [ { "g": "CareerArc", "c": 1 }, { "g": "Hiring", "c": 1 }, { "g": "IT",
> "c": 1 }, { "g": "NettempsJobs", "c": 1 }, { "g": "SanFrancisco", "c": 1 =
},
> { "g": "job", "c": 1 } ]
> [ { "g": "BeGreat", "c": 1 } ]
>
> I would expect to add a flatten function to the list which will give me a
> list of record, then I can groupby the =E2=80=9Cg". Do we have such AQL f=
unctions?
> Thank you.
>
> Best,
>
> Jianfeng Jia
> PhD Candidate of Computer Science
> University of California, Irvine
>
>

--94eb2c0b7316539c1905267b6fec--