Determining Prolific Authors
You can identify prolific authors of your textual data without using any of the Pulse functions. For example, using the same dataset as the examples in Determining Popular Topics, you can easily determine how many tweets were made by authors:
select "user.name", count(*) as post_count from tweets group by
"user.name" order by count(*) DESC limit 10;
user.name | post_count ----------------------+------------ Nick Cicero | 182 Networked Society | 171 AllThingsD | 137 Stephanie~ | 117 Jennifer Ives | 105 Claudia-ElasticMinds | 101 Needful Things | 96 Poptart Tech | 85 Patrick Bertrand | 84 Alessandro Piol | 81 (10 rows)