Problem with query on bucketed table

2011-10-09 Thread Avrilia Floratou
Hello, I have a question regarding the execution of some queries on bucketed tables. I've created a compressed bucketed table using the following statement: create external table partRC (P_PARTKEY BIGINT,P_NAME STRING, P_MFGR STRING, P_BRAND STRING, P_TYPE STRING, P_SIZE INT, P_CONTAINER

Re: Problem with query on bucketed table

2011-10-09 Thread Bejoy Ks
: Monday, October 10, 2011 7:13 AM Subject: Problem with query on bucketed table Hello, I have a question regarding the execution of some queries on bucketed tables. I've created a compressed bucketed table using the following statement: create external table partRC (P_PARTKEY BIGINT,P_NAME

Re: Problem with query on bucketed table

2011-10-09 Thread Avrilia Floratou
10, 2011 7:13 AM Subject: Problem with query on bucketed table Hello, I have a question regarding the execution of some queries on bucketed tables. I've created a compressed bucketed table using the following statement: create external table partRC (P_PARTKEY BIGINT,P_NAME STRING, P_MFGR

Re: Problem with query on bucketed table

2011-10-09 Thread Bejoy Ks
to the large number of files created? Regards Bejoy.K.S From: Avrilia Floratou flora...@cs.wisc.edu To: Bejoy Ks bejoy...@yahoo.com Cc: user@hive.apache.org user@hive.apache.org Sent: Monday, October 10, 2011 10:28 AM Subject: Re: Problem with query on bucketed table Hi