GeoLocation
Provides the display name for a given geo Id, or a set of geo Ids.
GeoLocation requires an Id in SELECT statements. For example:
SELECT * FROM geolocation where id = 'urn:li:geo:123456'To specify multiple geolocation Ids use the IN operator:
SELECT * FROM geolocation WHERE id IN (<List of geolocation ids>)
Columns
Name | Type | Description |
Id [KEY] | String | Unique identifier for the entity. Can be a single Id or a comma-separated list of Ids. |
Country | String | An uppercase two-letter country code as defined by ISO-3166. |
Language | String | A lowercase two-letter language code as defined by ISO-639. |
Value | String | The value of the display text. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
LocaleLanguage | String | The locale language the country data is requested in. A lowercase two-letter language code as defined by ISO-639.
デフォルト値はenです。 |
LocaleCountry | String | The locale country the country data is requested in. An uppercase two-letter country code as defined by ISO-3166.
デフォルト値はUSです。 |