Hello,
Using Hadoop 2.6.0 and OOZIE 4.1.0 with apache-hive 1.0.
I am seeing an issue with the oozie workflow example failing. Its two
instructions
CREATE EXTERNAL TABLE test (a INT) STORED AS TEXTFILE LOCATION '${INPUT}';
INSERT OVERWRITE DIRECTORY '${OUTPUT}' SELECT * FROM test;
The first statement passes:
CREATE EXTERNAL TABLE test (a INT) STORED AS TEXTFILE LOCATION
'$(INPUT)';
It's the INSERT OVERWRITE DIRECTORY that's appears to be causing issue? However
I don't see any permissions problems?
I am running both:
./hive --service hiveserver2
hive --service metastore
Running on derby DB.
There is not a lot of trace in the hive log at the end.
15-04-08 14:06:35,065 INFO [pool-4-thread-5]: HiveMetaStore.audit
(HiveMetaStore.java:logAuditEvent(339)) - ugi=oozie ip=127.0.0.1
cmd=source:127.0.0.1 get_table : db=default tbl=test
2015-04-08 14:06:35,065 DEBUG [pool-4-thread-5]: metastore.ObjectStore
(ObjectStore.java:debugLog(6713)) - Open transaction: count = 1, isActive =
true at:
org.apache.hadoop.hive.metastore.ObjectStore.getTable(ObjectStore.java:897)
2015-04-08 14:06:35,066 DEBUG [pool-4-thread-5]: metastore.ObjectStore
(ObjectStore.java:debugLog(6713)) - Open transaction: count = 2, isActive =
true at:
org.apache.hadoop.hive.metastore.ObjectStore.getMTable(ObjectStore.java:960)
2015-04-08 14:06:35,070 DEBUG [pool-4-thread-5]: metastore.ObjectStore
(ObjectStore.java:debugLog(6713)) - Commit transaction: count = 1, isactive
true at:
org.apache.hadoop.hive.metastore.ObjectStore.getMTable(ObjectStore.java:968)
2015-04-08 14:06:35,083 DEBUG [pool-4-thread-5]: metastore.ObjectStore
(ObjectStore.java:debugLog(6713)) - Commit transaction: count = 0, isactive
true at:
org.apache.hadoop.hive.metastore.ObjectStore.getTable(ObjectStore.java:899)
get_table looks like it is getting called when the "select * from test".
Any ideas why this would fail. I have been spinning my wheels on this.
Thanks,
Gazza
