db-record.zipi think its the data issue , I am uploaded a queue entry please take a look. the table ddl is as follows : CREATE TABLE purchase_acct_orc ( acct_num BIGINT, pur_id BIGINT, pur_det_id BIGINT, product_pur_product_code STRING, prod_amt FLOAT, accttype_acct_type_code STRING, acctstat_acct_status_code STRING, emp_emp_code STRING, plaza_plaza_id STRING, purstat_pur_status_code STRING ) PARTITIONED BY (pur_trans_date TIMESTAMP) CLUSTERED BY(acct_num) INTO 5 BUCKETS STORED AS ORC TBLPROPERTIES ("transactional"="true")
... View more
