Basically to connect in hive required connector and dump the data from database to hadoop etc, but in geonames how to get the data how to communicate?
in Mysql syntax:
jdbc:mysql://localhost:3306/database
What about in geoname?
pls help
you can download the flat files, load them into mysql and connect as you describe.
Possibly you can also connect to flat files, please consult the hive docs.