Hive - Spotfire Relation understanding... Please help
I recently switched from Oracle(Datawarehousing) to Hive.
As I am new to Hive, let me tell you problems that I am facing here.
In case of Oracle I can easily connect to Schemas from Data Source of Spotfire, but as Hive does not have Schema concept I am unable to connect to Database rather connecting to cluster(contains many databases) that might have load on Data source as my cluster contains Staging and DM data.
So is there any way I can connect to database of Hive or is there any good architecture that you can help me with for segregated and well structured data.
Please let me know. Ready to have discussions.