Hi, Hemant, Aditya:
    I don't want to create temp table and write code, I just want to run sql directly on files "select * from csv.`/path/to/file`"


------------------ 原始邮件 ------------------
发件人: "Hemant Bhanawat";<hemant9379@gmail.com>;
发送时间: 2016年9月23日(星期五) 下午3:32
收件人: "Sea"<261810726@qq.com>;
抄送: "user"<user@spark.apache.org>;
主题: Re: How to specify file

Check out the READEME on the following page. This is the csv connector that you are using. I think you need to specify the delimiter option. 

https://github.com/databricks/spark-csv


On Fri, Sep 23, 2016 at 12:26 PM, Sea <261810726@qq.com> wrote:
Hi, I want to run sql directly on files, I find that spark has supported sql like select * from csv.`/path/to/file`, but files may not be split by ','. Maybe it is split by '\001', how can I specify delimiter?

Thank you!