Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

apoc.load.csv does not skip properly #1505

Closed
cybersam opened this issue May 9, 2020 · 1 comment · Fixed by #1506
Closed

apoc.load.csv does not skip properly #1505

cybersam opened this issue May 9, 2020 · 1 comment · Fixed by #1506
Assignees

Comments

@cybersam
Copy link

cybersam commented May 9, 2020

Expected Behavior (Mandatory)

  • The skip option should produce proper results. For example, {skip: 1} should return data for every other CSV file line.

Actual Behavior (Mandatory)

  • {skip: 1} produces no results. So, there is no way to get every other line from the file.
    • However, {skip: 1, limit: 1} does return just the second data line, as expected.
  • Aside: oddly, {skip: -1} returns every line, but with a starting lineNo of -1.

How to Reproduce the Problem

Simple Dataset (where it's possibile)

name
Selma
Rana
Selina
Sam
Fred

Steps (Mandatory)

  1. The query CALL apoc.load.csv('file:///test.csv', {skip: 1}) YIELD map RETURN * should produce this result:
╒═════════════════╕
│"map"            │
╞═════════════════╡
│{"name":"Rana"}  │
├─────────────────┤
│{"name":"Sam"}   │
└─────────────────┘

but actually returns nothing.

Versions

  • OS: Mac OSX 10.15.3
  • Neo4j: 4.0.3
  • Neo4j-Apoc: 4.0.0.9
@cybersam cybersam changed the title apoc.load.csv does not skip properly apoc.load.csv does not skip properly May 9, 2020
@conker84
Copy link
Contributor

apoc-4.0.0.11-all.jar.zip

Hi @cybersam thanks a lot for reaching us, can you please try with the jar above?
Please unzip it into the plugins dir.
Thanks a lot

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants