questdb/questdb

Support `forceHeader` param for `/imp` endpoint in Import page UI

Aperta

#3138 aperta il 30 mar 2023

 (4 commenti) (1 reazione) (1 assegnatario)Java (972 fork)batch import
EnhancementUIhacktoberfest

Metriche repository

Star
 (13.403 stelle)
Metriche merge PR
 (Merge medio 5g 13h) (108 PR mergiate in 30 g)

Descrizione

Is your feature request related to a problem?

QuestDB tries to detect CSV's header automatically, but sometimes it fails - in that case two things happen:

  • column names are wrong (f0, f1, ...)
  • CSV header row is inserted as the first item in the table.

/imp REST endpoint, used beneath the hood to process the CSV file has an optional ?forceHeader=true param, that can be used to treat the first row in the file as headers at all times.

Describe the solution you'd like.

Add a checkbox in the UI that can be toggled on to force the first row as a header in case of problems.

Describe alternatives you've considered.

No response

Additional context.

No response

Guida contributor