Paging and Table Limits
http://developer.yahoo.com/yql/guide/paging.html

hello.api({limit}) will only work for 10 rows, no more than that. Unless you set the remote limit to maximum e.g. social.profile(0) to return all rows.