Details
- 
        Type:
Monitor
 - 
        Status: Closed
 - 
            Priority:
 Major
                
             - 
            Resolution: Done
 - 
            Affects Version/s: None
 - 
            Fix Version/s: 2021
 - 
            Component/s: FIWARE-TECH-HELP
 - 
            Labels:
 
- 
                        HD-Chapter:Apps
 - 
                        HD-Enabler:SpagoBI
 
Description
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!
2017-05-22 15:09|CREATED monitor | # answers= 1, accepted answer= False