We are trying to create a external table in hive. This data is sorted, so wanted to tell hive about this. When I do, it complains about parsing the create.
> CREATE EXTERNAL TABLE IF NOT EXISTS store.testing ( ... . . . . . . . . . . . . . . . . . . .> timestamp bigint, ...) . . . . . . . . . . . . . . . . . . .> SORTED BY (timestamp) ... . . . . . . . . . . . . . . . . . . .> LOCATION '/project/db/table' . . . . . . . . . . . . . . . . . . .> ; Error: Error while compiling statement: FAILED: ParseException line 1:507 missing EOF at 'SORTED' near ')' (state=42000,code=40000) 2: jdbc:hive2://localhost:10000/store> What can I do to let hive know that my data is sorted? Every example online of sorted by is grouped with buckets, but we really don't want to add bucketing. Hive version: 0.14.0 Thanks for your help!