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

Not able to do bulk load in aws neptune from aws s3 #120

Open
mansimht opened this issue Dec 28, 2022 · 1 comment
Open

Not able to do bulk load in aws neptune from aws s3 #120

mansimht opened this issue Dec 28, 2022 · 1 comment
Labels
question Further information is requested

Comments

@mansimht
Copy link

I am not able to do neptune bulk load from aws s3 bucket. Loading failed comes when I load data from s3 bucket to neptune.
Command:
awscurl -X POST --service neptune-db -H 'Content-Type: application/json' --region us-east-2 \

https://:8182/loader -d'
{
"source" : "s3:///Unsaved/2022/12/13/4a873928-9910-47b0-85ca-de593ace4f4a.csv",
"format" : "csv",
"iamRoleArn" : "arn:aws:iam::959061167427:role/NeptuneLoadFroms3",
"region" : "us-east-2",
"failOnError" : "FALSE"
}'
Output:
{
"status" : "200 OK",
"payload" : {
"loadId" : "37aeb194-677a-4cdf-a577-dae8684a6681"
}
}
Command: awscurl --service neptune-db 'https://:8182/loader/37aeb194-677a-4cdf-a577-dae8684a6681' --region us-east-2
output:
{
"status" : "200 OK",
"payload" : {
"feedCount" : [
{
"LOAD_COMPLETED" : 1
},
{
"LOAD_FAILED" : 1
}
],
"overallStatus" : {
"fullUri" : "s3://
**/Unsaved/2022/12/13/4a873928-9910-47b0-85ca-de593ace4f4a.csv",
"runNumber" : 1,
"retryNumber" : 12,
"status" : "LOAD_FAILED",
"totalTimeSpent" : 3,
"startTime" : 1672193300,
"totalRecords" : 1,
"totalDuplicates" : 0,
"parsingErrors" : 1,
"datatypeMismatchErrors" : 0,
"insertErrors" : 0
}
}
}

Can anyone help me with this ?

@krlawrence
Copy link
Contributor

Are you using a specific sample from this rep or just having a general issue bulk loading data into Neptune? For general questions it is better to open a support case (if you are able) or to ask on re:Post at https://repost.aws/tags/TAxVAEdWg1SrS0lClUSX-m_Q/amazon-neptune. That said it looks like the loader is reporting a parsingError in one of the files. If you add ?errors=true&details=true to the command to get the load status, is any more information shown?

@krlawrence krlawrence added the question Further information is requested label Dec 28, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants