validation failed: Cannot insert into target table because number/types are different.

Options
Mattsco
Mattsco Dataiker, Registered Posts: 125 Dataiker
Hi,

I get this message from a hive recipe on a partitioned dataset stored on HDFS:
validation failed: Cannot insert into target table because number/types are different "2018-02": Table inclause-0 has 27 columns, but query has 28 columns.

my query is:

SELECT * FROM MyTable

Answers

Setup Info
    Tags
      Help me…