blaze / blaze/odo

Support "LOAD DATA LOCAL INFILE" in MySql

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

Description

I am trying to load a local csv file to a remote MySql server using odo lib, but I got the following error:

InternalError: (pymysql.err.InternalError) (1290, u'The MySQL server is running with the --secure-file-priv option so it cannot execute this statement') [SQL: u'LOAD DATA INFILE %(path)s\n INTO TABLE `GlobalObjects`\n CHARACTER SET %(encoding)s\n FIELDS\n TERMINATED BY %(delimiter)s\n ENCLOSED BY %(quotechar)s\n ESCAPED BY %(escapechar)s\n LINES TERMINATED BY %(lineterminator)s\n IGNORE %(skiprows)s LINES\n '] [parameters: {'lineterminator': '\n', 'encoding': 'utf8', 'skiprows': 1, 'delimiter': ',', 'escapechar': '\\', 'quotechar': u'"', 'path': '/tmp/my_table.csv'}]

It does not appear it use "LOCAL DATA LOCAL INFILE" statement, which is wrong for loading local file to remote server.

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.