A hot topic in the sdc-user group during the past weeks has been about how to schedule the start and stop of SDC
pipelines. Usage of the SDC REST APIs has been suggested in some
threads, but because the general impression I have is that the audience
doesn't have a clear idea about them, I decided to write an article on DZone to
help and clarify once and for all how to do it. Enjoy it!
Sometimes you would need to export a sample of the data from an InfluxDB table to a CSV file (for example to allow a data scientist to do some offline analysis using a tool like Jupyter, Zeppelin or Spark Notebook). It is possible to perform this operation through the influx command line client. This is the general syntax: sudo /usr/bin/influx -database '<database_name>' -host '<hostname>' -username '<username>' -password '<password>' -execute 'select_statement' -format '<format>' > <file_path>/<file_name>.csv where the format could be csv , json or column . Example: sudo /usr/bin/influx -database 'telegraf' -host 'localhost' -username 'admin' -password '123456789' -execute 'select * from mem' -format 'csv' > /home/googlielmo/influxdb-export/mem-export.csv
Comments
Post a Comment