You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by 南在南方 <i0...@qq.com> on 2014/05/27 04:05:39 UTC
Error when querying data on HBASE
Hi there,When I run a query on HBASE database, the query just stick there with nothing returned. It seems that sqlline process is dead.
BTW, Is there any document of DRQL grammar?
[root@fan bin]# ./sqlline -n admin -p admin -u jdbc:drill:zk=fan:2181,slave2:2181,slave3:2181
sqlline version 1.1.6
0: jdbc:drill:zk=fan:2181,slave2:2181,slave3:> select * from hbase.`students`;
my storage-plugins.json:
{
"storage":{
dfs: {
type: "file",
connection: "file:///",
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:///"
},
fan: {
type: "file",
connection: "hdfs://100.2.12.103:9000",
workspaces: {
"root" : {
location: "/",
writable: true,
storageformat:"parquet"
},
"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"
}
}
},
hbase : {
type:"hbase",
config : {
"hbase.zookeeper.quorum" : "fan,slave2,slave3",
"hbase.zookeeper.property.clientPort" : 2222
}
}
}
}