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