標籤: TrinoDB

剛好工作上用到，記錄一下…. 這樣以後再用到時就只要稍微改一下相關的參數就好了XD

trino --server localhost:8080 \
 --user george \
 --execute 'SELECT * FROM A as a
  LEFT JOIN b ON a.id = b.id
  WHERE a.id > 0' \
 --output-format CSV > ~/workspace/mds_object.csv

Reference:

• https://stackoverflow.com/questions/69951748/how-to-export-the-query-result-in-csv-format-in-trino