Hi
Testing metabase against a mongoDB table.
One of the fields native type is int32, and marked as Quantity in the Records data model.
No matter what, there is no bin option for aggregation, so it is not possible to create a proper histogram
I have tried to resync the DB, remove cached field values, re-scan the field, etc, no results
Also enabled regular Sync, and waited few hours/cycles.. nothing
Table does not contain null values
Another record, with datetime type, shows proper aggregation options
Any hits on what could be the issue?
Logs show classify and fingerprinting completes successfully:
[609f8209-9249-4ade-8885-378d9236ec19] 2021-09-30T16:15:06+02:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [************······································] 😒 25% Table 11 'records'
[609f8209-9249-4ade-8885-378d9236ec19] 2021-09-30T16:15:06+02:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for mongo Database 3 'WCAE_Feature_Usage'
[609f8209-9249-4ade-8885-378d9236ec19] 2021-09-30T16:15:06+02:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for mongo Database 3 'WCAE_Feature_Usage' (3.4 ms)
[609f8209-9249-4ade-8885-378d9236ec19] 2021-09-30T16:15:06+02:00 INFO metabase.sync.util STARTING: step 'classify-fields' for mongo Database 3 'WCAE_Feature_Usage'
[609f8209-9249-4ade-8885-378d9236ec19] 2021-09-30T16:15:06+02:00 INFO metabase.sync.analyze classify-fields Analyzed [*************************·························] 😬 50% Table 11 'records'
[609f8209-9249-4ade-8885-378d9236ec19] 2021-09-30T16:15:06+02:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for mongo Database 3 'WCAE_Feature_Usage' (1.1 ms)
[609f8209-9249-4ade-8885-378d9236ec19] 2021-09-30T16:15:06+02:00 INFO metabase.sync.util STARTING: step 'classify-tables' for mongo Database 3 'WCAE_Feature_Usage'
[609f8209-9249-4ade-8885-378d9236ec19] 2021-09-30T16:15:06+02:00 INFO metabase.sync.analyze classify-tables Analyzed [*************************************·············] 😋 75% Table 11 'records'
[609f8209-9249-4ade-8885-378d9236ec19] 2021-09-30T16:15:06+02:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for mongo Database 3 'WCAE_Feature_Usage' (1.1 ms)
[609f8209-9249-4ade-8885-378d9236ec19] 2021-09-30T16:15:06+02:00 INFO metabase.sync.util FINISHED: Analyze data for mongo Database 3 'WCAE_Feature_Usage' (10.7 ms)
Metabase data:
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:92.0) Gecko/20100101 Firefox/92.0",
"vendor": ""
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.7+9-202002041938",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.7",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.7+9-202002041938",
"os.name": "Mac OS X",
"os.version": "10.15.7",
"user.language": "en",
"user.timezone": "Europe/Madrid"
},
"metabase-info": {
"databases": [
"h2",
"mongo"
],
"hosting-env": "osx",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2021-09-21",
"tag": "v0.40.5",
"branch": "release-x.40.x",
"hash": "042a36e"
},
"settings": {
"report-timezone": null
}
}
}
record data:
{
"active": true,
"base_type": "type/Integer",
"caveats": null,
"coercion_strategy": null,
"created_at": "2021-09-30T10:21:53.979",
"custom_position": 0,
"database_position": 4,
"database_type": "java.lang.Integer",
"description": null,
"dimensions": [],
"display_name": "Rogue Entries",
"effective_type": "type/Integer",
"fingerprint": {
"global": {
"distinct-count": 95,
"nil%": 0.0
},
"type": {
"type/Number": {
"avg": 922.3859649122807,
"max": 11967.0,
"min": 0.0,
"q1": 46.16849141127193,
"q3": 885.0,
"sd": 1651.8386529691288
}
}
},
"fingerprint_version": 5,
"fk_target_field_id": null,
"has_field_values": "list",
"id": 754,
"last_analyzed": "2021-09-30T10:22:04.814",
"name": "Rogue_Entries",
"name_field": null,
"parent_id": null,
"points_of_interest": null,
"position": 4,
"preview_display": true,
"semantic_type": "type/Quantity",
"settings": null,
"table": {
"active": true,
"caveats": null,
"created_at": "2021-09-30T10:21:52.233",
"db": {
"auto_run_queries": true,
"cache_field_values_schedule": "0 0 16 * * ? *",
"caveats": null,
"created_at": "2021-09-30T10:21:49.919",
"description": null,
"details": {
"additional-options": null,
"authdb": null,
"dbname": "task__Feature_Usage",
"host": "bdb-dbaas-alln-1",
"pass": "**MetabasePass**",
"port": 27000,
"ssl": false,
"tunnel-enabled": false,
"use-connection-uri": false,
"use-srv": false,
"user": "_Feature_Usage"
},
"engine": "mongo",
"features": [
"basic-aggregations",
"nested-fields",
"native-parameters",
"case-sensitivity-string-filter-options"
],
"id": 3,
"is_full_sync": true,
"is_on_demand": false,
"is_sample": false,
"metadata_sync_schedule": "0 15 * * * ? *",
"name": "_Feature_Usage",
"options": null,
"points_of_interest": null,
"refingerprint": null,
"timezone": null,
"updated_at": "2021-09-30T11:39:15.878"
},
"db_id": 3,
"description": null,
"display_name": "Records",
"entity_name": null,
"entity_type": "entity/GenericTable",
"field_order": "database",
"id": 11,
"name": "records",
"points_of_interest": null,
"schema": null,
"show_in_getting_started": false,
"updated_at": "2021-09-30T10:22:04.81",
"visibility_type": null
},
"table_id": 11,
"updated_at": "2021-09-30T14:21:35.102",
"visibility_type": "normal"
}
Thanks
on the first post