how diagnose csvsql "column not found" error

Question

Using csvkit on macOS 10.14.3

input file:

head -n 3 Nov_git_v2.csv

Model_var,dummy

Age,

Basket_Size_FP_24,

Basket_Size_FP_6,

csvsql --query "select Model_var from Nov_gift_v2"  Nov_gift_v2.csv

produces error:

sqlite3.OperationalError) no such column: Model_var

csvstat -c 1-2 Nov_gift_v2.csv > csvstat_output.txt

displays the column "Model_var" and lists its properties, implying the column exists

csvsql --query "select Model_var from Nov_gift_v2"  Nov_gift_v2.csv

expected:

Age

Basket_Size_FP_24

Basket_Size_FP_6

actual output:

sqlite3.OperationalError) no such column: Model_var

Answer 1

I have no problem with csvsql 1.0.4. What's your version (csvsql --version)?

Try with

csvsql --query 'select "Model_var" from "Nov_gift_v2"'  Nov_gift_v2.csv