If you are using the JDBC plugin to connect to SqlServer, which is a community
storage plugin, performance might be sub-optimal.
If you are trying to do a table scan, you also have the possibility that the
data being streamed is very large. Your terminal might be the bottleneck for
having to
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`,
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
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`,