Hi,

I'm using Hive 3.1.2 and I can't quite figure out how to define a table
with an "interval" column type.

I've tried both:

CREATE TABLE (duration INTERVAL);

and:

CREATE TABLE (duration INTERVAL DAY);

but that returns an exception:

cannot recognize input near 'INTERVAL' 'DAY' ',' in column type

Could you clarify what the proper way is?

Thank you,

Julien

Reply via email to