Big Data Hadoop & Spark Developer | Amit Singh

Discussion in 'Big Data and Analytics' started by Koyel Sinha Chowdhury, Sep 29, 2019.

  1. Koyel Sinha Chowdhury

    Koyel Sinha Chowdhury Well-Known Member

    Joined:
    Feb 14, 2019
    Messages:
    72
    Likes Received:
    9
    #1
  2. Roopa R_1

    Roopa R_1 Member

    Joined:
    Aug 28, 2019
    Messages:
    6
    Likes Received:
    1
    hi amit,

    I get a error on executing below statement for import. my tables are in labtest DB. Can you please let me know error in it.
    Also where I find /USER folder . I didn't find in root folder
    sqoop import --connect jdbc:mysql://ip-10-0-110.ec2.internal/labtest --driver com.mysql.jdbc.Driver --username labuser --password simplilearn --table EMP --target-dir /user/roopa12r_gmail/Sqoop_demo -m 1
     
    #2
  3. Roopa R_1

    Roopa R_1 Member

    Joined:
    Aug 28, 2019
    Messages:
    6
    Likes Received:
    1
    #3
  4. Roopa R_1

    Roopa R_1 Member

    Joined:
    Aug 28, 2019
    Messages:
    6
    Likes Received:
    1
    hi I write a query can u pls let me know who will look into it and help me. thank u
     
    #4
  5. _52453

    _52453 New Member

    Joined:
    Dec 18, 2018
    Messages:
    1
    Likes Received:
    0
    Hi,

    I want to login into mysql, is it via the web console tab in practice labs? Please detail out the steps for the same.

    Regards,
    Randhir Singh
     
    #5
  6. Roopa R_1

    Roopa R_1 Member

    Joined:
    Aug 28, 2019
    Messages:
    6
    Likes Received:
    1
    hi Amit

    how to analyse the sqoop export logs, am unable to find a error why my command is failed. Please guide. attaching screen shot of command and log EXPORT_ERROR2.JPG EXPORT_ERROR2.JPG EXPORT_ERROR1.JPG
     
    #6
    Koyel Sinha Chowdhury likes this.
  7. Koyel Sinha Chowdhury

    Koyel Sinha Chowdhury Well-Known Member

    Joined:
    Feb 14, 2019
    Messages:
    72
    Likes Received:
    9
    Hi Randhir,

    To access your MYSQL, at first log on to your web Console.
    Then use the below command :
    >> mysql -u labuser -p
    password : simplilearn
    and you will be able to log on to MySQL
     
    #7
  8. Koyel Sinha Chowdhury

    Koyel Sinha Chowdhury Well-Known Member

    Joined:
    Feb 14, 2019
    Messages:
    72
    Likes Received:
    9
    Hi Roopa,

    I have shared the sample below command on Sqoop export:
    >> sqoop export -fs local -jt local --connect jdbc:mysql://ip-10-0-1-10.ec2.internal/ksc_bdhs_project --username=labuser --password=simplilearn --table employee_review --export-dir file:/home/koyel_chowdhury_simplilearn/Employee_review

    where ksc_bdhs_project is the database and employee_review is the table available inside this database,and export the data from the directory /home/koyel_chowdhury_simplilearn/Employee_review to the created table employee_review.
     
    #8

Share This Page