You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Sanjiv Kumar <kt...@gmail.com> on 2016/08/29 11:06:27 UTC
Speed Up Drill
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.
My question is is there any way to speed up my drill, so that query execute
fast.?
Re: Speed Up Drill
Posted by Magnus Pierre <mp...@maprtech.com>.
Hello Sanjiv,
It is a simple select with no filters or conditions and a few casts going against a database table. Can’t see how it could be possible to improve the query. Drill will ask for the whole table.Are you accessing the data directly in Drill through the cmd-line or using the web-ui or if you are using a JDBC driver towards Drill and query from another tool?
Without knowing more about what you try to do, one thing you could do is to create a CTAS rather than returning the result in Drill. This is potentially much faster since you skip the visualization of the data, but I guess you want to do something with the data once over?
Regards,
Magnus
> 29 aug 2016 kl. 13:06 skrev Sanjiv Kumar <kt...@gmail.com>:
>
> 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.
>
> My question is is there any way to speed up my drill, so that query execute
> fast.?