Why followers/ids gives set of followers of particular user with duplicate ids


#1

I am trying to get followers for a user by passing screen_name to the url: https://api.twitter.com/1.1/followers/ids.json.
But the problem is I am getting a result set containing duplicate user_ids such as:
I fetched 75,000 records as followers for single user, among those 43,625 records contains 2147483647 user id.
Why 2147483647 user_id is being repeated?

Any urgent help will be highly appropriated.
Thanks


#2

Got solution :slight_smile:

I was storing user_id in a 32 bit int column, but twitter have 64bit user_id. Because of that it was truncating the bits greater than 32. It was fixed by saving user_id in 64 bit BIGINT .