I tried to move Zero analytics to the new table, and decided to test the new wonderful fields like agent_type ... and it only works on the most recent hours of data. This query is ok:
select distinct agent_type from webrequest where webrequest_source='mobile' and year=2015 and month=4 and day=10 and hour=23;
This fails
select distinct agent_type from webrequest where webrequest_source='mobile' and year=2015 and month=4 and day=10 and hour=13;
At first I thought it was the 13th hour, but anything before that also fails.
Caused by: java.lang.IllegalStateException: Column agent_type at index 28 does not exist in {dt=dt, uri_path=uri_path, accept_language=accept_language, range=range, client_ip=client_ip, x_analytics_map=x_analytics_map, x_cache=x_cache, content_type=content_type, is_pageview=is_pageview, geocoded_data=geocoded_data, x_analytics=x_analytics, x_forwarded_for=x_forwarded_for, cache_status=cache_status, response_size=response_size, hostname=hostname, record_version=record_version, uri_query=uri_query, uri_host=uri_host, ip=ip, http_method=http_method, http_status=http_status, time_firstbyte=time_firstbyte, user_agent_map=user_agent_map, sequence=sequence, user_agent=user_agent, referer=referer}Even simpler - this fails:
select * from webrequest where webrequest_source='mobile' and year=2015 and month=4 and day=10 and hour=23 limit 10;