[CALCITE-1764] Adding sort ordering type for druid sort json field

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.12.0
• Fix Version/s: 1.13.0
• Component/s: druid-adapter
• Assignee: Slim Bouguerra
• Reporter: Slim Bouguerra
• Created: 26/Apr/17 20:57
• Updated: 27/Feb/24 22:23
• Resolved: 27/Apr/17 17:21

Description

Currently limit spec will use default string compactor to sort fields.
That is wrong when the field is numeric for instance 9 will sort after 10.