Mailing-List: contact hive-dev-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hive-dev@hadoop.apache.org
Message-ID: <1953685398.1245453247357.JavaMail.jira@brutus>
Date: Fri, 19 Jun 2009 16:14:07 -0700 (PDT)
From: "Raghotham Murthy (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Subject: [jira] Updated: (HIVE-567) jdbc: integrate hive with pentaho report
 designer
In-Reply-To: <220918921.1245439567349.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/HIVE-567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Raghotham Murthy updated HIVE-567:
----------------------------------

    Attachment: hive-567.1.patch
                hive-pentaho.tgz

The patch contains implementation of a few JDBC calls.

Need to do the following to integrate with pentaho report designer.

1. Download pentaho report designer from here:
http://sourceforge.net/project/showfiles.php?group_id=140317&package_id=192362
2. Overwrite report-designer.sh with the one provided in this jira.
3. Apply patch, build and start the hive server by running: build/dist/bin/hive --service hiveserver
4. compile and run the hive jdbc client code to load some data (I havent figured out how to do this in report designer yet). I have provided the code and sample data i have used in this jira
  $ javac HiveJdbcClient.java
  $ cp b.txt /tmp/b.txt
  $ sh run_client.sh
5. Run the report designer (note step 2)
  $ sh reporter-designer.sh
6. Select 'Report Design Wizard'
7. select a template - say 'fall template' - next
8. create a new data source - JDBC (custom), Generic database
9. Provide hive jdbc parameters. Give the connection a name 'hive'.
  URL: jdbc:hive://localhost:10000/default
  Driver name: org.apache.hadoop.hive.jdbc.HiveDriver
  Username and password are empty
10. Click on 'Test'. The test should succeed
11. Edit the query: select 'Sample Query', click edit query, click on the connection 'hive'. create a new query. Write a query on the table testHiveDriverTable: eg: select * from testHiveDriverTable. Click next.
12. Layout Step: Add PageOfPages to Group Items By. Add key and value as Selected Items. Click next. And Finish.
13. Change the Report header to 'hive-pentaho-report'. Change the type of the header to 'html'
14. Run the report and generate pdf. You should get something like the report attached here.

> jdbc: integrate hive with pentaho report designer
> -------------------------------------------------
>
>                 Key: HIVE-567
>                 URL: https://issues.apache.org/jira/browse/HIVE-567
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Clients
>            Reporter: Raghotham Murthy
>            Assignee: Raghotham Murthy
>             Fix For: 0.4.0
>
>         Attachments: hive-567.1.patch, hive-pentaho.tgz
>
>
> Instead of trying to get a complete implementation of jdbc, its probably more useful to pick reporting/analytics software out there and implement the jdbc methods necessary to get them working. This jira is a first attempt at this. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.