drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jinfengni <...@git.apache.org>
Subject [GitHub] drill pull request: DRILL-3623: Use shorter query path for LIMIT 0...
Date Wed, 28 Oct 2015 23:49:15 GMT
Github user jinfengni commented on the pull request:

    https://github.com/apache/drill/pull/193#issuecomment-152034091
  
    Sudheesh and I feel this new approach is more like a big optimization step towards solving
the performance issue for "limit 0" query, rather than hack solution :  1) It shows quite
significantly reduction in query time, from hundreds of seconds to couple of seconds in some
cases. That's a big improvement. 2) it would benefit not only schema-based query, but also
schema-less query, while the original approach would only apply for schema-based query. 
    
    I agree we should continue to optimize "limit 0" query. But for now, I think this new
approach has its own merits.
    
    The aggregation /implicit casting are the two things that I can think of, if we go with
the schema-based approach. 
     



---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

Mime
View raw message