INSERT INTO TABLE session1 PARTITION(year, month)
SELECT * FROM session2
FAILED: RuntimeException org.apache.hadoop.security.AccessControlException: Permission denied: user=a, access=WRITE, inode="/tmp/hive-yarn":b:supergroup:drwxr-xr-x
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkFsPermission(FSPermissionChecker.java:271)
Solution:
SET hive.exec.scratchdir = /tmp/hive-${user.name}
Solution:
SET hive.exec.scratchdir = /tmp/hive-${user.name}
Scratch space for Hive jobs, otherwise it will run as yarn.
If pig inserts to Hive table with this issue:
set hive.exec.scratchdir /tmp/hive-${user.name}
Reference:
https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties
Greens Technology's. the leading software Training & placement centre Chennai & (Adyar)
ReplyDeleteapple-ios training in chennai
• Article is good and interesting
ReplyDeletealso visit my site.
qtp training in chennai
• can any one suggest me about testing training institute with 100 % placement in adyar.
ReplyDeleteoracle training inchennai
be projects in chennai
ReplyDeletens2 projects in chennai
ieee java projects in chennai
ieee dotnet projects in chennai
bsc projects in chennai
msc projects in chennai
bca projects in chennai
mba projects in chennai
I want to encourage that you continue your great posts, have a nice weekend!
ReplyDeleteiosh course in chennai
Awesome Post!! Keep posting more content.
ReplyDeleteSelenium Training in Chennai
Selenium Course in Chennai
iOS Course in Chennai
Digital Marketing Training in Chennai
J2EE Training in Chennai
Future of testing professional
Different functions in testing
Digital Marketing Chennai
Thanks for making me this article. You have done a great job by sharing this content in here. Keep writing article like this.
ReplyDeleteCloud Training
Cloud Training in Chennai
Your very own commitment to getting the message throughout came to be rather powerful and have consistently enabled employees just like me to arrive at their desired goals.
ReplyDeleteWeb Designing Training in Chennai | No.1 Web Designing Course Training in Chennai
SQL Server Training in Chennai | Best No.1 SQL Server Course Training in Chennai
Digital Marketing Training in Chennai | Best Digital Marketing Course Training in Chennai
ReplyDeleteIt’s great to come across a blog every once in a while that isn’t the same out of date rehashed material. Fantastic read.
Machine Learning Training in Chennai |Machine Learning Training Institute in Chennai
Superb post..
ReplyDeleteHardware and Networking Training in Chennai
CCNA Training in Chennai
AWS Training in Chennai
SAP Training in Chennai
Software Testing Training in Chennai
Java Training in Chennai
QTP Training in Chennai
iOS Training in Chennai
Oracle Training in Chennai
Pearson Vue Exam Center in Chennai