Here is the code based on the specification provided:

Collecting Distinct Users by Day from the Last 90 Days Only When Older Than Last 90 Days Using SQL Queries

Understanding Date Functions in Hive: Best Practices for Data Analysis

Optimizing Hive Queries: A Complex Query to Retrieve Index and Next Element from Arrays