Creating External Table with Avro Data file

Hi,
I’m creating external table orders as below

CREATE EXTERNAL TABLE orders(
order_id int,
order_date bigint,
order_customer_id int,
order_status string)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe’
STORED AS AVRO
LOCATION ‘/apps/hive/warehouse/yogesh1505.db/orders’

what data type should I take for order_date, which is long in avsc file. I tried it with int,date, timestamp but its not working.Table is created without data

Thanks in advance

Initially somehow data not loaded properly. Reloading of order data & using timestamp data type, resolved the issue

Thanks

I think we can use String datatype too for the same.