在Pentaho hadoop上创建数据源配置单元 [英] Create Datasource Hive on Pentaho hadoop

查看：110
本文介绍了在Pentaho hadoop上创建数据源配置单元的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我试着用pentaho hadoop来让Hive Datasource的报表设计师。
我用hadoop连接了

$ p $ 连接url：jdbc：hive：// localhost：10000和
驱动程序类名称：org.apache.hadoop.hive.jdbc.HiveDriver

然后我创建数据源我指的是Hive数据库访问Table里面的内容。

然后当我设计报表并拖动表的字段到设计器工作区时出现错误消息


出现意外错误：生成的SQL查询没有成功执行。

在pentaho完整错误日志中是这样的： 

  2011-08-11 10:24 ：49,957错误[com.pentaho.iadhoc.service.AdhocReportContentGenerator]生成的SQL查询未成功执行。 
 org.pentaho.reporting.engine.classic.core.ReportDataFactoryException：生成的SQL查询未成功执行。 
 at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.SimplePmdDataFactory.buildTableModel（SimplePmdDataFactory.java:412）
 at org.pentaho.reporting.engine.classic.extensions.datasources。 pmd.SimplePmdDataFactory.queryData（SimplePmdDataFactory.java:491）
 at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData（PmdDataFactory.java:99）
 at org。 pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData（CompoundDataFactory.java:90）
在org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal（CachingDataFactory.java:256）$在org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData（CachingDataFactory.java:213）b 
 $ b。在org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData（CompoundDataFactory .java：99）
在org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow（ReportDataRow.java:97）
在org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery（DefaultFlowController.java:188）
在com.pentaho.iadhoc.service.ca（AdhocWizardProcessorUtil.java:79）
 at com.pentaho.iadhoc.service.ga（InteractiveAdhocReportUtils.java:1265）
 at com.pentaho.iadhoc.service.AdhocReportContentGenerator.createContent（AdhocReportContentGenerator.java:103）
 at org.pentaho .platform.engine.services.solution.SimpleContentGenerator.createContent（SimpleContentGenerator.java:66）
 at sun.reflect.GeneratedMethodAccessor199.invoke（Unknown Source）
 at sun.reflect.DelegatingMethodAccessorImpl.invoke（Unknown Source ）
 at java.lang.reflect.Method.invoke（Unknown Source）
 at com.pentaho.platform.web.http.context.a.invoke（SourceFile：220）
 at $ Proxy29.createContent（来源不明）
在org.pentaho.platform.web.servlet.GenericServlet.doGet（GenericServlet.java:261）
在org.pentaho.platform.web.se rvlet.GenericServlet.doPost（GenericServlet.java:80）
 at javax.servlet.http.HttpServlet.service（HttpServlet.java:637）
 at javax.servlet.http.HttpServlet.service（HttpServlet。 
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:290）
 at org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:206）在org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter（PentahoWebContextFilter.java:96）
 
在org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:235）在org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:206）
 
在org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter（PentahoRequestContextFilter.java:84） 
在org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:235）
在org.apache.catal ina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:206）维持在org.springframework.security org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:378）
 
。 intercept.web.FilterSecurityInterceptor.invoke（FilterSecurityInterceptor.java:109）
处org.springframework.security org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter（FilterSecurityInterceptor.java:83）
。 util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
处org.springframework.security.ui org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp（ExceptionTranslationFilter.java:101）
。 SpringSecurityFilter.doFilter（SpringSecurityFilter.java:53）维持在org.pentaho.platform.web.http org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
 
。 security.SecurityStartupFilter.doFilter（SecurityStartupF在org.springframework.security.util.FilterChainProxy处
 $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
 at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp（ AnonymousProcessingFilter.java:105）
处org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter org.springframework.security.ui.SpringSecurityFilter.doFilter（SpringSecurityFilter.java:53）
（的FilterChainProxy。的java：390）$在org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter（RequestParameterAuthenticationFilter.java:169 b $ b）
。在org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（ FilterChainProxy.java:390）
在org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp（BasicProcessingFilter.java:174）
在org.springframework.security.ui.SpringSecurityFilter.doFilter（SpringSecurityFilter。 java：53）
在org.sprin gframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
处org.springframework org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp（AbstractProcessingFilter.java:278）
。 security.ui.SpringSecurityFilter.doFilter（SpringSecurityFilter.java:53）维持在org.springframework.security org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
 
。 ui.logout.LogoutFilter.doFilterHttp（LogoutFilter.java:89）
位于org.springframework.security.ui.SpringSecurityFilter.doFilter（SpringSecurityFilter.java:53）
位于org.springframework.security.util。在org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter的FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
（HttpSessionReuseDetectionFilter.java:134）
。在org.springframework.security。 util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.j ava：390）
 at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp（HttpSessionContextIntegrationFilter.java:235）
 at org.springframework.security.ui.SpringSecurityFilter.doFilter（SpringSecurityFilter.java:53） 
 at org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
 at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp（SecurityContextHolderAwareRequestFilter.java:91）
。在org.springframework.security.ui.SpringSecurityFilter.doFilter（SpringSecurityFilter.java:53）
在org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
 at org.springframework.security.util.FilterChainProxy.doFilter（FilterChainProxy.java:175）
 at org.springframework.security.util.FilterToBeanProxy.doFilter（FilterToBeanProxy.java:99）
 at org.apache .catalina.core.ApplicationFilte rChain.internalDoFilter（ApplicationFilterChain.java:235）
在org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:206）
在com.pentaho.ui.servlet.SystemStatusFilter.doFilter（的SourceFile：43）
。在org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:235）
。在org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:206）在org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter 
（SetCharacterEncodingFilter.java:113）
在org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:235） 
 at org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:206）
 at org.apache.catalina.core.StandardWrapperValve.invoke（StandardWrapperValve.java:233）
在org.apache.catalina.core.StandardContextValve.invoke（StandardContextValve.java:191）
在org.apache.c atalina.authenticator.AuthenticatorBase.invoke（AuthenticatorBase.java:470）
 at org.apache.catalina.core.StandardHostValve.invoke（StandardHostValve.java:127）
 at org.apache.catalina.valves。 ErrorReportValve.invoke（ErrorReportValve.java:102）
 at org.apache.catalina.core.StandardEngineValve.invoke（StandardEngineValve.java:109）
 at org.apache.catalina.connector.CoyoteAdapter.service（ 
 at org.apache.coyote.http11.Http11Processor.process（Http11Processor.java:857）
 at org.apache.coyote.http11.Http11Protocol $ Http11ConnectionHandler.process（Http11Protocol。 java：588）
 at org.apache.tomcat.util.net.JIoEndpoint $ Worker.run（JIoEndpoint.java:489）$ b $ java.util.run（Unknown Source）
 ParentException：
值java.sql.SQLException：错误在org.apache.hadoop.hive.jdbc.HiveQueryResultSet.next（HiveQueryResultSet.java:173）检索下一行
 
在org.pentaho .reporting.engine.classic.core.modules.mi sc.tablemodel.ResultSetTableModelFactory.generateDefaultTableModel（ResultSetTableModelFactory.java:338）
 at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery（SimpleSQLReportDataFactory.java:426）
 at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.SimplePmdDataFactory $ PmdSQLDataFactory.parametrizeAndQuery（SimplePmdDataFactory.java:81）
 at org.pentaho.reporting.engine.classic.extensions.datasources .pmd.SimplePmdDataFactory.buildTableModel（SimplePmdDataFactory.java:397）
 at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.SimplePmdDataFactory.queryData（SimplePmdDataFactory.java:491）
 at org .pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData（PmdDataFactory.java:99）
 at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData（CompoundDataFactory.java： 90）
在org.pentaho.reporting.engine.cla ssic.core.cache.CachingDataFactory.queryInternal（CachingDataFactory.java:256）
在org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData（CachingDataFactory.java:213）
。在org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData（CompoundDataFactory.java:99）
 at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow（ReportDataRow.java ：在org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery（DefaultFlowController.java:188 97）
）
。在com.pentaho.iadhoc.service.ca（AdhocWizardProcessorUtil .java：79）
 at com.pentaho.iadhoc.service.ga（InteractiveAdhocReportUtils.java:1265）
 at com.pentaho.iadhoc.service.AdhocReportContentGenerator.createContent（AdhocReportContentGenerator.java:103）
 at org.pentaho.platform.engine.services.solution.SimpleContentGenerator.createContent（SimpleContentGenerator.java:66）
 at sun.reflect.Genera tedMethodAccessor199.invoke（来源不明）在sun.reflect.DelegatingMethodAccessorImpl.invoke 
（来源不明）在java.lang.reflect.Method.invoke 
（来源不明）
。在com.pentaho。 platform.web.http.context.a.invoke（的SourceFile：220）在$ Proxy29.createContent（未知来源）
。在org.pentaho.platform.web.servlet.GenericServlet.doGet（GenericServlet类
。 Java的：261），美元，org.pentaho.platform.web.servlet.GenericServlet.doPost（GenericServlet.java:80 b $ b）
在javax.servlet.http.HttpServlet.service（HttpServlet.java:637） 
 at javax.servlet.http.HttpServlet.service（HttpServlet.java:717）
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:290）
 at org .apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:206）
 at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter（PentahoWebContextFilter.java:96）
 at org .apache.catalina.core.A pplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:235）
处org.pentaho.platform.web.http.filters org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:206）
。 PentahoRequestContextFilter.doFilter（PentahoRequestContextFilter.java:84）
在org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:235）
在org.apache.catalina.core.ApplicationFilterChain.doFilter（ ApplicationFilterChain.java:206）
 at org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:378）
 at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke（ FilterSecurityInterceptor.java:109）美元，org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter（FilterSecurityInterceptor.java:83 b $ b）
在org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（ FilterChainProxy.java:390）
在org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp（ExceptionTranslationFilter.java:101）
在org.springframework.security.ui.SpringSecurityFilter.doFilter（SpringSecurityFilter.java:53）
在org.springframework .security.util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
 at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter（SecurityStartupFilter.java:103）
 at org .springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
在org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp（AnonymousProcessingFilter.java:105）
。在组织.springframework.security.ui.SpringSecurityFilter.doFilter（SpringSecurityFilter.java:53）
在org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
在org.pentaho .platform.web.http.security.RequestParameterAuthe nticationFilter.doFilter（RequestParameterAuthenticationFilter.java:169）维持在org.springframework.security.ui.basicauth org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
 
。 BasicProcessingFilter.doFilterHttp（BasicProcessingFilter.java:174）
处org.springframework.security.util.FilterChainProxy $ VirtualFilterChain org.springframework.security.ui.SpringSecurityFilter.doFilter（SpringSecurityFilter.java:53）
。的doFilter（FilterChainProxy.java:390）
在org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp（AbstractProcessingFilter.java:278）
在org.springframework.security.ui.SpringSecurityFilter.doFilter（SpringSecurityFilter。 Java的：在org.springframework.security.ui.logout.LogoutFilter.doFilterHttp（LogoutFilter在org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter 53）
（FilterChainProxy.java:390）
。 java：89）
在org.springframewo rk.security.ui.SpringSecurityFilter.doFilter（SpringSecurityFilter.java:53）
 at org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
 at org.pentaho。 platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter（HttpSessionReuseDetectionFilter.java:134）维持在组织org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
 
。 springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp（HttpSessionContextIntegrationFilter.java:235）
位于org.springframework.security.ui.SpringSecurityFilter.doFilter（SpringSecurityFilter.java:53）
位于org.springframework.security。 util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
在org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp（SecurityContextHolderAwareRequestFilter.java:91）
在org.springframework.securi ty.ui.SpringSecurityFilter.doFilter（SpringSecurityFilter.java:53）维持在org.springframework.security org.springframework.security.util.FilterChainProxy $ VirtualFilterChain.doFilter（FilterChainProxy.java:390）
 
。 util.FilterChainProxy.doFilter（FilterChainProxy.java:175）
位于org.springframework.security.util.FilterToBeanProxy.doFilter（FilterToBeanProxy.java:99）
位于org.apache.catalina.core.ApplicationFilterChain。 internalDoFilter（ApplicationFilterChain.java:235）
在org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:206）
在com.pentaho.ui.servlet.SystemStatusFilter.doFilter（的SourceFile： 
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:235） $ b在org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter（SetCharacterEncodingFilter.ja va：113）
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:235）
 at org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:206） 
 at org.apache.catalina.core.StandardWrapperValve.invoke（StandardWrapperValve.java:233）
 at org.apache.catalina.core.StandardContextValve.invoke（StandardContextValve.java:191）
在org.apache.catalina.authenticator.AuthenticatorBase.invoke（AuthenticatorBase.java:470）
 at org.apache.catalina.core.StandardHostValve.invoke（StandardHostValve.java:127）
 at org.apache .catalina.valves.ErrorReportValve.invoke（ErrorReportValve.java:102）
 at org.apache.catalina.core.StandardEngineValve.invoke（StandardEngineValve.java:109）
 at org.apache.catalina.connector .CoyoteAdapter.service（CoyoteAdapter.java:298）
在org.apache.coyote.http11.Http11Processor.process（Http11Processor.java:857）
在org.apache.coyote.http11 .Http11Protocol $ Http11ConnectionHandler.process（Http11Protocol.java:588）
 at org.apache.tomcat.util.net.JIoEndpoint $ Worker.run（JIoEndpoint.java:489）
 at java.lang.Thread .run（Unknown Source）

我的Hive或Pentaho配置有什么问题？



我该如何解决这个问题？

解决方案

以下是我能够使用Hive Pentaho BI Server中的表（您没有指定使用的工具）：


  1. 打开Pentaho元数据编辑器

  2. 添加新的连接到通用JDBC数据库（像配置一样）

  3. 从Hive添加一些表

  4. 创建新的业务模型并添加一些表格

  5. 创建新的业务视图并添加一些以前添加的表。

  6. 将此配置发布到BI服务器。 b $ b
  7. 创建新模型时，您会看到新的数据源 - 选择该模型后，您会看到您的表格

为了达到这个解决方案，我遵循了一些有用的链接：

http://wiki.pentaho.com/display/ServerDoc1x/07.+Importing+and+Exporting+域名



http://forums.pentaho.com/showthread.php?83490-Pentaho-with-hive-datasource-FAILED&highlight=hive



http://forums.pentaho.com/showthread.php?80080-Cannot-create-Hive-data-source-from-User-Console&highlight=hive



我使用Hadoop版本CDH3u1和Pentaho CE 3.8。


I try pentaho hadoop to make report designer with Hive Datasource. I have make connection to hadoop with 

connection url: jdbc:hive://localhost:10000  and
driver class name :org.apache.hadoop.hive.jdbc.HiveDriver

Then I create datasource which I pointed to Hive database to access Table inside.

And then when I make design the report and drag field of table to designer workspace there is and error message

An unexpected error has occurred: The generated SQL-query did not execute successfully.

in the log of pentaho full error like this:

2011-08-11 10:24:49,957 ERROR [com.pentaho.iadhoc.service.AdhocReportContentGenerator] The generated SQL-query did not execute successfully.
org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: The generated SQL-query did not execute successfully.
    at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.SimplePmdDataFactory.buildTableModel(SimplePmdDataFactory.java:412)
    at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.SimplePmdDataFactory.queryData(SimplePmdDataFactory.java:491)
    at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:99)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:90)
    at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:256)
    at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:213)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:99)
    at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97)
    at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:188)
    at com.pentaho.iadhoc.service.c.a(AdhocWizardProcessorUtil.java:79)
    at com.pentaho.iadhoc.service.g.a(InteractiveAdhocReportUtils.java:1265)
    at com.pentaho.iadhoc.service.AdhocReportContentGenerator.createContent(AdhocReportContentGenerator.java:103)
    at org.pentaho.platform.engine.services.solution.SimpleContentGenerator.createContent(SimpleContentGenerator.java:66)
    at sun.reflect.GeneratedMethodAccessor199.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220)
    at $Proxy29.createContent(Unknown Source)
    at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261)
    at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:96)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
    at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
    at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
    at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Unknown Source)
ParentException: 
java.sql.SQLException: Error retrieving next row
    at org.apache.hadoop.hive.jdbc.HiveQueryResultSet.next(HiveQueryResultSet.java:173)
    at org.pentaho.reporting.engine.classic.core.modules.misc.tablemodel.ResultSetTableModelFactory.generateDefaultTableModel(ResultSetTableModelFactory.java:338)
    at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.parametrizeAndQuery(SimpleSQLReportDataFactory.java:426)
    at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.SimplePmdDataFactory$PmdSQLDataFactory.parametrizeAndQuery(SimplePmdDataFactory.java:81)
    at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.SimplePmdDataFactory.buildTableModel(SimplePmdDataFactory.java:397)
    at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.SimplePmdDataFactory.queryData(SimplePmdDataFactory.java:491)
    at org.pentaho.reporting.engine.classic.extensions.datasources.pmd.PmdDataFactory.queryData(PmdDataFactory.java:99)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:90)
    at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:256)
    at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:213)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:99)
    at org.pentaho.reporting.engine.classic.core.states.datarow.ReportDataRow.createDataRow(ReportDataRow.java:97)
    at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:188)
    at com.pentaho.iadhoc.service.c.a(AdhocWizardProcessorUtil.java:79)
    at com.pentaho.iadhoc.service.g.a(InteractiveAdhocReportUtils.java:1265)
    at com.pentaho.iadhoc.service.AdhocReportContentGenerator.createContent(AdhocReportContentGenerator.java:103)
    at org.pentaho.platform.engine.services.solution.SimpleContentGenerator.createContent(SimpleContentGenerator.java:66)
    at sun.reflect.GeneratedMethodAccessor199.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.pentaho.platform.web.http.context.a.invoke(SourceFile:220)
    at $Proxy29.createContent(Unknown Source)
    at org.pentaho.platform.web.servlet.GenericServlet.doGet(GenericServlet.java:261)
    at org.pentaho.platform.web.servlet.GenericServlet.doPost(GenericServlet.java:80)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:96)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
    at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
    at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
    at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
    at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
    at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
    at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.pentaho.ui.servlet.SystemStatusFilter.doFilter(SourceFile:43)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Unknown Source)

What's wrong with my Hive or Pentaho configuration?

How do I solve this?

解决方案

Here's what I did to be able to use Hive tables in Pentaho BI Server (you didn't specify which tool you are using):

  1. Open Pentaho Metadata Editor
  2. Add new connection to generic JDBC database (configure it as you did)
  3. Add some tables from Hive
  4. Create new Business Model and add some tables there
  5. Create new Business View and add some previously added tables.
  6. Publish this configuration to BI server.
  7. When creating new model, you'll see new datasource - after selecting this, you'll see your tables

Some useful links I followed to reach this solution:
http://wiki.pentaho.com/display/ServerDoc1x/07.+Importing+and+Exporting+Domains

http://forums.pentaho.com/showthread.php?83490-Pentaho-with-hive-datasource-FAILED&highlight=hive

http://forums.pentaho.com/showthread.php?80080-Cannot-create-Hive-data-source-from-User-Console&highlight=hive

I'm using Hadoop version CDH3u1 and Pentaho CE 3.8.

这篇关于在Pentaho hadoop上创建数据源配置单元的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
分布式计算/Hadoop最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆