Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - question..partitioned table...


Copy link to this message
-
Re: question..partitioned table...
Dilip Joseph 2010-08-21, 02:34
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 <[EMAIL PROTECTED]> 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