[bug] select cannot emit result for cvs

cube2222 / octosql

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

Mozilla Public License 2.0

4.75k stars 202 forks source link

[bug] select cannot emit result for cvs #263

Closed acekingke closed 2 years ago

acekingke commented 2 years ago

the data file is

➜  data cat cats.csv
"Id","Sex","Bwt","Hwt"
"1","F",2,7
"2","F",2,7.4
"3","F",2,9.5
"4","F",2.1,7.2
"5","F",2.1,7.3
"7","F",2.1,8.1
"8","F",2.1,8.2

The config yaml file is :

dataSources:
  - name: cats
    type: csv
    config:
      path: "~/data/cats.csv"

run the cmd it like that:

➜  octosql git:(master) ✗ go run cmd/octosql/*go "select c.* from cats c" -c ~/octosql/octosql.yml
+
+
watermark: 0001-01-01T00:00:00Z

cube2222 commented 2 years ago

Hey there! Sorry for the late answer. It's been a while since I'm currently working on a rewrite, but I'm quite sure namespaced wildcards aren't supported. You'll have to just use select * from ...

cube2222 commented 2 years ago

This is now supported.