Announcing the winners & finalists of the Dataiku Frontrunner Awards 2021! Read their inspiring stories

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

Mattsco
Dataiker
Dataiker
validation failed: Cannot insert into target table because number/types are different.
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
Mattsco
0 Kudos
1 Reply
Mattsco
Dataiker
Dataiker
Author

Hi Mattsco, 



You can't use SELECT * on partitioned dataset because the partition column must not be in the query. 



wink

 

Mattsco
0 Kudos
Labels (3)
A banner prompting to get Dataiku DSS