search

noborus / trdsql

CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.
https://noborus.github.io/trdsql/
MIT License
1.96k stars 73 forks source link

Standard Deviation #140

Closed pannalal closed 1 year ago

pannalal commented 3 years ago

While putting SQL, I need to compute standard deviation of some columns like: "select stddev(c1), stddev(c2) from test.csv"

It displays: ERROR(EXPORT):SQL:no such function: stddev

noborus commented 3 years ago

Sorry, stddev is not available because it is not included in SQLite3. Recommend using PostgreSQL driver or MySQL driver.

pannalal commented 3 years ago

Thanks

pannalal commented 3 years ago

Please guide how can we use "https://github.com/dinedal/go-sqlite3-extension-functions" with trdsql. Thanks