blaze / blaze/odo

Error while inserting data to database from csv in remote MySQL

Open
#620 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
1k
Forks
131
PR merge metrics
No merged PRs in 30d

Description

Hi,
I am trying to read CSV dynamically and then by using ODO creating a table schema and hence inserting the CSV data into it. ODO is able to create the table schema successfully but raising error while inserting data into the same table. It is not able to insert a single row.
Also is it possible to create a connection string? I am using the following parameter in string
"host", "user", "passwd", "db", "local_infile"
For this my URI is

odo('G:/django/ml_app/documents/demo.csv', 'mysql://abc:abc1234@abc.cxu0mytwya5e.us-east-1.rds.amazonaws.com/abcdb::testTbl9', delimiter='|')

But I am getting the following error. (I have replaced gpa by abc)

![screenshot 31](https://user-images.githubusercontent.com/31474139/50761453-68f70b00-1238-11e9-9aac-18910187a4cc.png)

Any help would be appreciated!!!

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.