Implement spatial query functionality in Drill to provide location based queries and filtering. It could be similar to PostGIS for Postgres and allow queries like:
select * from
(select columns as location, columns as lon, columns as lat,
ST_DWithin(ST_Point(-121.895, 37.339), ST_Point(columns, columns), 0.1) as isWithin
where isWithin = true;
Working proposal is available at http://github.com/k255 (see drill-gis and drill fork).