[
https://issues.apache.org/jira/browse/HIVE-567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12745685#action_12745685
]
Luis Ramos commented on HIVE-567:
---------------------------------
I was able to get further, I downloaded the latest Pentago
(prd-ce-3.5.0-RC1.tar.gz) and Checked out the latest Hive from svn (Revision:
806333). This is my problem now:
Following the Wiki, I get everything perfect up to step "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.
I have no idea how to create a Query when I select JDBC(Custom). I get no
option, cannot click next, I've tried it on a Mac and on Linux. If I select
just JDBC, it allows me to connect and create a query. I see the server run
that query, however my problem with this is that for step "12" Add key and
value as Selected Items. Click next. And Finish. I don't have these options. I
only see time, date, pages, etc, but no other fields. (SELECT * FROM
testhivedrivertable). I'm guessing its not getting the correct Schema.
If I try a query like "SELECT value FROM testhivedrivertable" the server seems
to stay in an infinite loop, occasionally switching between "SELECT 1" and
"SELECT value FROM testhivedrivertalbe" it says its "ok", but just stays in a
loop.
Ideas? Thank you.
Sample Output:
09/08/20 21:46:03 INFO ql.Driver: Starting command: SELECT * FROM
testhivedrivertable
OK
09/08/20 21:46:03 INFO ql.Driver: OK
09/08/20 21:46:03 INFO ql.Driver: Returning Hive schema:
Schema(fieldSchemas:[FieldSchema(name:key, type:int, comment:from
deserializer), FieldSchema(name:value, type:string, comment:from
deserializer)], properties:null)
09/08/20 21:46:03 INFO ql.Driver: Returning Thrift schema:
Schema(fieldSchemas:[FieldSchema(name:key, type:i32, comment:from
deserializer), FieldSchema(name:value, type:string, comment:from
deserializer)], properties:null)
09/08/20 21:46:03 INFO service.HiveServer: Returning schema:
Schema(fieldSchemas:[FieldSchema(name:key, type:i32, comment:from
deserializer), FieldSchema(name:value, type:string, comment:from
deserializer)], properties:null)
> 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-server-output.txt, hive-567.1.patch,
> hive-567.2.patch, hive-567.3.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.
