issue with broadcast join

Hi all, I have a query that involves 2 tables, t1 with 45M rows (not partitioned) and t2 with 61M rows (partitioned). If I disable the parameter hive.auto.convert.join.noconditionaltask the query runs well, but, if I enable it, using the default value of hive.auto.convert.join.noconditionaltask

drop partition from external table

Hi all, I have a problem dropping a partition in an external table in Hive 1.2.1. The table is an external table with location pointing to an HDFS snapshot. Show create table mydb.my_table: CREATE EXTERNAL TABLE `sax777h.te_ax_hd_inp_rap_por_on`( ... ) PARTITIONED BY ( mydate date ) ROW FORMAT S