SpyderRivera commented on issue #4740: Add extraction function support for 
Druid queries
URL: 
https://github.com/apache/incubator-superset/pull/4740#issuecomment-386110982
 
 
   The filtering works when an extractionFn is added to the dimension spec of 
the lookup, but then the look up doesn't work as a column.
   
   ```{
     "dimension": "country",
     "outputName": "country_group",
     "outputType": "STRING",
     "retainMissingValue": true,
     "type": "selector",
     "extractionFn": {
       "type": "lookup",
       "lookup": {
         "map": {
           "Algeria": "EMEA",
           "Faroe Islands": "EMEA",
           "Luxembourg": "EMEA",
           "Andorra": "EMEA",
           "Cameroon": "EMEA",
           "Burkina Faso": "EMEA",
           "Benin": "EMEA",
           "Bahrain": "EMEA",
           "Aland Islands": "EMEA",
           "Australia": "AU/NZ",
           "Iceland": "EMEA",
           "Cape Verde": "EMEA",
           "Germany": "EMEA",
           "Bosnia and Herzegovina": "EMEA",
           "Belgium": "EMEA",
           "Netherlands": "EMEA",
           "Central African Republic": "EMEA",
           "Belarus": "EMEA",
           "Albania": "EMEA",
           "Switzerland": "EMEA",
           "New Zealand": "AU/NZ",
           "Bulgaria": "EMEA",
           "Greenland": "EMEA",
           "Angola": "EMEA",
           "Chad": "EMEA",
           "Svalbard and Jan Mayen": "EMEA",
           "Comoros": "EMEA",
           "Austria": "EMEA",
           "Burundi": "EMEA",
           "Botswana": "EMEA"
         },
         "type": "map",
         "isOneToOne": false
       }
     }
   }
   ``` 
   VS
   
   ```
   {
       "type": "lookup",
       "dimension": "country",
       "outputName": "country_group",
       "outputType": "STRING",
       "retainMissingValue": true,
       "lookup": {
         "type": "map",
         "map": {
           "Australia": "AU/NZ",
           "New Zealand": "AU/NZ",
           "Aland Islands": "EMEA",
           "Belgium": "EMEA",
           "Faroe Islands": "EMEA",
           "Greenland": "EMEA",
           "Iceland": "EMEA",
           "Luxembourg": "EMEA",
           "Netherlands": "EMEA",
           "Svalbard and Jan Mayen": "EMEA",
           "Austria": "EMEA",
           "Germany": "EMEA",
           "Switzerland": "EMEA",
           "Albania": "EMEA",
           "ALgeria": "EMEA",
           "Andorra": "EMEA",
           "Angola": "EMEA",
           "Bahrain": "EMEA",
           "Belarus": "EMEA",
           "Benin": "EMEA",
           "Bosnia and Herzegovina": "EMEA",
           "Botswana": "EMEA",
           "Bulgaria": "EMEA",
           "Burkina Faso": "EMEA",
           "Burundi": "EMEA",
           "Cameroon": "EMEA",
           "Cape Verde": "EMEA",
           "Central African Republic": "EMEA",
           "Chad": "EMEA",
           "Comoros": "EMEA"
         },
         "isOneToOne": false
       }
     }
   ```
   Here you can see the filter works, but the column values for country group 
are not populating.
   ![screen shot 2018-05-02 at 2 27 16 
pm](https://user-images.githubusercontent.com/3988262/39547568-34fdc8c6-4e15-11e8-9beb-faf495946163.png)
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services

Reply via email to