> PARTITION(state='CA') > SELECT * WHERE se.adr.st='CA' > FAILED: SemanticException [Error 10044]: Line 2:23 Cannot insert into >target table because column number/types are different ''CA'':
The error is bogus, but the issue has to do with the "SELECT *". Inserts where a partition is specified statically cannot have a partition column in the select. So this is failing since it is trying to insert n-1 columns, because state='CA' cannot be repeated in the SELECT. Cheers, Gopal