Enable LOAD DATA LOCAL INFILE


Hadoop Eco System Forums Hadoop Discussion Forum Enable LOAD DATA LOCAL INFILE

This topic contains 0 replies, has 1 voice, and was last updated by  Siva 2 years, 7 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #3333

    Siva
    Keymaster

    we need to edit is the /etc/mysql/my.cnf file. Just:

    sudo nano /etc/mysql/my.cnf
    Then add:

    [mysqld]
    local-infile

    [mysql]
    local-infile
    The headers [mysqld] and [mysql] are already given, just locate them in the file and add local-infile underneath each of them.

    then restart mysql service with below command

    sudo service mysql restart

    login to mysql with –local-infile argument like shown in below

    mysql -u root -p –local-infile

Viewing 1 post (of 1 total)

The topic ‘Enable LOAD DATA LOCAL INFILE’ is closed to new replies.

Review Comments
default image

I have attended Siva’s Spark and Scala training. He is good in presentation skills and explaining technical concepts easily to everyone in the group. He is having excellent real time experience and provided enough use cases to understand each concepts. Duration of the course and time management is awesome. Happy that I found a right person on time to learn Spark. Thanks Siva!!!

Dharmeswaran ETL / Hadoop Developer Spark Nov 2016 September 21, 2017

.