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, <[email protected]> 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
