Member since
10-09-2014
8
Posts
0
Kudos Received
0
Solutions
08-03-2015
05:54 AM
Hi, Thank you for your reply. Now everything makes sense to me. Best Fabricio
... View more
07-31-2015
01:24 PM
Hi, I've been having the same issue but everything is working properly at my client cluster. The only thing that I'd like to clarify is that echo $JAVA_HOME command returns empty line and the client is asking my why. And what get me courious about it is that on Cloudera Manager, the Java Home Directory is empt as well. java -version java version "1.7.0_45" rpm -qa | grep oracle oracle-j2sdk1.7-1.7.0+update67-1.x86_64 ps auxf | grep java /usr/java/jdk1.7.0_67-cloudera/bin/java At this point I understand that there are 2 java versions installed and the whole system is using jdk1.7.0_67-cloudera. So what the heck java home directory on Cloudera Manager is empty? 🙂 Thank you Fabricio
... View more
10-09-2014
11:21 AM
Hi, I had the same issue on HUE connecting to jdbc:hive2://localhost:10000 Have you installed hive-server2 ? ps -aux | grep hive-server2 If not, try this http://www.cloudera.com/content/cloudera/en/documentation/cdh4/v4-2-0/CDH4-Installation-Guide/cdh4ig_topic_18_5.html Regards, Fabricio
... View more
10-09-2014
11:11 AM
Hi, Has sombody facing some problem like that? I've been facing some problems with OVERWRITE clause on command: load data local inpath 'emp.dat' overwrite into table emp; Loading data to table default.emp Failed with exception Unable to move sourcehdfs://localhost:8020/tmp/hive-stabbler/hive_2014-10-09_12-13-44_624_7988255974532992081-1/-ext-10000 to destination /user/hive/warehouse/default.db/emp FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask workaround 1 Tried to change the /tmp/hive-stabbler permission on hdfs to 777. It didn't work. Tried via Hue interface but it didn't work. Submit button to upload the file was not enabled. but when I came back to the previous hue screen, a message was displayed saying the file was successfuly uploaded. Weird !! I dropped the table emp and recreated it. Tried the command: !hdfs dfs -copyFromLocal emp.dat /user/hive/warehouse/default.db/emp; It worked. -- workaround 2 Tried to create a table with different name as the file emp.dat. This time tablename employee, file emp.dat load data local inpath 'employee.dat' overwrite into table emp; Same error. I dropped the table emp; Recreated it. Tried to load data without overwrite parameter, it worked with table emp and file emp.dat load data local inpath 'emp.dat'into table emp; It worked. -- It seems could be a problem with overwrite parameter. I've followed this cloudera instructions link I saw the same problem here but it has no reply. and this one from apache hive community related to the problem where the table has the same name of the table. Thanks Fabricio
... View more
Labels:
- Labels:
-
Apache Hadoop
-
Apache Hive
-
Cloudera Hue
-
HDFS