Sounds like an opportunity for drill triggers Sent from my iPhone
> On Sep 22, 2015, at 2:18 PM, Edmon Begoli <[email protected]> wrote: > > Yes, that is my current thinking and most likely course of action. > >> On Tue, Sep 22, 2015 at 3:13 PM, Paul Ilechko <[email protected]> wrote: >> >> Perhaps you could implement something external to Drill to watch the file >> directory (inotify?) and trigger a program that makes calls to Drill >> through JDBC/ODBC. >> >>> On Tue, Sep 22, 2015 at 2:18 PM, Edmon Begoli <[email protected]> wrote: >>> >>> Has anyone tried, and is there a possible a facility to trigger Drill >>> queries to recalculate some aggregates statistics if the underlying data >>> has changed. >>> >>> My scenario is pretty simple - I use Drill to query directories of files >> to >>> mine some statistics out. >>> >>> Files are arriving at some reasonable frequency, once an hour or even >> once >>> a da >>> >>> I want to implement an event handler that observes these file arriving >>> "events" and that triggers Drill queries. >>> >>> Has anyone done anything like this already, and do you have any suggested >>> approaches, specially if they are Drill-specific. >>> >>> Thank you, >>> Edmon >> >> >> >> -- >> ---------------------------------- >> Paul Ilechko >> Senior Systems Engineer >> MapR Technologies >> 908 331 2207 >>
