My Oracle Support Banner

BDD: Oracle BDD is returning unexpected geographic information. (Doc ID 2380183.1)

Last updated on OCTOBER 11, 2018

Applies to:

Oracle Big Data Discovery - Version 1.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Scenario:

* Need to get geographical information based on a data set imported from a Hive table.
* This data set has information regarding country, region, subregion, city and postal code, all from Portugal administrative divisions, but when try to create the "Geographic Hierarchy" in    Studio, BDD is retruning geo data values (including lat. and long.) outside Portugal.
* The same happens even if you use "Static Value"="Portugal" for the Country.


 Steps to reproduce the issue:
 Adding Country+Region+Subregion: Got values within PT and BR (Brazil)
 Adding Country+Region+Subregion+City(+-)PostalCode: returns even more countries.

 Example can be tested using the following attribute values:

 Country=Portugal
 Region=BRAGANÇA
 Subregion=BRAGANÇA
 Oracle BDD return geo information within Brazil!

Environment Details: BDD 1.4.0.0 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.