You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by Matt <bs...@gmail.com> on 2016/01/26 19:56:45 UTC

SELECT * via sqlline -q dumps filenames

sqlline -u ... -q 'SELECT * FROM dfs.`/path/to/files/file.csv` LIMIT 10' 
seems to emit a list of files in the local path (pwd), along with a 
parsing error.

Putting the query in a file and passing that file name to sqlline or 
using an explicit column list runs the query as expected.

Is this a sqlline issue, or my improper use of it (quoting) ?

Re: SELECT * via sqlline -q dumps filenames

Posted by Chris Mathews <ma...@uk2.net>.

Try putting a back-slash in front of the ‘*’ this usually works for command line issues when using a ‘*’

sqlline -u ... -q 'SELECT \* FROM dfs.`/path/to/files/file.csv` LIMIT 10’ 

Cheers — Chris

> On 26 Jan 2016, at 18:56, Matt <bs...@gmail.com> wrote:
> 
> sqlline -u ... -q 'SELECT * FROM dfs.`/path/to/files/file.csv` LIMIT 10' seems to emit a list of files in the local path (pwd), along with a parsing error.
> 
> Putting the query in a file and passing that file name to sqlline or using an explicit column list runs the query as expected.
> 
> Is this a sqlline issue, or my improper use of it (quoting) ?
> 
>