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

Error while inserting data to database from csv in remote MySQL #620

Open
girijesh18 opened this issue Jan 7, 2019 · 0 comments
Open

Error while inserting data to database from csv in remote MySQL #620

girijesh18 opened this issue Jan 7, 2019 · 0 comments

Comments

@girijesh18
Copy link

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

Any help would be appreciated!!!

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

No branches or pull requests

1 participant