将spagobi连接到宇宙 [英] connecting spagobi to cosmos

问题描述

我正在尝试通过Hive JDBC驱动程序将SpagoBI连接到Cosmos. 连接有效，但是我需要添加jar(json-serde-1.3.1-SNAPSHOT-jar-with-dependencies.jar)以便在查询时执行map reduce.

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.

问题在于spago bi不支持对数据集的定义进行多个查询，因此我无法在执行实际选择之前添加jar(分号被解释为jar路径的一部分)

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)

我该怎么办? 有没有一种方法可以肯定地添加罐子，所以我每次查询蜂巢时都不必再次添加它? 这是从spagobi访问宇宙数据的推荐方法，还是我不知道的另一种方法?

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?

谢谢！

推荐答案

您可以尝试以下方法:在与数据源的连接中配置ADD JAR语句.看看

You can try this approach: configuring the ADD JAR statement within the connection to the datasource. Have a look at

https://tomcat.apache.org/tomcat- 6.0-doc/jndi-resources-howto.html

查看connectionInitSqls:您可以在此处放置ADD JAR语句. 当然，这意味着您必须将连接配置为JNDI资源(确实是建议的配置). 希望这会有所帮助

Look at connectionInitSqls: you can put the ADD JAR statement there. Of course this means that you have to configure the connection as a JNDI resource (that is the recommended configuration indeed). Hope this helps

这篇关于将spagobi连接到宇宙的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！