About druid-0.9.2 lookup use jdbc

when i use lookup and got
{

“error”: “Unknown exception”,

“errorMessage”: “Could not resolve type id ‘namespace’ into a subtype of [simple type, class io.druid.query.lookup.LookupExtractor]\n at [Source: HttpInputOverHTTP@3ae98f4c; line: 14, column: 21] (through reference chain: java.util.ArrayList[0])”,

“errorClass”: “com.fasterxml.jackson.databind.JsonMappingException”,

“host”: null

}

``

my lookup content

{

“__default”: {

“site_id”: {

“type”: “cachedNamespace”,

“extractionNamespace”: {

“type”: “jdbc”,

“connectorConfig”: {

“createTables”: true,

“connectURI”: “jdbc:mysql://xx.xx.xxx.xxx:3306/druid”,

“user”: “xxxxx”,

“password”: “xxxxx”

},

“table”: “lookupTable”,

“keyColumn”: “service”,

“valueColumn”: “service_level”

},

“firstCacheTimeout”: 120000,

“injective”: true

}

}

}

``

and my groupby request is

{

“queryType”: “groupBy”,

“dataSource”: “kk-0118”,

“granularity”: “hour”,

“descending”: “true”,

“dimensions”: [

{

“type”: “extraction”,

“dimension”: “service”,

“outputName”: “cluster”,

“extractionFn”: {

“type”: “lookup”,

“lookup”: {

“type”: “namespace”,

“namespace”: “site_id”

}

},

“replaceMissingValueWith”: “Unknown”,

“injective”: true

},

{

“type”:“default”,

“dimension”: “beId”,

“outputName”: “beId”

},

{

“type”:“default”,

“dimension”: “businessCode”,

“outputName”: “businessCode”

},

{

“type”:“default”,

“dimension”: “dn”,

“outputName”: “dn”

},

{

“type”:“default”,

“dimension”: “measunit”,

“outputName”: “measunit”

},

{

“type”:“default”,

“dimension”: “channelType”,

“outputName”: “channelType”

}

],

“intervals”: [

“2017-01-11T00:00:00/2017-01-13T10:00:00”

],

“aggregations”: [

{

“type”: “longSum”,

“fieldName”: “count”,

“name”: “countssss”

},

{

“type”: “longSum”,

“fieldName”: “succeedCount”,

“name”: “succeedCount”

}

]

}

``

when i send the request got the error above

here is my config (my druid is a single node)

common.runtime.properties

druid.extensions.loadList=[“druid-kafka-eight”, “druid-histogram”, “druid-datasketches”, “druid-lookups-cached-global”, “druid-kafka-indexing-service”,“druid-hdfs-storage”,“mysql-metadata-storage”,“druid-lookups-cached-single”]

``

and this is my table in mysql

servicename0 servicename_low

servicename1 servicename_low

servicename2 servicename_high

servicename3 servicename_high

servicename4 servicename_high

``

so anyone know detail about the druid lookup? thank you

after read druid doc again, find out that my query json is not correct, the request format is changed in 0.9.2
http://druid.io/docs/latest/development/extensions-core/namespaced-lookup.html

old:

"extractionFn":{
  "type":"lookup",
  "lookup":{
    "type":"namespace",
    "namespace":"some_uri_lookup"
  }
}

在 2017年1月20日星期五 UTC+8上午11:09:02,guav…@gmail.com写道:

when i use lookup and got
{

“error”: “Unknown exception”,

“errorMessage”: “Could not resolve type id ‘namespace’ into a subtype of [simple type, class io.druid.query.lookup.LookupExtractor]\n at [Source: HttpInputOverHTTP@3ae98f4c; line: 14, column: 21] (through reference chain: java.util.ArrayList[0])”,

“errorClass”: “com.fasterxml.jackson.databind.JsonMappingException”,

“host”: null

}

``

new:

"extractionFn":{
  "type":"registeredLookup",
  "lookup":"some_uri_lookup" }

so i changed my look json dim to

“dimensions”: [

{

“type”: “extraction”,

“dimension”: “service”,

“outputName”: “cluster”,

“extractionFn”: {

“type”: “registeredLookup”,

“lookup”:“site_id”,

“replaceMissingValueWith”: “Unknown”,

“injective”: true

}

},

{

“type”: “default”,

“dimension”: “beId”,

“outputName”: “beId”

},

{

“type”: “default”,

“dimension”: “businessCode”,

“outputName”: “businessCode”

},

{

“type”: “default”,

“dimension”: “dn”,

“outputName”: “dn”

},

{

“type”: “default”,

“dimension”: “measunit”,

“outputName”: “measunit”

},

{

“type”: “default”,

“dimension”: “channelType”,

“outputName”: “channelType”

}

]

it works…