I just installed hadoop 3.3.6 and hive 4.0.0 with mysql as metastore. when running create table or select * from… it runs well. But when I try to do insert or select join, hive always fails. I’m noticing that hive fails at the mapreduce task and “requires lock = true” even though I didn’t create any lock.

I just installed hadoop 3.3.6 and hive 4.0.0 with mysql as metastore. when running create table or select * from… it runs well. But when I try to do insert or select join, hive always fails. I’m noticing that hive fails at the mapreduce task and “requires lock = true” even though I didn’t create any lock.

I just installed hadoop 3.3.6 and hive 4.0.0 with mysql as metastore. when running create table or select * from… it runs well. But when I try to do insert or select join, hive always fails. I’m noticing that hive fails at the mapreduce task and “requires lock = true” even though I didn’t create any lock.