Hi there, >From https://drill.apache.org/docs/text-files-csv-tsv-psv/ example:
"SELECT columns[0] as `DATE`, columns[1] as `AIRLINE`, CAST(columns[11] AS DOUBLE) as `PASSENGER_COUNT` FROM dfs.`/opendata/Passenger/SFO_Passenger_Data/*.csv` WHERE CAST(columns[11] AS DOUBLE) < 5;" it looks like Apache Drill should be able to support wildcard to match files in directory, is that right? P.S. my experience: 0: jdbc:drill:zk=local> select count (*) from dfs.tmp.`bar.csv`; +----------+ | EXPR$0 | +----------+ | 1000000 | +----------+ 1 row selected (2.93 seconds) 0: jdbc:drill:zk=local> select count (*) from dfs.tmp.`ba*.csv`; Error: VALIDATION ERROR: String index out of range: -1 SQL Query null Thank you, Anton
