?????? ?????? ?????? error when querying a csv file with drill.
Hi, thank you for your reply.
I failed the query again this morning.
I can query json file correctly. (oddly, I use jsonl schema which defined in
storage-engines.json and there query with ??select * from file.json ??, not
back ticks).
I use binary version of drill, Is that can be a reason I failed to query?
I would appreciate it if you send your entire Drill directory zip package to
me. i02...@qq.com or bevi...@gmail.com .
THANKS
-- --
??: Yash Sharma;yash...@gmail.com;
: 2014??5??24??(??) 1:52
??: drill-userdrill-user@incubator.apache.org;
: Re: ?? ?? error when querying a csv file with drill.
Hi All,
Is the main issue on connecting/querying to the json/csv data sources.
Here is what I did for querying Json/Csv data Sources.
Let me know if this is what we are looking for... or I am missing the
context here..
1. I did not modify the storage-plugin.json.
https://github.com/apache/incubator-drill/blob/master/distribution/src/resources/storage-plugins.json
*2 Created Json Data:* in Path /home/yash/git/Drill/data.json
The content of Json is pasted in the end of mail.
*3. Start Drill: *Drill is started by
bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
*4. Query Json Data:* pass path with dfsdot`path\to\data.json`; (path in
back-tick)
0: jdbc:drill:zk=local
select * from dfs.`/home/yash/git/Drill/data.json`;
*5. Output*
+++++++
| title|name| width| height | image|text
|
+++++++
| Transparent Window | trn_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignm |
| White Window | white_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignment |
| black window | black_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignment |
+++++++
3 rows selected (0.095 seconds)
Same procedure for *CSV* Data:
*Query:*
select * from dfs.`/home/yash/Desktop/Drill/data.csv`;
select columns from dfs.`/home/yash/Desktop/Drill/data.csv`;
select columns[1] from dfs.`/home/yash/Desktop/Drill/data.csv`;
Hope it helps.
Peace,
Yash
JSON Data:
{
title: Transparent Window,
name: trn_window,
width: 500,
height: 500,
image: {
src: Images/Sun.png,
name: sun1,
hOffset: 250,
vOffset: 250,
alignment: center
},
text: {
data: Click Here,
size: 36,
style: bold,
name: text1,
hOffset: 250,
vOffset: 100,
alignment: center,
onMouseUp: sun1.opacity = (sun1.opacity / 100) * 90;
}
}
{
title: White Window,
name: white_window,
width: 500,
height: 500,
image: {
src: Images/Sun.png,
name: sun1,
hOffset: 250,
vOffset: 250,
alignment: center
},
text: {
data: Click Here,
size: 36,
style: bold,
name: text1,
hOffset: 250,
vOffset: 100,
alignment: center,
onMouseUp: sun1.opacity = (sun1.opacity / 100) * 90;
}
}
{
title: black window,
name: black_window,
width: 500,
height: 500,
image: {
src: Images/Sun.png,
name: sun1,
hOffset: 250,
vOffset: 250,
alignment: center
},
text: {
data: Click Here,
size: 36,
style: bold,
name: text1,
hOffset: 250,
vOffset: 100,
alignment: center,
onMouseUp: sun1.opacity = (sun1.opacity / 100) * 90;
}
}
CSV Data:
u1,purchase,iphone
u1,purchase,ipad
u2,purchase,nexus
u2,purchase,galaxy
u3,purchase,surface
u4,purchase,iphone
u4,purchase,galaxy
u1,view,iphone
u1,view,ipad
u1,view,nexus
u1,view,galaxy
u2,view,iphone
u2,view,ipad
u2,view,nexus
u2,view,galaxy
u3,view,surface
u3,view,nexus
u4,view,iphone
u4,view,ipad
u4,view,galaxy
On Fri, May 23, 2014 at 9:06 PM, Jason Altekruse
altekruseja...@gmail.comwrote:
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 quickly and I couldn't find the exact
option for specifying schema. I'll reply if I find something later today
(its likely just schema or default_schema). Doing this would simply allow
you to leave off the dfs part of the name, as it will assume your queries
will want to default to that schema.
-Jason
On Fri, May 23, 2014 at 10:20 AM, i02...@qq.com wrote:
I found that there are two configuration files in drill home
(storage-engines.json and storage-plugins.json) . I have tried to remove
storage-engines.json, Connection can establish but same error occurs.
I connected drill with string sqlline -u jdbc:drill:schema=dfs -n admin
-
p admin ,you mean I
Re: 回复： 回复： 回复： error when querying a csv file with drill.
Hi Bevin,
These are the steps to build directly from the source:
// Get Drill Source
$ git clone https://github.com/apache/incubator-drill.git
$ cd incubator-drill
// Inside /DRILL DIR/
$ mvn clean install -DskipTests
// Install Drill
$ mkdir /opt/drill
$ tar xvzf distribution/target/*.tar.gz --strip=1 -C /opt/drill
// Switch to installed directory
$ cd /opt/drill
$ sudo bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
0: jdbc:drill:zk=local
select * from dfs.`/home/yash/git/Drill/data.json`;
Let me know if this works.
Peace Yash
On Sat, May 24, 2014 at 12:10 PM, 南在南方 i02...@qq.com wrote:
Hi, thank you for your reply.
I failed the query again this morning.
I can query json file correctly. (oddly, I use jsonl schema which defined
in storage-engines.json and there query with “select * from file.json ”,
not back ticks).
I use binary version of drill, Is that can be a reason I failed to query?
I would appreciate it if you send your entire Drill directory zip package
to me. i02...@qq.com or bevi...@gmail.com .
THANKS
-- 原始邮件 --
发件人: Yash Sharma;yash...@gmail.com;
发送时间: 2014年5月24日(星期六) 凌晨1:52
收件人: drill-userdrill-user@incubator.apache.org;
主题: Re: 回复： 回复： error when querying a csv file with drill.
Hi All,
Is the main issue on connecting/querying to the json/csv data sources.
Here is what I did for querying Json/Csv data Sources.
Let me know if this is what we are looking for... or I am missing the
context here..
1. I did not modify the storage-plugin.json.
https://github.com/apache/incubator-drill/blob/master/distribution/src/resources/storage-plugins.json
*2 Created Json Data:* in Path /home/yash/git/Drill/data.json
The content of Json is pasted in the end of mail.
*3. Start Drill: *Drill is started by
bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
*4. Query Json Data:* pass path with dfsdot`path\to\data.json`; (path in
back-tick)
0: jdbc:drill:zk=local
select * from dfs.`/home/yash/git/Drill/data.json`;
*5. Output*
+++++++
| title|name| width| height | image|text
|
+++++++
| Transparent Window | trn_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignm |
| White Window | white_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignment |
| black window | black_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignment |
+++++++
3 rows selected (0.095 seconds)
Same procedure for *CSV* Data:
*Query:*
select * from dfs.`/home/yash/Desktop/Drill/data.csv`;
select columns from dfs.`/home/yash/Desktop/Drill/data.csv`;
select columns[1] from dfs.`/home/yash/Desktop/Drill/data.csv`;
Hope it helps.
Peace,
Yash
JSON Data:
{
title: Transparent Window,
name: trn_window,
width: 500,
height: 500,
image: {
src: Images/Sun.png,
name: sun1,
hOffset: 250,
vOffset: 250,
alignment: center
},
text: {
data: Click Here,
size: 36,
style: bold,
name: text1,
hOffset: 250,
vOffset: 100,
alignment: center,
onMouseUp: sun1.opacity = (sun1.opacity / 100) * 90;
}
}
{
title: White Window,
name: white_window,
width: 500,
height: 500,
image: {
src: Images/Sun.png,
name: sun1,
hOffset: 250,
vOffset: 250,
alignment: center
},
text: {
data: Click Here,
size: 36,
style: bold,
name: text1,
hOffset: 250,
vOffset: 100,
alignment: center,
onMouseUp: sun1.opacity = (sun1.opacity / 100) * 90;
}
}
{
title: black window,
name: black_window,
width: 500,
height: 500,
image: {
src: Images/Sun.png,
name: sun1,
hOffset: 250,
vOffset: 250,
alignment: center
},
text: {
data: Click Here,
size: 36,
style: bold,
name: text1,
hOffset: 250,
vOffset: 100,
alignment: center,
onMouseUp: sun1.opacity = (sun1.opacity / 100) * 90;
}
}
CSV Data:
u1,purchase,iphone
u1,purchase,ipad
u2,purchase,nexus
u2,purchase,galaxy
u3,purchase,surface
u4,purchase,iphone
u4,purchase,galaxy
u1,view,iphone
u1,view,ipad
u1,view,nexus
u1,view,galaxy
u2,view,iphone
u2,view,ipad
u2,view,nexus
u2,view,galaxy
u3,view,surface
u3,view,nexus
u4,view,iphone
u4,view,ipad
u4,view,galaxy
On Fri, May 23, 2014 at 9:06 PM, Jason Altekruse
altekruseja...@gmail.comwrote:
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
?????? ?????? ?????? ?????? error when querying a csv file with drill.
Thanks.
I compiled it before, but now I use drill in my cluster environment where
Network isn't available. but I would try again in my own ubuntu ma chine. So is
this version problem with binary installed drill package?
-- --
??: Yash Sharmayash...@gmail.com;
: 2014??5??24??(??) 3:17
??: drill-userdrill-user@incubator.apache.org;
: Re: ?? ?? ?? error when querying a csv file with drill.
Hi Bevin,
These are the steps to build directly from the source:
// Get Drill Source
$ git clone https://github.com/apache/incubator-drill.git
$ cd incubator-drill
// Inside /DRILL DIR/
$ mvn clean install -DskipTests
// Install Drill
$ mkdir /opt/drill
$ tar xvzf distribution/target/*.tar.gz --strip=1 -C /opt/drill
// Switch to installed directory
$ cd /opt/drill
$ sudo bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
0: jdbc:drill:zk=local
select * from dfs.`/home/yash/git/Drill/data.json`;
Let me know if this works.
Peace Yash
On Sat, May 24, 2014 at 12:10 PM, i02...@qq.com wrote:
Hi, thank you for your reply.
I failed the query again this morning.
I can query json file correctly. (oddly, I use jsonl schema which defined
in storage-engines.json and there query with ??select * from file.json ??,
not back ticks).
I use binary version of drill, Is that can be a reason I failed to query?
I would appreciate it if you send your entire Drill directory zip package
to me. i02...@qq.com or bevi...@gmail.com .
THANKS
-- --
??: Yash Sharma;yash...@gmail.com;
: 2014??5??24??(??) 1:52
??: drill-userdrill-user@incubator.apache.org;
: Re: ?? ?? error when querying a csv file with drill.
Hi All,
Is the main issue on connecting/querying to the json/csv data sources.
Here is what I did for querying Json/Csv data Sources.
Let me know if this is what we are looking for... or I am missing the
context here..
1. I did not modify the storage-plugin.json.
https://github.com/apache/incubator-drill/blob/master/distribution/src/resources/storage-plugins.json
*2 Created Json Data:* in Path /home/yash/git/Drill/data.json
The content of Json is pasted in the end of mail.
*3. Start Drill: *Drill is started by
bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
*4. Query Json Data:* pass path with dfsdot`path\to\data.json`; (path in
back-tick)
0: jdbc:drill:zk=local
select * from dfs.`/home/yash/git/Drill/data.json`;
*5. Output*
+++++++
| title|name| width| height | image|text
|
+++++++
| Transparent Window | trn_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignm |
| White Window | white_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignment |
| black window | black_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignment |
+++++++
3 rows selected (0.095 seconds)
Same procedure for *CSV* Data:
*Query:*
select * from dfs.`/home/yash/Desktop/Drill/data.csv`;
select columns from dfs.`/home/yash/Desktop/Drill/data.csv`;
select columns[1] from dfs.`/home/yash/Desktop/Drill/data.csv`;
Hope it helps.
Peace,
Yash
JSON Data:
{
title: Transparent Window,
name: trn_window,
width: 500,
height: 500,
image: {
src: Images/Sun.png,
name: sun1,
hOffset: 250,
vOffset: 250,
alignment: center
},
text: {
data: Click Here,
size: 36,
style: bold,
name: text1,
hOffset: 250,
vOffset: 100,
alignment: center,
onMouseUp: sun1.opacity = (sun1.opacity / 100) * 90;
}
}
{
title: White Window,
name: white_window,
width: 500,
height: 500,
image: {
src: Images/Sun.png,
name: sun1,
hOffset: 250,
vOffset: 250,
alignment: center
},
text: {
data: Click Here,
size: 36,
style: bold,
name: text1,
hOffset: 250,
vOffset: 100,
alignment: center,
onMouseUp: sun1.opacity = (sun1.opacity / 100) * 90;
}
}
{
title: black window,
name: black_window,
width: 500,
height: 500,
image: {
src: Images/Sun.png,
name: sun1,
hOffset: 250,
vOffset: 250,
alignment: center
},
text: {
data: Click Here,
size: 36,
style: bold,
name: text1,
hOffset: 250,
vOffset: 100,
alignment: center,
onMouseUp: sun1.opacity = (sun1.opacity / 100) * 90;
}
}
CSV Data:
u1,purchase,iphone
u1,purchase,ipad
u2,purchase,nexus
u2,purchase,galaxy
u3,purchase,surface
u4,purchase,iphone
u4,purchase,galaxy
u1,view,iphone
u1,view,ipad
?????? ?????? ?????? ?????? ?????? error when querying a csv file with drill.
ERROR :No known driver to handle x, That why I turn to binary. ==~
bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:zk=local -n admin -p admin
scan complete in 81ms
scan complete in 984ms
No known driver to handle jdbc:drill:zk=local
sqlline version 1.0.2 by Marc Prud'hommeaux
sqlline !quit
bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:schmea=dfs -n admin -p
admin
scan complete in 119ms
scan complete in 825ms
No known driver to handle jdbc:drill:schmea=dfs
sqlline version 1.0.2 by Marc Prud'hommeaux
sqlline
-- --
??: Yash Sharma;yash...@gmail.com;
: 2014??5??24??(??) 3:37
??: drill-userdrill-user@incubator.apache.org;
: Re: ?? ?? ?? ?? error when querying a csv file with drill.
I am not sure of the root cause Bevin.
I would try to run queries on the binaries and let you know.
Peace,
Yash
On Sat, May 24, 2014 at 12:31 PM, i02...@qq.com wrote:
Thanks.
I compiled it before, but now I use drill in my cluster environment where
Network isn't available. but I would try again in my own ubuntu ma chine.
So is this version problem with binary installed drill package?
-- --
??: Yash Sharmayash...@gmail.com;
: 2014??5??24??(??) 3:17
??: drill-userdrill-user@incubator.apache.org;
: Re: ?? ?? ?? error when querying a csv file with drill.
Hi Bevin,
These are the steps to build directly from the source:
// Get Drill Source
$ git clone https://github.com/apache/incubator-drill.git
$ cd incubator-drill
// Inside /DRILL DIR/
$ mvn clean install -DskipTests
// Install Drill
$ mkdir /opt/drill
$ tar xvzf distribution/target/*.tar.gz --strip=1 -C /opt/drill
// Switch to installed directory
$ cd /opt/drill
$ sudo bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
0: jdbc:drill:zk=local
select * from dfs.`/home/yash/git/Drill/data.json`;
Let me know if this works.
Peace Yash
On Sat, May 24, 2014 at 12:10 PM, i02...@qq.com wrote:
Hi, thank you for your reply.
I failed the query again this morning.
I can query json file correctly. (oddly, I use jsonl schema which defined
in storage-engines.json and there query with ??select * from file.json
??,
not back ticks).
I use binary version of drill, Is that can be a reason I failed to query?
I would appreciate it if you send your entire Drill directory zip package
to me. i02...@qq.com or bevi...@gmail.com .
THANKS
-- --
??: Yash Sharma;yash...@gmail.com;
: 2014??5??24??(??) 1:52
??: drill-userdrill-user@incubator.apache.org;
: Re: ?? ?? error when querying a csv file with drill.
Hi All,
Is the main issue on connecting/querying to the json/csv data sources.
Here is what I did for querying Json/Csv data Sources.
Let me know if this is what we are looking for... or I am missing the
context here..
1. I did not modify the storage-plugin.json.
https://github.com/apache/incubator-drill/blob/master/distribution/src/resources/storage-plugins.json
*2 Created Json Data:* in Path /home/yash/git/Drill/data.json
The content of Json is pasted in the end of mail.
*3. Start Drill: *Drill is started by
bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
*4. Query Json Data:* pass path with dfsdot`path\to\data.json`; (path
in
back-tick)
0: jdbc:drill:zk=local
select * from dfs.`/home/yash/git/Drill/data.json`;
*5. Output*
+++++++
| title|name| width| height | image|
text
|
+++++++
| Transparent Window | trn_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignm |
| White Window | white_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignment |
| black window | black_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignment |
+++++++
3 rows selected (0.095 seconds)
Same procedure for *CSV* Data:
*Query:*
select * from dfs.`/home/yash/Desktop/Drill/data.csv`;
select columns from dfs.`/home/yash/Desktop/Drill/data.csv`;
select columns[1] from dfs.`/home/yash/Desktop/Drill/data.csv`;
Hope it helps.
Peace,
Yash
JSON Data:
{
title: Transparent Window,
name: trn_window,
width: 500,
height: 500,
image: {
src: Images/Sun.png,
name: sun1,
hOffset: 250,
vOffset: 250,
alignment: center
},
text: {
data: Click Here,
size: 36,
?????? ?????? ?????? ?????? ?????? ?????? error when querying a csv file with drill.
I think not, now I git the newest package .
Can I use your compiled drill directly in my computer?
-- --
??: Yash Sharma;yash...@gmail.com;
: 2014??5??24??(??) 3:57
??: drill-userdrill-user@incubator.apache.org;
: Re: ?? ?? ?? ?? ?? error when querying a csv file
with drill.
Is this error message on a fresh pull?
On Sat, May 24, 2014 at 12:49 PM, i02...@qq.com wrote:
ERROR :No known driver to handle x, That why I turn to binary. ==~
bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:zk=local -n admin -p
admin
scan complete in 81ms
scan complete in 984ms
No known driver to handle jdbc:drill:zk=local
sqlline version 1.0.2 by Marc Prud'hommeaux
sqlline !quit
bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:schmea=dfs -n admin
-p admin
scan complete in 119ms
scan complete in 825ms
No known driver to handle jdbc:drill:schmea=dfs
sqlline version 1.0.2 by Marc Prud'hommeaux
sqlline
-- --
??: Yash Sharma;yash...@gmail.com;
: 2014??5??24??(??) 3:37
??: drill-userdrill-user@incubator.apache.org;
: Re: ?? ?? ?? ?? error when querying a csv file with
drill.
I am not sure of the root cause Bevin.
I would try to run queries on the binaries and let you know.
Peace,
Yash
On Sat, May 24, 2014 at 12:31 PM, i02...@qq.com wrote:
Thanks.
I compiled it before, but now I use drill in my cluster environment where
Network isn't available. but I would try again in my own ubuntu ma chine.
So is this version problem with binary installed drill package?
-- --
??: Yash Sharmayash...@gmail.com;
: 2014??5??24??(??) 3:17
??: drill-userdrill-user@incubator.apache.org;
: Re: ?? ?? ?? error when querying a csv file with drill.
Hi Bevin,
These are the steps to build directly from the source:
// Get Drill Source
$ git clone https://github.com/apache/incubator-drill.git
$ cd incubator-drill
// Inside /DRILL DIR/
$ mvn clean install -DskipTests
// Install Drill
$ mkdir /opt/drill
$ tar xvzf distribution/target/*.tar.gz --strip=1 -C /opt/drill
// Switch to installed directory
$ cd /opt/drill
$ sudo bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
0: jdbc:drill:zk=local
select * from dfs.`/home/yash/git/Drill/data.json`;
Let me know if this works.
Peace Yash
On Sat, May 24, 2014 at 12:10 PM, i02...@qq.com wrote:
Hi, thank you for your reply.
I failed the query again this morning.
I can query json file correctly. (oddly, I use jsonl schema which
defined
in storage-engines.json and there query with ??select * from file.json
??,
not back ticks).
I use binary version of drill, Is that can be a reason I failed to
query?
I would appreciate it if you send your entire Drill directory zip
package
to me. i02...@qq.com or bevi...@gmail.com .
THANKS
-- --
??: Yash Sharma;yash...@gmail.com;
: 2014??5??24??(??) 1:52
??: drill-userdrill-user@incubator.apache.org;
: Re: ?? ?? error when querying a csv file with drill.
Hi All,
Is the main issue on connecting/querying to the json/csv data sources.
Here is what I did for querying Json/Csv data Sources.
Let me know if this is what we are looking for... or I am missing the
context here..
1. I did not modify the storage-plugin.json.
https://github.com/apache/incubator-drill/blob/master/distribution/src/resources/storage-plugins.json
*2 Created Json Data:* in Path /home/yash/git/Drill/data.json
The content of Json is pasted in the end of mail.
*3. Start Drill: *Drill is started by
bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
*4. Query Json Data:* pass path with dfsdot`path\to\data.json`; (path
in
back-tick)
0: jdbc:drill:zk=local
select * from dfs.`/home/yash/git/Drill/data.json`;
*5. Output*
+++++++
| title|name| width| height | image|
text
|
+++++++
| Transparent Window | trn_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignm |
| White Window | white_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignment |
| black window | black_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignment |
?????? ?????? ?????? ?????? ?????? ?????? error when querying a csv file with drill.
Is that Apache Drill Milestone 1 - (Drill Alpha) is the newest version?
-- --
??: i02...@qq.com;
: 2014??5??24??(??) 3:34
??: drill-userdrill-user@incubator.apache.org;
: ?? ?? ?? ?? ?? ?? error when querying a csv file
with drill.
I think not, now I git the newest package .
Can I use your compiled drill directly in my computer?
-- --
??: Yash Sharma;yash...@gmail.com;
: 2014??5??24??(??) 3:57
??: drill-userdrill-user@incubator.apache.org;
: Re: ?? ?? ?? ?? ?? error when querying a csv file
with drill.
Is this error message on a fresh pull?
On Sat, May 24, 2014 at 12:49 PM, i02...@qq.com wrote:
ERROR :No known driver to handle x, That why I turn to binary. ==~
bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:zk=local -n admin -p
admin
scan complete in 81ms
scan complete in 984ms
No known driver to handle jdbc:drill:zk=local
sqlline version 1.0.2 by Marc Prud'hommeaux
sqlline !quit
bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:schmea=dfs -n admin
-p admin
scan complete in 119ms
scan complete in 825ms
No known driver to handle jdbc:drill:schmea=dfs
sqlline version 1.0.2 by Marc Prud'hommeaux
sqlline
-- --
??: Yash Sharma;yash...@gmail.com;
: 2014??5??24??(??) 3:37
??: drill-userdrill-user@incubator.apache.org;
: Re: ?? ?? ?? ?? error when querying a csv file with
drill.
I am not sure of the root cause Bevin.
I would try to run queries on the binaries and let you know.
Peace,
Yash
On Sat, May 24, 2014 at 12:31 PM, i02...@qq.com wrote:
Thanks.
I compiled it before, but now I use drill in my cluster environment where
Network isn't available. but I would try again in my own ubuntu ma chine.
So is this version problem with binary installed drill package?
-- --
??: Yash Sharmayash...@gmail.com;
: 2014??5??24??(??) 3:17
??: drill-userdrill-user@incubator.apache.org;
: Re: ?? ?? ?? error when querying a csv file with drill.
Hi Bevin,
These are the steps to build directly from the source:
// Get Drill Source
$ git clone https://github.com/apache/incubator-drill.git
$ cd incubator-drill
// Inside /DRILL DIR/
$ mvn clean install -DskipTests
// Install Drill
$ mkdir /opt/drill
$ tar xvzf distribution/target/*.tar.gz --strip=1 -C /opt/drill
// Switch to installed directory
$ cd /opt/drill
$ sudo bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
0: jdbc:drill:zk=local
select * from dfs.`/home/yash/git/Drill/data.json`;
Let me know if this works.
Peace Yash
On Sat, May 24, 2014 at 12:10 PM, i02...@qq.com wrote:
Hi, thank you for your reply.
I failed the query again this morning.
I can query json file correctly. (oddly, I use jsonl schema which
defined
in storage-engines.json and there query with ??select * from file.json
??,
not back ticks).
I use binary version of drill, Is that can be a reason I failed to
query?
I would appreciate it if you send your entire Drill directory zip
package
to me. i02...@qq.com or bevi...@gmail.com .
THANKS
-- --
??: Yash Sharma;yash...@gmail.com;
: 2014??5??24??(??) 1:52
??: drill-userdrill-user@incubator.apache.org;
: Re: ?? ?? error when querying a csv file with drill.
Hi All,
Is the main issue on connecting/querying to the json/csv data sources.
Here is what I did for querying Json/Csv data Sources.
Let me know if this is what we are looking for... or I am missing the
context here..
1. I did not modify the storage-plugin.json.
https://github.com/apache/incubator-drill/blob/master/distribution/src/resources/storage-plugins.json
*2 Created Json Data:* in Path /home/yash/git/Drill/data.json
The content of Json is pasted in the end of mail.
*3. Start Drill: *Drill is started by
bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
*4. Query Json Data:* pass path with dfsdot`path\to\data.json`; (path
in
back-tick)
0: jdbc:drill:zk=local
select * from dfs.`/home/yash/git/Drill/data.json`;
*5. Output*
+++++++
| title|name| width| height | image|
text
|
+++++++
| Transparent Window | trn_window | 500| 500|
{alignment:center,hOffset:250,name:sun1,src:Images/Sun.png,vOffset:250}
| {alignm |
| White Window |
?????? ?????? ?????? ?????? ?????? ?????? ?????? error when querying a csv file with drill.
Thanks I compile m2 version successfully. Looks like readme.md file doesn't update to m2 . lol. No known driver to handle jdbc:drill:zk=local occurs. and run sqlline: bevin@le:/opt/drill$ sqlline -u jdbc:drill:zk=local -n admin -p admin scan complete in 109ms scan complete in 894ms No known driver to handle jdbc:drill:zk=local sqlline version 1.0.2 by Marc Prud'hommeaux sqlline select * from `/home/data.csv`; No current connection sqlline select * from dfs.`/home/data.csv`; No current connection -- -- ??: Yash Sharma;yash...@gmail.com; : 2014??5??24??(??) 4:21 ??: drill-userdrill-user@incubator.apache.org; : Re: ?? ?? ?? ?? ?? ?? error when querying a csv file with drill. Try the new binaries out: https://www.dropbox.com/sm/create/apache-drill-1.0.0-m2-incubating-SNAPSHOT-binary-release.tar.gz Its ~90 Megs. Extract the tar to the installation dir as before and execute the queries on it. Also you can try this old method on the M1 version of binaries. This was the old way of querying Sqlline: http://www.confusedcoders.com/bigdata/apache-drill/apache-drill-executing-sample-sql-queries-on-json-data Let me know if either one works. Peace, Yash On Sat, May 24, 2014 at 1:15 PM, Yash Sharma yash...@gmail.com wrote: Building from source would give you M2 version. Let me put my binary tarball on dropbox. On Sat, May 24, 2014 at 1:10 PM, i02...@qq.com wrote: Is that Apache Drill Milestone 1 - (Drill Alpha) is the newest version? -- -- ??: i02...@qq.com; : 2014??5??24??(??) 3:34 ??: drill-userdrill-user@incubator.apache.org; : ?? ?? ?? ?? ?? ?? error when querying a csv file with drill. I think not, now I git the newest package . Can I use your compiled drill directly in my computer? -- -- ??: Yash Sharma;yash...@gmail.com; : 2014??5??24??(??) 3:57 ??: drill-userdrill-user@incubator.apache.org; : Re: ?? ?? ?? ?? ?? error when querying a csv file with drill. Is this error message on a fresh pull? On Sat, May 24, 2014 at 12:49 PM, i02...@qq.com wrote: ERROR :No known driver to handle x, That why I turn to binary. ==~ bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:zk=local -n admin -p admin scan complete in 81ms scan complete in 984ms No known driver to handle jdbc:drill:zk=local sqlline version 1.0.2 by Marc Prud'hommeaux sqlline !quit bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:schmea=dfs -n admin -p admin scan complete in 119ms scan complete in 825ms No known driver to handle jdbc:drill:schmea=dfs sqlline version 1.0.2 by Marc Prud'hommeaux sqlline -- -- ??: Yash Sharma;yash...@gmail.com; : 2014??5??24??(??) 3:37 ??: drill-userdrill-user@incubator.apache.org; : Re: ?? ?? ?? ?? error when querying a csv file with drill. I am not sure of the root cause Bevin. I would try to run queries on the binaries and let you know. Peace, Yash On Sat, May 24, 2014 at 12:31 PM, i02...@qq.com wrote: Thanks. I compiled it before, but now I use drill in my cluster environment where Network isn't available. but I would try again in my own ubuntu ma chine. So is this version problem with binary installed drill package? -- -- ??: Yash Sharmayash...@gmail.com; : 2014??5??24??(??) 3:17 ??: drill-userdrill-user@incubator.apache.org; : Re: ?? ?? ?? error when querying a csv file with drill. Hi Bevin, These are the steps to build directly from the source: // Get Drill Source $ git clone https://github.com/apache/incubator-drill.git $ cd incubator-drill // Inside /DRILL DIR/ $ mvn clean install -DskipTests // Install Drill $ mkdir /opt/drill $ tar xvzf distribution/target/*.tar.gz --strip=1 -C /opt/drill // Switch to installed directory $ cd /opt/drill $ sudo bin/sqlline -u jdbc:drill:zk=local -n admin -p admin 0: jdbc:drill:zk=local select * from dfs.`/home/yash/git/Drill/data.json`; Let me know if this works. Peace Yash On Sat, May 24, 2014 at 12:10 PM, i02...@qq.com wrote: Hi, thank you for your reply. I failed the query again this morning. I can query json file correctly. (oddly, I use jsonl schema which defined in storage-engines.json and there query with ??select * from file.json ??, not back ticks). I use binary version of drill, Is that can be a reason I failed to query? I would appreciate it if you send your entire Drill
Re: 回复： 回复： 回复： 回复： 回复： 回复： 回复： error when querying a csv file with drill.
No current connection pops out sometimes if your JAVA_HOME is not set. Can you plz check that? On Sat, May 24, 2014 at 1:25 PM, 南在南方 i02...@qq.com wrote: Thanks I compile m2 version successfully. Looks like readme.md file doesn't update to m2 . lol. No known driver to handle jdbc:drill:zk=local occurs. and run sqlline: bevin@le:/opt/drill$ sqlline -u jdbc:drill:zk=local -n admin -p admin scan complete in 109ms scan complete in 894ms No known driver to handle jdbc:drill:zk=local sqlline version 1.0.2 by Marc Prud'hommeaux sqlline select * from `/home/data.csv`; No current connection sqlline select * from dfs.`/home/data.csv`; No current connection -- 原始邮件 -- 发件人: Yash Sharma;yash...@gmail.com; 发送时间: 2014年5月24日(星期六) 下午4:21 收件人: drill-userdrill-user@incubator.apache.org; 主题: Re: 回复： 回复： 回复： 回复： 回复： 回复： error when querying a csv file with drill. Try the new binaries out: https://www.dropbox.com/sm/create/apache-drill-1.0.0-m2-incubating-SNAPSHOT-binary-release.tar.gz Its ~90 Megs. Extract the tar to the installation dir as before and execute the queries on it. Also you can try this old method on the M1 version of binaries. This was the old way of querying Sqlline: http://www.confusedcoders.com/bigdata/apache-drill/apache-drill-executing-sample-sql-queries-on-json-data Let me know if either one works. Peace, Yash On Sat, May 24, 2014 at 1:15 PM, Yash Sharma yash...@gmail.com wrote: Building from source would give you M2 version. Let me put my binary tarball on dropbox. On Sat, May 24, 2014 at 1:10 PM, 南在南方 i02...@qq.com wrote: Is that Apache Drill Milestone 1 - (Drill Alpha) is the newest version? -- 原始邮件 -- 发件人: 南在南方i02...@qq.com; 发送时间: 2014年5月24日(星期六) 下午3:34 收件人: drill-userdrill-user@incubator.apache.org; 主题: 回复： 回复： 回复： 回复： 回复： 回复： error when querying a csv file with drill. I think not, now I git the newest package . Can I use your compiled drill directly in my computer? -- 原始邮件 -- 发件人: Yash Sharma;yash...@gmail.com; 发送时间: 2014年5月24日(星期六) 下午3:57 收件人: drill-userdrill-user@incubator.apache.org; 主题: Re: 回复： 回复： 回复： 回复： 回复： error when querying a csv file with drill. Is this error message on a fresh pull? On Sat, May 24, 2014 at 12:49 PM, 南在南方 i02...@qq.com wrote: ERROR :No known driver to handle x, That why I turn to binary. ==~ bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:zk=local -n admin -p admin scan complete in 81ms scan complete in 984ms No known driver to handle jdbc:drill:zk=local sqlline version 1.0.2 by Marc Prud'hommeaux sqlline !quit bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:schmea=dfs -n admin -p admin scan complete in 119ms scan complete in 825ms No known driver to handle jdbc:drill:schmea=dfs sqlline version 1.0.2 by Marc Prud'hommeaux sqlline -- 原始邮件 -- 发件人: Yash Sharma;yash...@gmail.com; 发送时间: 2014年5月24日(星期六) 下午3:37 收件人: drill-userdrill-user@incubator.apache.org; 主题: Re: 回复： 回复： 回复： 回复： error when querying a csv file with drill. I am not sure of the root cause Bevin. I would try to run queries on the binaries and let you know. Peace, Yash On Sat, May 24, 2014 at 12:31 PM, 南在南方 i02...@qq.com wrote: Thanks. I compiled it before, but now I use drill in my cluster environment where Network isn't available. but I would try again in my own ubuntu ma chine. So is this version problem with binary installed drill package? -- 原始邮件 -- 发件人: Yash Sharmayash...@gmail.com; 发送时间: 2014年5月24日(星期六) 下午3:17 收件人: drill-userdrill-user@incubator.apache.org; 主题: Re: 回复： 回复： 回复： error when querying a csv file with drill. Hi Bevin, These are the steps to build directly from the source: // Get Drill Source $ git clone https://github.com/apache/incubator-drill.git $ cd incubator-drill // Inside /DRILL DIR/ $ mvn clean install -DskipTests // Install Drill $ mkdir /opt/drill $ tar xvzf distribution/target/*.tar.gz --strip=1 -C /opt/drill // Switch to installed directory $ cd /opt/drill $ sudo bin/sqlline -u jdbc:drill:zk=local -n admin -p admin 0: jdbc:drill:zk=local select * from dfs.`/home/yash/git/Drill/data.json`; Let me know if this works. Peace Yash On Sat, May 24, 2014 at 12:10 PM, 南在南方 i02...@qq.com wrote: Hi, thank you for your reply. I failed the query again this morning. I can query json file correctly. (oddly, I use jsonl schema which defined in storage-engines.json and there query with “select * from file.json ”, not back ticks). I use binary version of drill,
?????? ?????? ?????? ?????? ?????? ?????? ?????? error when querying a csv file with drill.
The m2 binary URL you give returns 404 not found error. -- -- ??: i02...@qq.com; : 2014??5??24??(??) 3:55 ??: drill-userdrill-user@incubator.apache.org; : ?? ?? ?? ?? ?? ?? ?? error when querying a csv file with drill. Thanks I compile m2 version successfully. Looks like readme.md file doesn't update to m2 . lol. No known driver to handle jdbc:drill:zk=local occurs. and run sqlline: bevin@le:/opt/drill$ sqlline -u jdbc:drill:zk=local -n admin -p admin scan complete in 109ms scan complete in 894ms No known driver to handle jdbc:drill:zk=local sqlline version 1.0.2 by Marc Prud'hommeaux sqlline select * from `/home/data.csv`; No current connection sqlline select * from dfs.`/home/data.csv`; No current connection -- -- ??: Yash Sharma;yash...@gmail.com; : 2014??5??24??(??) 4:21 ??: drill-userdrill-user@incubator.apache.org; : Re: ?? ?? ?? ?? ?? ?? error when querying a csv file with drill. Try the new binaries out: https://www.dropbox.com/sm/create/apache-drill-1.0.0-m2-incubating-SNAPSHOT-binary-release.tar.gz Its ~90 Megs. Extract the tar to the installation dir as before and execute the queries on it. Also you can try this old method on the M1 version of binaries. This was the old way of querying Sqlline: http://www.confusedcoders.com/bigdata/apache-drill/apache-drill-executing-sample-sql-queries-on-json-data Let me know if either one works. Peace, Yash On Sat, May 24, 2014 at 1:15 PM, Yash Sharma yash...@gmail.com wrote: Building from source would give you M2 version. Let me put my binary tarball on dropbox. On Sat, May 24, 2014 at 1:10 PM, i02...@qq.com wrote: Is that Apache Drill Milestone 1 - (Drill Alpha) is the newest version? -- -- ??: i02...@qq.com; : 2014??5??24??(??) 3:34 ??: drill-userdrill-user@incubator.apache.org; : ?? ?? ?? ?? ?? ?? error when querying a csv file with drill. I think not, now I git the newest package . Can I use your compiled drill directly in my computer? -- -- ??: Yash Sharma;yash...@gmail.com; : 2014??5??24??(??) 3:57 ??: drill-userdrill-user@incubator.apache.org; : Re: ?? ?? ?? ?? ?? error when querying a csv file with drill. Is this error message on a fresh pull? On Sat, May 24, 2014 at 12:49 PM, i02...@qq.com wrote: ERROR :No known driver to handle x, That why I turn to binary. ==~ bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:zk=local -n admin -p admin scan complete in 81ms scan complete in 984ms No known driver to handle jdbc:drill:zk=local sqlline version 1.0.2 by Marc Prud'hommeaux sqlline !quit bevin@le:~/compiled-drill/bin$ sqlline -u jdbc:drill:schmea=dfs -n admin -p admin scan complete in 119ms scan complete in 825ms No known driver to handle jdbc:drill:schmea=dfs sqlline version 1.0.2 by Marc Prud'hommeaux sqlline -- -- ??: Yash Sharma;yash...@gmail.com; : 2014??5??24??(??) 3:37 ??: drill-userdrill-user@incubator.apache.org; : Re: ?? ?? ?? ?? error when querying a csv file with drill. I am not sure of the root cause Bevin. I would try to run queries on the binaries and let you know. Peace, Yash On Sat, May 24, 2014 at 12:31 PM, i02...@qq.com wrote: Thanks. I compiled it before, but now I use drill in my cluster environment where Network isn't available. but I would try again in my own ubuntu ma chine. So is this version problem with binary installed drill package? -- -- ??: Yash Sharmayash...@gmail.com; : 2014??5??24??(??) 3:17 ??: drill-userdrill-user@incubator.apache.org; : Re: ?? ?? ?? error when querying a csv file with drill. Hi Bevin, These are the steps to build directly from the source: // Get Drill Source $ git clone https://github.com/apache/incubator-drill.git $ cd incubator-drill // Inside /DRILL DIR/ $ mvn clean install -DskipTests // Install Drill $ mkdir /opt/drill $ tar xvzf distribution/target/*.tar.gz --strip=1 -C /opt/drill // Switch to installed directory $ cd /opt/drill $ sudo bin/sqlline -u jdbc:drill:zk=local -n admin -p admin 0: jdbc:drill:zk=local select * from dfs.`/home/yash/git/Drill/data.json`; Let me know if this works. Peace Yash On Sat, May 24, 2014 at 12:10 PM, i02...@qq.com wrote: Hi, thank you for your reply. I failed the query again this
Re: how get Parquet format file?
Anyone on this list would have been able to find it by just going back up a level on the URL and navigating to it, but the link lead to a 404 for me. Here is the direct link https://github.com/Parquet/parquet-compatibility/tree/master/parquet-testdata -Jason On Sat, May 24, 2014 at 9:44 AM, jaguarx xiong.jag...@gmail.com wrote: Some existing data https://github.com/Parquet/ parquet-compatibility/parquet-testdata Cheers! Jaguar On 05/24/2014 10:22 PM, 南在南方 wrote: Hi there,I want to do some efficiency test on parquet file with drill . But I couldn't get any. can u help me with this? I downloaded the Cloudera VM system but I don't know how to use it. I would appreciate if someone send me some. thanks bevin
?????? how get Parquet format file?
Thanks,It would be helpful. I found three folder in impala directory. 1.1.1-GZIP 1.1.1-NONE1.1.1-SNAPPY Can drill query all parquet file in any sub folder? Maybe I need more parquet for my test, Can u support more? ??^_^ -- -- ??: Jason Altekruse;altekruseja...@gmail.com; : 2014??5??24??(??) 10:52 ??: Apache Drill Userdrill-user@incubator.apache.org; : Re: how get Parquet format file? Anyone on this list would have been able to find it by just going back up a level on the URL and navigating to it, but the link lead to a 404 for me. Here is the direct link https://github.com/Parquet/parquet-compatibility/tree/master/parquet-testdata -Jason On Sat, May 24, 2014 at 9:44 AM, jaguarx xiong.jag...@gmail.com wrote: Some existing data https://github.com/Parquet/ parquet-compatibility/parquet-testdata Cheers! Jaguar On 05/24/2014 10:22 PM, wrote: Hi there,I want to do some efficiency test on parquet file with drill . But I couldn't get any. can u help me with this? I downloaded the Cloudera VM system but I don't know how to use it. I would appreciate if someone send me some. thanks bevin
