FirstStart/LastStart indicates the query planning time. That indicates planner takes ~53 seconds to get the plan.
Is rpp_event_group or rpp_event a view or base table? The query you posted just contain a two table join. Seems 53s is too long to plan for such a query, unless either 'rpp_event_group' or 'rpp_event' is a view which contains join as well. On Wed, Sep 9, 2015 at 7:38 PM, Liu, Wen <[email protected]> wrote: > Here it is, > select a.url_txt as url, a.rpp_event_grp_id as grpid from > dfs.tdhdp.`rpp_event_group` as a, dfs.tdhdp.`rpp_event` as b where > a.site_id = 0 and b.active_ind = 1 and a.rpp_event_grp_id = > b.rpp_event_grp_id group by a.url_txt, a.rpp_event_grp_id > > > Below is the tdhdp definition: > "tdhdp": { > "location": "/user/tdhdp/latest", > "writable": true, > "defaultInputFormat": "parquet" > } > > Let me know if anything else needed. > > Thanks, > Wen > > > On 9/10/15, 10:31 AM, "Hsuan Yi Chu" <[email protected]> wrote: > > >Can you share your query ? What does it look like ? > > > >On Wed, Sep 9, 2015 at 7:24 PM, Liu, Wen <[email protected]> wrote: > > > >> Hi there, > >> I am running drillbit in localhost, and the zookeeper is also on the > >>same > >> host. I sent the same query multiple times, most of them response very > >> quickly(<500ms). But a few are slowly. On query profile page, I saw the > >> slow queries have a long time for "First Start" column, see below > >>sample. > >> Any hints what's the possible reason? > >> > >> I tried both 0.8.0 and 1.1.0, and got the same result. > >> > >> Major Fragment Minor Fragments Reporting First Start Last > >> Start First End Last End tmin tavg tmax > >>memmax > >> 00-xx-xx 1 / 1 53.668 53.668 53.877 53.877 0.209 0.209 > >> 0.209 27MB > >> > >> Thanks, > >> Wen > >> > >
