I also need IP addreess information. Historical tables dont have ip address.
HTTP_request has ip address. I donot know,if i can join http_request table to historical tables.
You can indeed using user_id as your common field between http_requests and hist_users.
Well I thought about that.
Upon checking Number of records for given date and user id between http request and historical events table do not match. It made me thinking, is it correct join.
Also there are many nulls and zeros in user id columns in http request table