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

issues handling importing csv with date typed fields #172

Closed
wey-gu opened this issue Apr 1, 2022 · 1 comment
Closed

issues handling importing csv with date typed fields #172

wey-gu opened this issue Apr 1, 2022 · 1 comment
Labels
affects/master PR/issue: this bug affects master version. process/done Process of bug severity/major Severity of bug type/bug Type: something is unexpected

Comments

@wey-gu
Copy link
Contributor

wey-gu commented Apr 1, 2022

Describe the bug (must be provided)

It seems when a field with type date was configured in the studio, with a field like 2020-01-01 in CSV, it will fail.
Whereas in importer, it should be working:


https://github.com/vesoft-inc/nebula-importer/blob/617990914cfe30a906351f3eb2f7ca697555dfd4/examples/v2/example.yaml#L415-L435

https://github.com/vesoft-inc/nebula-importer/blob/master/examples/v2/date_test.csv

Your Environments (must be provided)

  • OS: Linux,Mac or Windows
  • Node-version: node --version
  • Studio-version: v3.2.3

How To Reproduce(must be provided)

Steps to reproduce the behavior:

  1. Step 1 create schema like

Screen Shot 2022-04-01 at 10 14 25 AM

  1. Step 2 prepare data like
"v1",2020-01-01
"v2",2020-01-02
  1. Step 3 import like

Screen Shot 2022-04-01 at 10 15 23 AM

  1. It failed as:
$ docker logs nebula-graph-studio-v323_web_1 --since 20m
[INFO] 2022/04/01 02:04 200 1.175753ms 192.168.9.3 PUT /api/files
[INFO] 2022/04/01 02:04 200 191.017µs 192.168.9.3 GET /api/files
[INFO] 2022/04/01 02:04 200 1.999393ms 192.168.9.3 POST /api-nebula/db/exec
[INFO] 2022/04/01 02:04 200 2.166102ms 192.168.9.3 POST /api-nebula/db/exec
[INFO] 2022/04/01 02:04 200 1.558106ms 192.168.9.3 POST /api-nebula/db/exec
1.6487787003726132e+09	warn	controller/gateway.go:56	gql execute fail	{"error": "-1005:Storage Error: The data type does not meet the requirements. Use the correct type of data."}

Expected behavior

Import successfully

Additional context

Provide logs and configs, or any other context to trace the problem.

@hetao92
Copy link
Contributor

hetao92 commented Apr 1, 2022

we will fix this in v3.3.0

@Sophie-Xie Sophie-Xie added the type/bug Type: something is unexpected label Nov 30, 2022
@HarrisChu HarrisChu added affects/none PR/issue: this bug affects none version. severity/none Severity of bug labels Dec 1, 2022
@hetao92 hetao92 closed this as completed Dec 9, 2022
@github-actions github-actions bot added the process/fixed Process of bug label Dec 9, 2022
@liangliangc liangliangc added affects/master PR/issue: this bug affects master version. severity/major Severity of bug and removed severity/none Severity of bug labels Jan 3, 2023
@github-actions github-actions bot removed the affects/none PR/issue: this bug affects none version. label Jan 3, 2023
@liangliangc liangliangc added process/done Process of bug and removed process/fixed Process of bug labels Feb 6, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects/master PR/issue: this bug affects master version. process/done Process of bug severity/major Severity of bug type/bug Type: something is unexpected
Projects
None yet
Development

No branches or pull requests

5 participants