Unable to connect mysql from Sqoop

Discussion in 'Masters Program - Customers only' started by _42607, Feb 6, 2019.

  1. _42607

    _42607 Member

    Joined:
    Oct 3, 2018
    Messages:
    9
    Likes Received:
    0
    Hi, I am unable to connect mysql from sqoop and i am getting the attached error. Can anyone please help me on it. thanks. Sqoop error.PNG
     
    #1
  2. ruhi.jain

    ruhi.jain Well-Known Member
    Simplilearn Support

    Joined:
    Jun 7, 2018
    Messages:
    192
    Likes Received:
    2
    Hi,

    Thank you for reaching out to us.

    I see that the import has already happened. Kindly see the screenshot below for your reference:
    upload_2019-2-9_10-50-21.png

    Please find the correct command below for your reference:
    sqoop import --connect jdbc:mysql://ip-10-0-1-10.ec2.internal/aburar_simplilearn --username labuser --password simplilearn --table student --target-dir /user/faid2n_gmail/aburar123 --m 1

    I hope this helps:)
     
    #2
  3. _42607

    _42607 Member

    Joined:
    Oct 3, 2018
    Messages:
    9
    Likes Received:
    0
    Hi Ruhi, Thanks for your response. i have imported this file using hdfs command. But my issue is, i am unable to connect mysql using sqoop.
     
    #3
  4. _42607

    _42607 Member

    Joined:
    Oct 3, 2018
    Messages:
    9
    Likes Received:
    0
    Hi Ruhi, Sorry i didn't see your last line in your post. Now i am able to connect mysql. Thanks a lot.
     
    #4
  5. ruhi.jain

    ruhi.jain Well-Known Member
    Simplilearn Support

    Joined:
    Jun 7, 2018
    Messages:
    192
    Likes Received:
    2
    Thank you for the update:)
     
    #5
  6. ruhi.jain

    ruhi.jain Well-Known Member
    Simplilearn Support

    Joined:
    Jun 7, 2018
    Messages:
    192
    Likes Received:
    2
    Thank you for the update:)
     
    #6

Share This Page