| buyingyi | f3199d7 | 2012-11-28 11:27:57 +0000 | [diff] [blame] | 1 | drop dataverse OpenSocialNetworkData if exists; |
| 2 | create dataverse OpenSocialNetworkData; |
| 3 | |
| 4 | use dataverse OpenSocialNetworkData; |
| 5 | |
| 6 | create type TwitterUserType as open { |
| 7 | screen-name: string, |
| 8 | lang: string, |
| 9 | friends_count: int32, |
| 10 | statuses_count: int32, |
| 11 | name: string, |
| 12 | followers_count: int32 |
| 13 | } |
| 14 | |
| 15 | create type TweetMessageType as open { |
| 16 | tweetid: string, |
| 17 | tweetid-copy: string, |
| 18 | send-time-copy: datetime |
| 19 | } |
| 20 | |
| 21 | create dataset TweetMessages(TweetMessageType) |
| 22 | partitioned by key tweetid; |
| 23 | |
| 24 | load dataset TweetMessages |
| 25 | using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter" |
| 26 | (("path"="nc1://data/twitter/tw_messages.adm"),("format"="adm")); |
| 27 | |
| 28 | write output to nc1:"rttest/open-closed_query-issue208.adm"; |
| 29 | for $t in dataset('TweetMessages') |
| 30 | where $t.send-time >= datetime('2005-04-13T17:17:22') and |
| 31 | $t.send-time <= datetime('2011-04-13T17:18:22') |
| 32 | group by $uid := $t.user.screen-name with $t |
| 33 | order by $uid |
| 34 | return { |
| 35 | "user": $uid, |
| 36 | "count": count($t) |
| 37 | } |
| 38 | |