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