Re: hive transactional table compaction fails

2016-11-07 Thread Edward Capriolo
On Mon, Nov 7, 2016 at 1:46 PM, Eugene Koifman wrote: > can you check if the user that the metastore is running as has right to > write to the table dir? > > On 10/26/16, 12:23 PM, "aft" wrote: > > >On Thu, Oct 27, 2016 at 12:00 AM, Eugene Koifman > > wrote: > >> could you provide output of ³SHO

Re: hive transactional table compaction fails

2016-11-07 Thread Eugene Koifman
can you check if the user that the metastore is running as has right to write to the table dir? On 10/26/16, 12:23 PM, "aft" wrote: >On Thu, Oct 27, 2016 at 12:00 AM, Eugene Koifman > wrote: >> could you provide output of ³SHOW COMPACTIONS¹ command > >I have dropped the earlier table ...but i cr

Re: hive transactional table compaction fails

2016-10-26 Thread aft
On Thu, Oct 27, 2016 at 12:00 AM, Eugene Koifman wrote: > could you provide output of ³SHOW COMPACTIONS¹ command I have dropped the earlier table ...but i created a simple table create table a (x int , y int) clustered by (x) into 2 buckets stored as orc tblproperties("transactional"="ture"); i

Re: hive transactional table compaction fails

2016-10-26 Thread Eugene Koifman
could you provide output of ³SHOW COMPACTIONS¹ command On 10/25/16, 11:21 PM, "aft" wrote: >Well the auto compactor fails every timeand it has been going on >for couple of days. As "day" is a partition, I have to assume, it >happens with all of them. > >Both manual/auto compactor fails. > >O

Re: hive transactional table compaction fails

2016-10-25 Thread aft
Well the auto compactor fails every timeand it has been going on for couple of days. As "day" is a partition, I have to assume, it happens with all of them. Both manual/auto compactor fails. On Wed, Oct 26, 2016 at 12:52 AM, Eugene Koifman wrote: > does this happen for 1 specific partition o

Re: hive transactional table compaction fails

2016-10-25 Thread Eugene Koifman
does this happen for 1 specific partition or all of them? On 10/25/16, 12:47 AM, "aft" wrote: >Hi, > >Table created with this : > >$hive>create table syslog_staged (id string, facility string, >sender string, severity string, tstamp string, service string, msg >string) partitioned by (hostna

hive transactional table compaction fails

2016-10-25 Thread aft
Hi, Table created with this : $hive>create table syslog_staged (id string, facility string, sender string, severity string, tstamp string, service string, msg string) partitioned by (hostname string, year string, month string, day string) clustered by (id) into 20 buckets stored as orc tblpr