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,[[email protected]|mailto:[email protected]],000-000-000
n2,231 Belmont Ave. # 305,Seattle,WA,98102,United
States,[[email protected]|mailto:[email protected]],000-000-0000
n3,5338 Saint Andrews Dr,Stockton,CA,95219,United
States,[[email protected]|mailto:[email protected]],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)
