AIOps

 View Only
  • 1.  Hive Error in MetaData

    Posted Mon April 19, 2021 09:56 AM
    Hello all, During my Hadoop Certification I came across this error. When I'm trying to create a table in Hive it is throwing an error(it shows the error is in MetaData.
    Below is the query for that.

    sudo -u hdfs hadoop fs -mkdir -p /user/hive/warehouse
    sudo -u hdfs hadoop fs -chmod -R 444 /user/hive
    
    sudo -u hdfs hadoop fs -mkdir /user/hive/warehouse
    sudo -u hdfs hadoop fs -chmod g+w /tmp
    sudo -u hdfs hadoop fs -chmod g+w /user/hive/warehouse
    sudo -u hdfs hadoop fs -chown -R training /user/hive/warehouse
    sudo chmod 444 /var/lib/hive/metastore
    
    cd /var/lib/hive/metastore/metatstore_db/
    sudo rm *.lck​


    Any suggestions to resolve this MetaData Error

    ------------------------------
    John Andrew
    ------------------------------


  • 2.  RE: Hive Error in MetaData

    IBM TechXchange Speaker
    Posted Mon April 19, 2021 12:56 PM
    Hi,

    Are you sure this is posted in the right group?

    ------------------------------
    VEERAMANI NAMBI
    Offering Manager, GoToMarket - Communities
    ------------------------------