Sorry, pokes is the example table in the getting started guide: http://wiki.apache.org/hadoop/Hive/GettingStarted#DDL_Operations
JVS On Mar 16, 2010, at 2:22 PM, Ryan LeCompte wrote: Can you elaborate a little bit? I guess I don't see foo+bar in the example? Thanks! Ryan On Tue, Mar 16, 2010 at 5:18 PM, John Sichi <[email protected]<mailto:[email protected]>> wrote: On Mar 16, 2010, at 2:06 PM, Ryan LeCompte wrote: > Is there a way to remove columns from a Hive table via ALTER TABLE statement? > We don't currently support a DROP COLUMN syntax on ALTER TABLE, but you can use REPLACE COLUMNS to achieve the same effect, e.g. alter table pokes replace columns(foo int); takes it down to just foo instead of foo+bar. JVS
