incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "南在南方" <i02...@qq.com>
Subject 回复: Query error when applying drill in cluster environment
Date Mon, 26 May 2014 08:34:27 GMT
Hi,
I connected Drill with 
"./bin/sqlline -n admin -p admin -u jdbc:drill:schema=dfs;zk=fan:2181,slave2:2181,slave3:2181"
"./bin/sqlline -n admin -p admin -u jdbc:drill:zk=fan:2181,slave2:2181,slave3:2181"


Both return No DrillbitEndpoint can be found error:


 [root@fan bin]# sqlline -n admin -p admin -u jdbc:drill:schema=dfs;zk=fan:2181,slave2:2181,slave3:2181
No DrillbitEndpoint can be found
sqlline version 1.1.6
0: jdbc:drill:schema=dfs> 




Is zk course the problem?





------------------ 原始邮件 ------------------
发件人: "南在南方"<i02389@qq.com>; 
发送时间: 2014年5月24日(星期六) 晚上9:52
收件人: "drill-user"<drill-user@incubator.apache.org>; "drill-user"<drill-user@incubator.apache.org>;

主题: 回复: Query error when applying drill in cluster environment



I found my zookeeper on slave3 doesn't work . I would rerun those query when I figure this
out. thanks




------------------ 原始邮件 ------------------
发件人: "Yash Sharma"<yash360@gmail.com>; 
发送时间: 2014年5月24日(星期六) 晚上9:57
收件人: "drill-user"<drill-user@incubator.apache.org>; 
主题: Re: Query error when applying drill in cluster environment



Dis you try connecting to Sqlline without specifying schema as well?
bin/sqlline -u jdbc:drill:zk=local -n admin -p admin

Also, could you paste the error you get while connecting with the dfs
schema specified.



On Sat, May 24, 2014 at 6:44 PM, 南在南方 <i02389@qq.com> wrote:

> Hi,
> Then I put the m2 version into my cluster and replaced drill m1.
> I connected with "./bin/sqlline -n admin -p admin -u
> jdbc:drill:schema=dfs;zk=fan:2181,slave2:2181,slave3:2181"
> some error occurs:
>
>
> 0: jdbc:drill:schema=dfs> select * from dfs.`AllstarFull.csv`;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
> running query.[error_id: "29ff1ff5-1d59-4fe5-adf7-eaea48f7b9ed"
> endpoint {
>   address: "slave2"
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < ValidationException:[
> org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to
> line 1, column 35 ] < EigenbaseContextException:[ From line 1, column 15 to
> line 1, column 35 ] < SqlValidatorException:[ Table 'dfs.AllstarFull.csv'
> not found ]"
> ]
> Error: exception while executing query (state=,code=0)
>
>
>
> The following query return some error report:
> select * from `nation.parquet`;
> select * from `tt.json`;
>
>
> Here is my storage-plugins.json :
> {
>   "storage":{
>     dfs: {
>       type: "file",
>       connection: "hdfs://100.2.12.103:9000"
>       workspaces: {
>         "root" : {
>           location: "/",
>           writable: false
>         },
>         "tmp" : {
>           location: "/tmp",
>           writable: true,
>           storageformat: "csv"
>         }
>       },
>       formats: {
>         "psv" : {
>           type: "text",
>           extensions: [ "tbl" ],
>           delimiter: "|"
>         },
>         "csv" : {
>           type: "text",
>           extensions: [ "csv" ],
>           delimiter: ","
>         },
>         "tsv" : {
>           type: "text",
>           extensions: [ "tsv" ],
>           delimiter: "\t"
>         },
>         "parquet" : {
>           type: "parquet"
>         },
>         "json" : {
>           type: "json"
>         }
>       }
>     },
>     cp: {
>       type: "file",
>       connection: "classpath:///"
>     }
>
>
>
> Thanks.
Mime
  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message