You don't need to specify "EXEC_DATE STRING," in your column definition as it is already specified by "PARTITIONED BY(EXEC_DATE STRING)
Dilip On Fri, Aug 20, 2010 at 6:41 PM, Ronak Bhatt <ronakb...@gmail.com> wrote: > for the following create table, I'm getting the error : FAILED: Error in > semantic analysis: Column repeated in partitioning columns... > > any suggestion? > > thanks, ronak > > > create table callbacks_part > ( > ID INT, > BOOKMARK_STEP_ID INT, > CLIENT_ID INT, > TXN_ID STRING, > SESSION_ID STRING, > IP_ADDRESS STRING, > METHOD STRING, > PAGE_ID INT, > RULE_NAME_ID INT, > CALLBACK_TYPE_ID INT, > PAGE_ELEMENT_ID INT, > CALLBACK_SENSE_ID INT, > CALLBACK_INFO STRING, > NUM_OCCURANCES INT, > UNIQUE_ID STRING, > EXEC_DATE STRING, > EXEC_DURATION FLOAT > ) > PARTITIONED BY(EXEC_DATE STRING) > CLUSTERED BY(PAGE_ID) SORTED BY(PAGE_ID) INTO 32 BUCKETS > ROW FORMAT DELIMITED > FIELDS TERMINATED BY ',' > STORED AS TEXTFILE; > > > > > > *thanks, ronak* > * > * > *408 504 4847* > *My Blog : http://ronakbaps.posterous.com* > * > * > * > * > > -- _________________________________________ Dilip Antony Joseph http://csgrad.blogspot.com http://www.marydilip.info