Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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...
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB