drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sanjiv Kumar C <sanj...@ejeeva.com>
Subject Re: Drill taking more time to show output
Date Mon, 20 Feb 2017 07:28:01 GMT
Query Profile

STATE: CANCELLATION_REQUESTED

FOREMAN: XXXXX.com

TOTAL FRAGMENTS: 1


Major Fragment: 00-xx-xx
<http://192.168.10.37:8047/profiles/2755683d-810b-6588-25a3-49e09b9f4d3e#fragment-0>

On Fri, Feb 17, 2017 at 5:17 PM, Sanjiv Kumar C <sanjivc@ejeeva.com> wrote:

> Drill Environment:- Version: 1.9
>                             Operating System: Linux
>                             Mode: Embedded mode.
>
> I have table in sql server  having 16 lakh of data. While query through
> drill having limit 5 but still drill take more time to show output (more
> than 15 min)
>
> Ex:- select * from <pluginName).<schemaName>.<tableName> limit 5;
>
> What should i do?
>
> --
> Thanks & Regards
>   * Sanjiv Kumar*
>



-- 
Thanks & Regards
  * Sanjiv Kumar*

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message