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* * * * *
