validation failed: Cannot insert into target table because number/types are different.
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
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
Tagged:
Answers
-
Hi Mattsco,
You can't use SELECT * on partitioned dataset because the partition column must not be in the query.
