Cloud lab Sqoop import issue and hive permission issues

Discussion in 'Simplilearn Support' started by Venkatrao Meenavalli, Aug 4, 2019.

  1. Venkatrao Meenavalli

    Joined:
    May 3, 2019
    Messages:
    2
    Likes Received:
    0
    Hi,

    I am trying to use sqoop in cloud lab. Getting below error

    From webconsole
    Please set $ACCUMULO_HOME to the root of your Accumulo installation

    From Hue
    Error
    Job was KILLED
    'ascii' codec can't decode byte 0xe2 in position 17251: ordinal not in range(128)
    'ascii' codec can't decode byte 0xe2 in position 17251: ordinal not in range(128)

    sqoop import –connect jdbc:mysql://localhost:3306/venkat –u labuser –p simplilearn –table stock_prices –target-dir /user/venkat –hive-import –create-hive-table –hive-table venkat.stock_prices -m 1


    Permission issue to create hive db and write data from csv to hive
    Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.hadoop.security.AccessControlException Permission denied: user=venkat_meenavalli_yahoo_co, access=WRITE, inode="/user/hive/warehouse":adarsh_bhalke_gmail:supergroup:drwxr-xr-x at
     
    #1

Share This Page