Create tables is blocked while there are queries executing in a specific database in Hive

2015-04-08 Thread Guillermo Ortiz
Hi, I'm working with Hive. I have many queries executing in a specific database in Hive and I have tried to created an table in that database. The creating gets stopped until the queries end. If those queries last 10 hours I couldn't create any table in the next 10 hours, is it normal? It seems a

Hive map-join

2015-03-12 Thread Guillermo Ortiz
Hello, I'm executing a join of two tables. -table1 sizes 130Gb -table2 sizes 1.5Gb In HDFS table1 is just one text file and table2 it's ten files. I'd like to execute a map-join and load in memory table2 use esp; set hive.auto.convert.join=true; #set hive.auto.convert.join.noconditionaltask = t