Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Kettle transformation from Text Input to HBase output - Mapping issue

  1. #1

    Default Kettle transformation from Text Input to HBase output - Mapping issue

    I am trying to evaluate the Kettle integration with HBase and to start with, i tried the example at http://wiki.pentaho.com/display/BAD/...ata+into+HBase with my changes in the load_hbase.ktr.

    I use ubuntu 12.04 LTS, Kettle 4.3.0, HBase 0.96.0.

    As i have issues in opening spoon on my ubuntu box, i create the job and transformations using spoon from windows.
    But for the sake of example, i dont even do that as i use the already provided file.

    I use pan.sh to run the transformation and i am getting the following exception
    Problem getting mapping inforation: Mapping "weblogs,pageviews" does not exist!

    From the other posts on the forum, i understand that the mapping needs to be created in Hbase manually.

    My understanding is that when spoon is used to create the transformation, it automatically creates the mapping on HBase based on the values provided on the UI.
    Can you please let me know how to create pentaho mapping in HBase without Spoon or any other UI (UI does not work on my Ubuntu box)?




  2. #2
    dmoran Guest

    Default

    I don't know how to do the mapping by hand but I think I have an answer for running spoon on Ubuntu 12.

    Look at this wiki article:
    http://wiki.pentaho.com/display/COM/...n+on+Ubuntu+12

    and related JIRA case:
    http://jira.pentaho.com/browse/PDI-8430

    Doug

  3. #3
    Join Date
    Sep 2012
    Posts
    71

    Default

    Can you verify with the HBase shell that the table and mapping exist? In the HBase shell you can use the describe command as follows (and you should get something similar to the output below):

    hbase(main):012:0> describe "weblogs"
    DESCRIPTION ENABLED
    {NAME => 'weblogs', FAMILIES => [{NAME => 'pageviews', BLOOMFILTER => 'NONE', REPLI true
    CATION_SCOPE => '0', COMPRESSION => 'NONE', VERSIONS => '3', TTL => '2147483647', B
    LOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'}]}

  4. #4
    Join Date
    May 2013
    Posts
    27

    Default

    Is it possible to do mapping by hand however?

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.