@PriyalPotnis as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post. ... View more

I think this was due to non runnning metstore service from hive.   You should run command "hive --service metastore & " first and then start hive console.  ... View more

In my case, source file gets removed, when I load a single file with 'OVERWRITE' clause. files stay when I load without 'OVERWRITE' clause for a set of files with a pattern (say _*.txt) ... View more

hdfs dfs -ls -R <directory> |grep part-r* |awk '{print $8}' |xargs hdfs dfs -cat | wc -l ... View more

Writing this so that it can help someone in future: I was installing Hive and getting error that It hive metastore wasn't able to connect, and I successfully resolved the error by recreating the hive metastore database.   Someone the user which was created in mysql Hive metastore wasn't working properly and not able to authenticate. So I dropped metastore DB, Dropped User. Recreated Metastore DB, Recreated User, Granted all privileges and then it was working without issues. ... View more

You can also append HIVE_SKIP_SPARK_ASSEMBLY to the command which should remove the warnings. export HIVE_SKIP_SPARK_ASSEMBLY=true; hive -S --database dbname -e 'show tables;'   ... View more

Hi @rushi_ns ,   yours might be completly different issue. Please create a new Question thread stating your issue.   ... View more

@Jitendra Yadav Can you please check which user has the permission to read write this file? # ls -la /etc/yum.repos.d/ambari.repo -rw-r--r--. 1 root root 304 May 31 17:08 /etc/yum.repos.d/ambari.repo . You can verify the same using this Python script" import os import pwd print 'Who Owns it: ' + pwd.getpwuid(os.stat("/etc/yum.repos.d/ambari.repo").st_uid).pw_name . Now If do the following: # useradd 55025 # chown 55025 /etc/yum.repos.d/ambari.repo . Then you will see 55025 in the output. ... View more

@Constantin Stanca There was no error in hive/hdfs/yarn etc. during that time frame, even I tried to restart all the services but didn't helped. But when I restarted Ambari server the issue got resolved, don't know how this exception is related to ambari restart 🙂 ... View more

Thanks @Ayub Pathan for the help, it worked with below syntax as per your suggestion. RULE:[1:$1](4[0-9]*)s/^4/d/ ... View more