Hello
i am trying to use drill with hbase But i can't figure out wat's wrong
i have a drillbit start ok and storage engine:
{
"storage":{
"parquet-local" :
{
"type":"parquet",
"dfsName" : "file:///"
},
"parquet-cp" :
{
"type":"parquet",
"dfsName" : "classpath:///"
},
"jsonl" :
{
"type":"json",
"dfsName" : "file:///"
},
"json-cp" :
{
"type":"json",
"dfsName" : "classpath:///"
},
"parquet" :
{
"type":"parquet",
"dfsName" : "file:///"
},
"hbase" : {
type:"hbase",
config : {
"hbase.zookeeper.quorum" : "nosql",
"hbase.zookeeper.property.clientPort" : 2181
}
}
}
}
But i get this error when i try bin/sqlline -n admin -p admin -u
"jdbc:drill:schema=hbase;zk=nosql:2181" --verbose=true
Connecting to jdbc:drill:schema=hbase;zk=nosql:2181
com.fasterxml.jackson.databind.JsonMappingException: Could not resolve type
id 'hbase' into a subtype of [simple type, class
org.apache.drill.common.logical.StorageEngineConfig]
at [Source: java.io.StringReader@6ce6f5d6; line: 29, column: 2]
Error: Failure trying to connect to Drill. (state=,code=0)
java.sql.SQLException: Failure trying to connect to Drill.
at
org.apache.drill.jdbc.DrillHandler.onConnectionInit(DrillHandler.java:114)
at
net.hydromatic.optiq.jdbc.UnregisteredDriver.connect(UnregisteredDriver.java:127)
at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4802)
at sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4853)
at sqlline.SqlLine$Commands.connect(SqlLine.java:4094)
at sqlline.SqlLine$Commands.connect(SqlLine.java:4003)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2964)
at sqlline.SqlLine.dispatch(SqlLine.java:878)
at sqlline.SqlLine.initArgs(SqlLine.java:652)
at sqlline.SqlLine.begin(SqlLine.java:699)
at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:460)
at sqlline.SqlLine.main(SqlLine.java:443)
Caused by: com.fasterxml.jackson.databind.JsonMappingException: Could not
resolve type id 'hbase' into a subtype of [simple type, class
org.apache.drill.common.logical.StorageEngineConfig]
at [Source: java.io.StringReader@6ce6f5d6; line: 29, column: 2]
at
com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingException.java:164)
at
com.fasterxml.jackson.databind.DeserializationContext.unknownTypeException(DeserializationContext.java:701)
at
com.fasterxml.jackson.databind.jsontype.impl.TypeDeserializerBase._findDeserializer(TypeDeserializerBase.java:155)
at
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId(AsPropertyTypeDeserializer.java:98)
at
com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject(AsPropertyTypeDeserializer.java:82)
at
com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType(AbstractDeserializer.java:107)
at
com.fasterxml.jackson.databind.deser.std.MapDeserializer._readAndBindStringMap(MapDeserializer.java:431)
at
com.fasterxml.jackson.databind.deser.std.MapDeserializer.deserialize(MapDeserializer.java:310)
at
com.fasterxml.jackson.databind.deser.std.MapDeserializer.deserialize(MapDeserializer.java:26)
at
com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize(SettableBeanProperty.java:375)
at
com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased(BeanDeserializer.java:559)
at
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObjectUsingNonDefault(BeanDeserializer.java:393)
at
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFromObject(BeanDeserializer.java:289)
at
com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:121)
at
com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:2796)
at
com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:1942)
at
org.apache.drill.jdbc.DrillHandler.onConnectionInit(DrillHandler.java:76)
... 15 more
sqlline version ??? by Marc Prud'hommeaux
anny help would be appriciate
Thanks