drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Khurram Faraaz <kfar...@maprtech.com>
Subject Re: Speed up Drill
Date Thu, 01 Sep 2016 11:24:20 GMT
You are doing a scan over a file, and there is no predicate/filter in your
query, which means Drill will have to Scan the entire file.

Also Apache Drill's latest released version is 1.8.0, you may want to try
your query on Apache Drill 1.8.0.

On Thu, Sep 1, 2016 at 11:34 AM, <sanjivktr@yahoo.com.invalid> wrote:

>  Hello    I am using Drill in Window 10 in embedded mode having latest
> version (1.7).I am writing one select Query for Sql Server Database.
> Query is:-
> SELECT CAST(T1.`ID` AS BIGINT) AS `ID`, CAST(T1.`AttributeID` AS BIGINT)
> AS `AttributeID`, T1.`String_Value` AS `String_Value`,
> CAST(T1.`Numeric_Value` AS BIGINT) AS `Numeric_Value`, T1.`MetaData` AS
> `MetaData`, T1.`DataType` AS `DataType`, T1.`CreatedTime` AS `CreatedTime`,
> CAST(T1.`CreatedBy` AS BIGINT) AS `CreatedBy` FROM demoplugin.`dbo`.`ProductValues`
> AS T1
> Result:- It returns 1,113,843 rows in 107.126 Second. ( Too much time)
> My question is is there any way to speed up my drill, so that query
> execute fast.?
>
> Sent from Yahoo Mail. Get the app

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