You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The Example given in influxdb for csv import via CLI is as following, but executing the same commands with a different seperator produces errors.
By the way: There is a typo in dataTime, it should be dateTime
Reproduction:
> influx version
Influx CLI 2.6.1 (git: 61c5b4d) build_date: 2022-12-29T15:41:09Z
> cat <<EOF > test.csvdate,sighted,loc2020-01-01,12,Boise2020-06-01,78,Boise2020-01-01,54,Seattle2020-06-01,112,Seattle2020-01-01,9,Detroit2020-06-01,135,DetroitEOF> influx write dryrun -b test -f test.csv --header "#constant measurement,birds" --header "#datatype dateTime:2006-01-02,long,tag"
birds,loc=Boise sighted=12i 1577836800000000000
birds,loc=Boise sighted=78i 1590969600000000000
birds,loc=Seattle sighted=54i 1577836800000000000
birds,loc=Seattle sighted=112i 1590969600000000000
birds,loc=Detroit sighted=9i 1577836800000000000
birds,loc=Detroit sighted=135i 1590969600000000000
> sed -i "s/,/;/g" test.csv
> influx write dryrun -b test -f test.csv --header "sep=;" --header "#constant measurement,birds" --header "#datatype dateTime:2006-01-02,long,tag"
2023/06/15 13:24:48 line 5: no measurement column found
2023/06/15 13:24:48 line 6: no measurement column found
2023/06/15 13:24:48 Unable to batcher to error-file: invalid argument
2023/06/15 13:24:48 line 7: no measurement column found
2023/06/15 13:24:48 Unable to batcher to error-file: invalid argument
2023/06/15 13:24:48 line 8: no measurement column found
2023/06/15 13:24:48 Unable to batcher to error-file: invalid argument
2023/06/15 13:24:48 line 9: no measurement column found
2023/06/15 13:24:48 Unable to batcher to error-file: invalid argument
2023/06/15 13:24:48 line 10: no measurement column found
2023/06/15 13:24:48 Unable to batcher to error-file: invalid argument
Another thing that came to my mind while trying to import big files is that influx write dryrun would greatly benefit from a --head or --max-lines <n> option. This way one could try the annotated header without the console exploding. (but thats probably a feature request).
The text was updated successfully, but these errors were encountered:
The Example given in influxdb for csv import via CLI is as following, but executing the same commands with a different seperator produces errors.
Reproduction:
Another thing that came to my mind while trying to import big files is that
influx write dryrun
would greatly benefit from a--head
or--max-lines <n>
option. This way one could try the annotated header without the console exploding. (but thats probably a feature request).The text was updated successfully, but these errors were encountered: