What is the kind of query that you are doing ? If your data is partitioned, beware that "SELECT *" will return the partitioning column, but you can't have the partitioning column in the output (i.e. in Hive you can't do INSERT OVERWRITE t2 SELECT * FROM t1" if t1 is partitioned, you need to use explicit column names)