Hello! It's strange, but my expectation here is that "Exchange:Ticker" is not a proper name for a column. Is it? I expect it to be [Exchange:Ticker] if it's real.
SQLServerDialect should be able to quote column names so I'm having trouble understanding what happens here. Can anybody with SQL Server instance chime in? Regards, -- Ilya Kasnacheev 2018-08-20 14:58 GMT+03:00 wt <waynethe...@gmail.com>: > here is the exact query intercepted > > declare @p1 int > set @p1=NULL > exec sp_prepexec @p1 output,N'@P0 nvarchar(4000),@P1 > nvarchar(4000)',N'SELECT CompanyId,CompanyName,Country,Region,Peer > Group,Company Type,ExtractionDate,Exchange:Ticker,Exchange,Ticker,Legal > Entity Identifier,Bloomberg Ticker,Bloomberg Global Composite ID,Bloomberg > Global ID,Bloomberg Share Class BBGID,Bloomberg Unique ID,ISIN,CUSIP,Entity > Type,Research Entity ID,Research Entity Name,Research > type,Record_Valid_From,Record_Valid_To FROM SustainAnalytics.Company WHERE > (CompanyId > @P0 ) AND (CompanyId <= @P1 ) > ',N'1007910068',N'1007990548' > select @p1 > > > here is the error returned when i run that which fits the exception thrown > when the load code is called > > Msg 102, Level 15, State 1, Line 1 > Incorrect syntax near ','. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >