-
Notifications
You must be signed in to change notification settings - Fork 165
Open
Labels
bugSomething isn't workingSomething isn't working
Description
dsq output as json format by default. Can we support the output in csv format.
Currently, I need to use the jq and sed to get the output of csv
dsq t1.csv t2.csv "select t1.*,t2.* from {0} t1 join {1} t2 on t1.id = t2.id" | jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @csv' | sed -e 's/"//g' > result.csv
Can we support the output in csv format by --format
dsq --format csv t1.csv t2.csv "select t1.*,t2.* from {0} t1 join {1} t2 on t1.id = t2.id"
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't working