Hello @Benjamin, What would be the best way to convert a very large non-bucketed table into a bucketed table (8 buckets and date wise partitioned table, say 1700 partitions currently). Every time I run my query to insert. INSERT INTO NEW_BUCKETED_TABLE PARTITION(DATE_KEY)SELECT ALL_COLUMNS,PARTITION_COLUMN FROM NON_BUCKETD_TABLE; It always creates no. of reducers = no. of buckets, and start failing after some time as size of reducers is limited, and data is very large. How to tackle this problem. Thanks, Manu ... View more

try to set environment varialble for shell action:   HADOOP_USER_NAME=${wf:user()} OR UsernameYouWant   Manu ... View more

I was just wondering if you were able to find solution of the above problem and want to share it.   Thanks, Manu ... View more

What will be equivalent of below Oracle Query in Impala. select 1 id, 'a' d from dual where not exists (select 1 from employee where empid > 20000) ... View more