hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Raghotham Murthy (JIRA)" <>
Subject [jira] Updated: (HIVE-567) jdbc: integrate hive with pentaho report designer
Date Fri, 19 Jun 2009 23:14:07 GMT


Raghotham Murthy updated HIVE-567:

    Attachment: hive-567.1.patch

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:
2. Overwrite with the one provided in this jira.
3. Apply patch, build and start the hive server by running: build/dist/bin/hive --service
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
  $ javac
  $ cp b.txt /tmp/b.txt
  $ sh
5. Run the report designer (note step 2)
  $ 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:
>             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.

View raw message