Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: MonetDB

  1. #1
    Join Date
    Jul 2010
    Posts
    1

    Default MonetDB

    Hi,

    I'm trying to use MonetDB with Pentaho DI.

    I've upgraded the included version of the monetdb jdbc driver to 1.15 since that actually allows me to connect to the monetdb database (monetdb5).

    I can set up table input and get data, but any attempt to then use that data fails.

    If I try to view the output fields for the Table Input step I get an error like this:

    ====
    Unable to get queryfields for SQL:
    SELECT field1, field2, field3
    FROM test_table

    Couldn't get field info from [SELECT field1, field2, field3
    FROM test_table]


    No result set metadata available to retrieve row metadata!


    at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run(SearchFieldsProgressDialog.java:73)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
    Caused by: org.pentaho.di.core.exception.KettleStepException:
    Unable to get queryfields for SQL:
    SELECT field1, field2, field3
    FROM test_table

    Couldn't get field info from [SELECT field1, field2, field3
    FROM test_table]


    No result set metadata available to retrieve row metadata!



    at org.pentaho.di.trans.steps.tableinput.TableInputMeta.getFields(TableInputMeta.java:275)
    at org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:1886)
    at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1741)
    at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1663)
    at org.pentaho.di.ui.spoon.dialog.SearchFieldsProgressDialog.run(SearchFieldsProgressDialog.java:68)
    ... 1 more
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Couldn't get field info from [SELECT field1, field2, field3
    FROM test_table]


    No result set metadata available to retrieve row metadata!


    at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2315)
    at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2229)
    at org.pentaho.di.trans.steps.tableinput.TableInputMeta.getFields(TableInputMeta.java:263)
    ... 5 more
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    No result set metadata available to retrieve row metadata!

    at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2346)
    at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2308)
    ... 7 more
    ====

    Any attempt to pass information to a subsequent step fails in the same way.

    Any ideas?

  2. #2
    Join Date
    Feb 2011
    Posts
    2

    Lightbulb

    Hi,

    Have you found a solution for your problem with kettle and Monetdb ?
    I have the same issue with Monetdb Oct2010 and MonetDB Oct 2010 SP1, both with the jdbc drivers 1.17. I use pentaho data integration (Kettle) 4.1.0.

    Is there a particular version of MonetDB which works with Kettle ?

    I can connect to the database, perform sql operation with the sql editor, navigate in the database...
    But with the 'monet bulk loader' or the 'insert into table' tools, i have always this error, but nothing in merovingian.log.

    Code:
    Couldn't get field info from [SELECT * FROM my_table]
    No result set metadata available to retrieve row metadata!
    Code:
    at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.getRequiredFields(MonetDBBulkLoaderMeta.java:627)
    	at org.pentaho.di.ui.trans.steps.monetdbbulkloader.MonetDBBulkLoaderDialog.generateMappings(MonetDBBulkLoaderDialog.java:758)
    	at org.pentaho.di.ui.trans.steps.monetdbbulkloader.MonetDBBulkLoaderDialog.access$200(MonetDBBulkLoaderDialog.java:77)
    	at org.pentaho.di.ui.trans.steps.monetdbbulkloader.MonetDBBulkLoaderDialog$3.handleEvent(MonetDBBulkLoaderDialog.java:396)
    	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.trans.steps.monetdbbulkloader.MonetDBBulkLoaderDialog.open(MonetDBBulkLoaderDialog.java:549)
    	at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:126)
    	at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:7487)
    	at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:2728)
    	at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:1976)
    	at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDown(TransGraph.java:797)
    	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:1161)
    	at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6725)
    	at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:545)
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    	at java.lang.reflect.Method.invoke(Method.java:597)
    	at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 
    Couldn't get field info from [SELECT * FROM dim_activite]
    
    
    No result set metadata available to retrieve row metadata!
    
    
    	at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2333)
    	at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2247)
    	at org.pentaho.di.core.database.Database.getQueryFields(Database.java:1946)
    	at org.pentaho.di.core.database.Database.getTableFields(Database.java:1941)
    	at org.pentaho.di.trans.steps.monetdbbulkloader.MonetDBBulkLoaderMeta.getRequiredFields(MonetDBBulkLoaderMeta.java:613)
    	... 26 more
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 
    No result set metadata available to retrieve row metadata!
    
    	at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2364)
    	at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2326)
    	... 30 more
    Thanks for any advices

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.