hadoop-hive-dev mailing list archives

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

     [ 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.


Mime
View raw message