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

Posted to user@spark.apache.org by Sea <26...@qq.com> on 2016/09/23 07:26:11 UTC

回复： How to specify file

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";<he...@gmail.com>;
发送时间: 2016年9月23日(星期五) 下午3:32
收件人: "Sea"<26...@qq.com>; 
抄送: "user"<us...@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

Hemant Bhanawat

www.snappydata.io 







 
On Fri, Sep 23, 2016 at 12:26 PM, Sea <26...@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!