Create Hive table with bucketing and ORC file format

Question

Hello. Please share an example of creating a table with bucketing and ORC file format. Thanks

Answer 1

create table hive_dml
(emp_id int, first_name string, last_name string)
clustered by (emp_id) into 4 buckets
stored as orc
tblproperties ('transactional'='true');

Hope this helps