Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
validation failed: Cannot insert into target table because number/types are different.
Added on February 21, 2018 6:59PM
Likes: 0
Replies: 1
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
Answers
-
Hi Mattsco,
You can't use SELECT * on partitioned dataset because the partition column must not be in the query.
