Created question in FIWARE Q/A platform on 22-03-2016 at 18:03
Please, ANSWER this question AT https://stackoverflow.com/questions/36160692/connecting-spagobi-to-cosmos
Question:
connecting spagobi to cosmos
Description:
I'm trying to connect SpagoBI to Cosmos via Hive JDBC driver.
The connection works but I need to add jar (json-serde-1.3.1-SNAPSHOT-jar-with-dependencies.jar) to be able to execute map reduce when querying.
The problem is that spago bi doesn't support multiple queries for the definition of a dataset and therefore I cannot add the jar before executing the actual select (the semicolon is interpreted as part of the path of the jar)
How can I do?
Is there a way to definitely add the jar so I don't have to add it again every time I query hive?
Is this the recommended way to access cosmos data from spagobi or is there a different one i'm not aware of?
Thanks!
Monitor
Major