Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to access hive table in pentaho kettle model

  1. #1
    Join Date
    Oct 2013
    Posts
    3

    Unhappy How to access hive table in pentaho kettle model

    Hi,
    I want to create hive analyzer for this I was created hive connections using hadoop hive , test connections show successful but when I click on hive table for measure and dimensions it shows following error
    Code:
    org.pentaho.agilebi.modeler.ModelerException: org.pentaho.pms.core.exception.PentahoMetadataException: org.pentaho.di.core.exception.KettleDatabaseException: Couldn't get field info from [SELECT * FROM weblogs]
    
    
    Method not supported
    
    
        at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.generateDomain(ModelerSourceUtil.java:118)
        at org.pentaho.agilebi.modeler.util.TableModelerSource.generateDomain(TableModelerSource.java:50)
        at org.pentaho.agilebi.modeler.util.ModelerWorkspaceUtil.populateModelFromSource(ModelerWorkspaceUtil.java:26)
        at org.pentaho.agilebi.spoon.modeler.SpoonModelerController.editDataSource(SpoonModelerController.java:208)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
        at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
        at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
        at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
        at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
        at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
        at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
        at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
        at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
        at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
        at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1221)
        at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7044)
        at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8304)
        at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:580)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Caused by: org.pentaho.pms.core.exception.PentahoMetadataException: org.pentaho.di.core.exception.KettleDatabaseException: 
    Couldn't get field info from [SELECT * FROM weblogs]
    
    
    Method not supported
    
    
        at org.pentaho.metadata.automodel.AutoModeler.generateDomain(AutoModeler.java:127)
        at org.pentaho.agilebi.modeler.util.ModelerSourceUtil.generateDomain(ModelerSourceUtil.java:81)
        ... 26 more
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 
    Couldn't get field info from [SELECT * FROM weblogs]
    
    
    Method not supported
    
    
        at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2330)
        at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2242)
        at org.pentaho.di.core.database.Database.getQueryFields(Database.java:1939)
        at org.pentaho.di.core.database.Database.getTableFields(Database.java:1934)
        at org.pentaho.metadata.automodel.PhysicalTableImporter.importTableDefinition(PhysicalTableImporter.java:69)
        at org.pentaho.metadata.automodel.AutoModeler.generateDomain(AutoModeler.java:114)
        ... 27 more
    Caused by: java.sql.SQLException: Method not supported
        at org.apache.hadoop.hive.jdbc.HivePreparedStatement.getMetaData(HivePreparedStatement.java:250)
        at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2323)
        ... 32 more
    For this I used Kettle - Spoon Stable Release - 4.4.0 CE.
    Last edited by yogesh_0586; 03-06-2014 at 06:58 AM.

  2. #2
    Join Date
    Apr 2014
    Posts
    11

    Default

    I thing one possible link to the problem is:
    http://svn.apache.org/repos/asf/hive...Statement.java

    ...
    /*
    * (non-Javadoc)
    *
    * @see java.sql.PreparedStatement#getMetaData()
    */

    public ResultSetMetaData getMetaData() throws SQLException {
    // TODO Auto-generated method stub
    throw new SQLException("Method not supported");
    }
    ...

    I have at the moment the same problem - looking for solution.

    Best regards, Margusja

  3. #3
    Join Date
    Sep 2012
    Posts
    71

    Default

    That has been fixed in service packs for 4.8 (EE), as well as 5.0.1 (CE and EE). There won't be another 4.4.x CE release so if possible I recommend upgrading to 5.0.1 CE. If this isn't an option, the 4.4.x JARs should be available in our public Artifactory.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.