You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Karthik Nandagiri <ka...@costrategix.com> on 2021/08/12 16:22:58 UTC
Failing to load CSV
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,zxx@gmail.com
,000-000-000
n2,231 Belmont Ave. # 305,Seattle,WA,98102,United States,abc@gmail.com
,000-000-0000
n3,5338 Saint Andrews Dr,Stockton,CA,95219,United States,sabn@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
Re: Failing to load CSV
Posted by Stephen Darlington <st...@gridgain.com>.
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 <ka...@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,zxx@gmail.com <ma...@gmail.com>,000-000-000
> n2,231 Belmont Ave. # 305,Seattle,WA,98102,United States,abc@gmail.com <ma...@gmail.com>,000-000-0000
> n3,5338 Saint Andrews Dr,Stockton,CA,95219,United States,sabn@gmail.com <ma...@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