Description
Currently, JDBCRDD uses fixed format for SELECT statement.
val sqlText = options.prepareQuery + s"SELECT $columnList FROM ${options.tableOrQuery} $myTableSampleClause" + s" $myWhereClause $getGroupByClause $getOrderByClause $myLimitClause $myOffsetClause"
But some databases have different syntax that uses different keyword or sort. For example, MS SQL Server uses keyword TOP to describe LIMIT clause or Top N.
The LIMIT clause of MS SQL Server.
SELECT TOP(1) Model, Color, Price
FROM dbo.Cars
WHERE Color = 'blue'
The Top N of MS SQL Server.
SELECT TOP(1) Model, Color, Price
FROM dbo.Cars
WHERE Color = 'blue'
ORDER BY Price ASC