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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.