To Query CSV files. Please use the storage-plugins.json I have provided.
On Thu, May 22, 2014 at 10:58 PM, 南在南方 i02...@qq.com wrote:
I have tried several querying format. Like select * from
/home/bevin/storage-engines.json; select * from
`/home/bevin/storage-engines.json`; select * from
In the storage plugins file I sent replace the maprfs:/// with file:///
Regards
Ramana
On Thursday, May 22, 2014, 南在南方 i02...@qq.com wrote:
I conn't tell what is maprfs with file ,could you more specific? I'm new
to Drill. thanks.
-- 原始邮件 --
发件人: Ramana
Sorry.I have tried with '`' and ''' alreally. But doesn't works.
0: jdbc:drill:schema=dfs select * from `/home/bevin/AllstarFull.csv`;
java.lang.RuntimeException: parse failed
at
net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare2_(OptiqPrepareImpl.java:237)
at
Here is my storage-plugins.json:
{
storage:{
dfs: {
type: file,
connection: file:///
},
formats: {
psv : {
type: text,
extensions: [ tbl ],
delimiter: |
},
csv : {
type: text,
extensions: [ csv
It looks like you need to specify the data source you are using (appearing
in the storage section of your config file), I believe there is a way when
you are connecting to pass a default schema, but it currently isn't set up
to bring you right into a schema, even if you only have line specified in
Sorry, that was a bit of a roundabout way of describing the process. The
normal connection should just give you a session where you can query all
schemas (in your config file, dfs is the only schema listed). You simply
need to write it as dfs.`filepath'
I was looking at the connection docs