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