Re: how to delete data for a partition

2011-02-12 Thread Cam Bazz
well, i decided to programmatically intervene, when something goes wrong. I am doing: load data local inpath '/var/mylog/daily/log.PROD.20110213' into table item_raw partition(date_hour=20110213) and when that partition file exists, I will get Exception in thread "main" java.sql.SQLException: Q

Re: how to delete data for a partition

2011-02-12 Thread Edward Capriolo
On Sat, Feb 12, 2011 at 5:17 PM, Cam Bazz wrote: > Hello, > > Is it possible to delete rows belonging to a partition? or is it > undeletable like a table's data? > > best regards, > -c.b. > Remove the files inside the partition.

how to delete data for a partition

2011-02-12 Thread Cam Bazz
Hello, Is it possible to delete rows belonging to a partition? or is it undeletable like a table's data? best regards, -c.b.

Re: how to delete data for a partition

2011-02-12 Thread Edward Capriolo
On Sat, Feb 12, 2011 at 5:30 PM, Cam Bazz wrote: > ok, is there a way to do it from the > http://localhost:50075/browseDirectory.jsp interface? > > On Sun, Feb 13, 2011 at 12:19 AM, Edward Capriolo > wrote: >> On Sat, Feb 12, 2011 at 5:17 PM, Cam Bazz wrote: >>> Hello, >>> >>> Is it possible to

Re: how to delete data for a partition

2011-02-12 Thread Cam Bazz
ok, is there a way to do it from the http://localhost:50075/browseDirectory.jsp interface? On Sun, Feb 13, 2011 at 12:19 AM, Edward Capriolo wrote: > On Sat, Feb 12, 2011 at 5:17 PM, Cam Bazz wrote: >> Hello, >> >> Is it possible to delete rows belonging to a partition? or is it >> undeletable l