as pic, no "Auto binned" on the latitude section, what's the data type for latitude needs in grip map?
Hi @Jay
Post "Diagnostic Info" from Admin > Troubleshooting, and which database type you're querying.
And what is the database column type of those two columns?
I use ms sql 2019, the columns is dec(18,7)
{
"browser-info": {
"language": "zh-TW",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.128 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.10+9",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.10",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.10+9",
"os.name": "Linux",
"os.version": "5.4.0-70-generic",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"sqlserver"
],
"hosting-env": "unknown",
"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-03-17",
"tag": "v0.38.2",
"branch": "release-x.38.x",
"hash": "91f0ed6"
},
"settings": {
"report-timezone": "Asia/Taipei"
}
}
}
@Jay Try enabling "Periodically refingerprint tables" in Admin > Databases > (your-db), and do another sync of the database.
If that does not work, then please include the output of /api/field/:id
where :id
can be found by going to Admin > Data Model > (db) > (table) > (field) and looking in the URL, which ends with .../:id/general
I think the database sync is ok, when I change field name, use menu sync db schema does work.
the URL is
https://192.168.10.71/admin/datamodel/database/65/table/184/829/general
https://192.168.10.71/admin/datamodel/database/65/table/184/830/general
when use pin map, metabase can Identify longitude and latitude, maybe there is no issue on longitude and latitude fields.
@Jay You are misunderstanding. Binning is done via fingerprinting, so Metabase has to understand the contents of the data to show the correct binning information.
- Enabled "Periodically refingerprint tables" and click "Save" in Admin > Databases > (your-db)
- The click "Sync database schemas now" in Admin > Databases > (your-db)
- Look in the log and wait for sync to finish - Admin > Troubleshooting > Logs
- Refresh your browser and try to bin the fields
Go to these addresses and post the content here:
https://192.168.10.71/api/field/829
and https://192.168.10.71/api/field/830
Pin maps are not using binning, so that's why it's working.
I don't know what happen, it works right now!! anyway thanks!!
But I have a suggestion, because Taiwan is a small country, the 0.1 degree is still to large for us.
@Jay It works because it has generated a new fingerprint.
You're seeing this issue - see my comment for a possible workaround:
https://github.com/metabase/metabase/issues/12257 - upvote by clicking on the first post
OK, Git it, thanks!!
Hello, i have the same error i already made your suggestion but doesn't work. Might you help me @flamber
@ArevaloJulie Post "Diagnostic Info" from Admin > Troubleshooting, and the environment variable you're using to start Metabase with.
{
"browser-info": {
"language": "es-419",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14+9-Ubuntu-0ubuntu2.20.04",
"java.vendor": "Ubuntu",
"java.vendor.url": "https://ubuntu.com/",
"java.version": "11.0.14",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14+9-Ubuntu-0ubuntu2.20.04",
"os.name": "Linux",
"os.version": "5.11.0-1028-aws",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"h2",
"mysql"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.13"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"date": "2022-02-17",
"tag": "v0.42.1",
"branch": "release-x.42.x",
"hash": "629f4de"
},
"settings": {
"report-timezone": null
}
}
}
@flamber
@flamber
You mean this?
{"description":null,"database_type":"VARCHAR","semantic_type":"type/Latitude","table_id":47,"coercion_strategy":null,"table":{"description":null,"entity_type":"entity/GenericTable","schema":null,"db":{"description":null,"features":["basic-aggregations","standard-deviation-aggregations","expression-aggregations","foreign-keys","right-join","left-join","native-parameters","nested-queries","expressions","set-timezone","binning","inner-join","advanced-math-expressions"],"cache_field_values_schedule":"0 0 14 * * ? *","timezone":"America/Bogota","auto_run_queries":true,"metadata_sync_schedule":"0 56 * * * ? *","name":"Oficios","settings":null,"caveats":null,"creator_id":null,"is_full_sync":true,"updated_at":"2022-06-14T16:34:27.420953Z","cache_ttl":null,"details":{"additional-options":null,"ssl":false,"password":"MetabasePass","let-user-control-scheduling":false,"port":3306,"advanced-options":true,"dbname":"oficios","host":"xxxxx,"tunnel-enabled":false,"tunnel-port":22,"user":"root"},"is_sample":false,"id":2,"is_on_demand":false,"options":null,"engine":"mysql","initial_sync_status":"complete","refingerprint":true,"created_at":"2020-02-07T23:30:49.031737Z","points_of_interest":null},"show_in_getting_started":false,"name":"task_places","caveats":null,"updated_at":"2022-06-13T17:15:01.487979Z","active":true,"id":47,"db_id":2,"visibility_type":null,"field_order":"database","initial_sync_status":"complete","display_name":"Task Places","created_at":"2020-02-07T23:30:50.304573Z","points_of_interest":null},"name":"latitud","fingerprint_version":5,"has_field_values":"none","settings":null,"caveats":null,"fk_target_field_id":null,"dimensions":[],"updated_at":"2022-06-13T19:06:07.732581Z","custom_position":0,"effective_type":"type/Text","active":true,"parent_id":null,"id":825,"last_analyzed":"2022-06-13T17:57:49.957313Z","position":0,"visibility_type":"normal","preview_display":true,"display_name":"Latitude","database_position":4,"name_field":null,"fingerprint":{"global":{"distinct-count":2325,"nil%":0.262},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":7.5926}}},"created_at":"2020-02-07T23:31:08.415924Z","base_type":"type/Text","points_of_interest":null}
@ArevaloJulie Go and read my comment, which tells you how to change the environment variable, when you start Metabase: https://github.com/metabase/metabase/issues/12257
@flamber I can't find it.
Find this https://www.metabase.com/docs/latest/operations-guide/environment-variables.html#mb_breakout_bin_width but I don't know how to apply it
@ArevaloJulie Since you running Metabase with an Postgres application database, then you are already using environment variables to start Metabase with. But I have no idea if you are manually starting a JAR or running as a service.
And if you read the last comment on the issue, then it explains how to do it:
https://github.com/metabase/metabase/issues/12257#issuecomment-1111442033
I would recommend that you get help from whoever setup Metabase for you.