karthik created IGNITE-15321: -------------------------------- Summary: Failing to load CSV data to a table in ignite Key: IGNITE-15321 URL: https://issues.apache.org/jira/browse/IGNITE-15321 Project: Ignite Issue Type: Bug Components: jdbc Affects Versions: 2.10 Reporter: karthik
Trying to load a csv file data, to a table. It is failing with the below error. 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]") 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 {color:#ff8b00}*sampledata*{color}(CandidateName, CandidateAddress, ADDRESSCITY, ADDRESSSTATE, ADDRESSZIP, ADDRESSCOUNTRYNAME, Email, phone) FORMAT CSV; The copy command works fine if table name is in capital letters, below command works copy from '/home/costrategix/qgrid/PL_Candidate.csv' into {color:#de350b}*SAMPLEDATA*{color}(CandidateName, CandidateAddress, ADDRESSCITY, ADDRESSSTATE, ADDRESSZIP, ADDRESSCOUNTRYNAME, Email, phone) FORMAT CSV; -- This message was sent by Atlassian Jira (v8.3.4#803005)