Coming soon: We’re working on a brand new, revamped Community experience. Want to receive updates? Sign up now!

0 votes
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
by

1 Answer

0 votes

Hi Mattsco, 

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

wink
 

by
1,339 questions
1,365 answers
1,557 comments
11,916 users

©Dataiku 2012-2018 - Privacy Policy