This looks like a bug in Ignite 2.10. It works correctly in 2.9.1 as far as I can tell. Can you raise a ticket? issues.apache.org <http://issues.apache.org/>.
> On 12 Aug 2021, at 17:22, Karthik Nandagiri > <karthik.nandag...@costrategix.com> wrote: > > Hi , > > I am trying to load a csv file data, to a table. It is failing with the below > error.So need help to understand this > > Table created > > create table if not exists pl_candidate(CandidateName > varchar(100),CandidateAddress varchar(100),ADDRESSCITY > varchar(100),ADDRESSSTATE varchar(100),ADDRESSZIP > varchar(100),ADDRESSCOUNTRYNAME varchar(100),Email varchar(100),phone > varchar(100) primary key); > > and the sample data > N1,1436 Bayshore Dr Apt 1A,Columbus,Ohio,43204,United States,z...@gmail.com > <mailto:z...@gmail.com>,000-000-000 > n2,231 Belmont Ave. # 305,Seattle,WA,98102,United States,a...@gmail.com > <mailto:a...@gmail.com>,000-000-0000 > n3,5338 Saint Andrews Dr,Stockton,CA,95219,United States,s...@gmail.com > <mailto:s...@gmail.com>,000-000-0000 > > > copy command > > copy from '/home/costrategix/qgrid/PL_Candidate.csv' into > sampledata(CandidateName, CandidateAddress, ADDRESSCITY, ADDRESSSTATE, > ADDRESSZIP, ADDRESSCOUNTRYNAME, Email, phone) FORMAT CSV; > > Failed to execute SQL query [reqId=24, req=JdbcQueryExecuteRequest > [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=copy from > '/home/costrategix/qgrid/PL_Candidate.csv' into sampledata(CandidateName, > CandidateAddress, ADDRESSCITY, ADDRESSSTATE, ADDRESSZIP, ADDRESSCOUNTRYNAME, > Email, phone) FORMAT CSV, args=Object[] [], stmtType=ANY_STATEMENT_TYPE, > autoCommit=true, partResReq=false, explicitTimeout=false, super=JdbcRequest > [type=2, reqId=24]]] > class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed > to parse SQL statement "copy from '/home/costrategix/qgrid/PL_Candidate.csv' > into sampledata([*]CandidateName, CandidateAddress, ADDRESSCITY, > ADDRESSSTATE, ADDRESSZIP, ADDRESSCOUNTRYNAME, Email, phone) FORMAT CSV": > Failed to parse SQL statement "copy from > '/home/costrategix/qgrid/PL_Candidate.csv' into sampledata([*]CandidateName, > CandidateAddress, ADDRESSCITY, ADDRESSSTATE, ADDRESSZIP, ADDRESSCOUNTRYNAME, > Email, phone) FORMAT CSV": Unexpected token: "CANDIDATENAME" (expected: > "[identifier]") > > > Regards > > Karthik N
