drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <sanjiv...@yahoo.com.INVALID>
Subject Speed up Drill
Date Thu, 01 Sep 2016 06:04:56 GMT
 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