spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sea" <261810...@qq.com>
Subject 回复: How to specify file
Date Fri, 23 Sep 2016 07:26:11 GMT
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

Hemant Bhanawat

www.snappydata.io 







 
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!
Mime
View raw message