Re: partitions not being created

[David Lerman]

>> hive> create table partTable (a string, b int) partitioned by (dt int);

> INSERT OVERWRITE TABLE ApiUsage PARTITION (dt = "20090518")
> SELECT `(requestDate)?+.+` FROM ApiUsageTemp WHERE requestDate = '2009/05/18'

The table has an int partition column (dt), but you're trying to set a
string value (dt = "20090518").

Try :

create table partTable (a string, b int) partitioned by (dt string);

and then do your insert.