[
https://issues.apache.org/jira/browse/HIVE-7435?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14072679#comment-14072679
]
Navis commented on HIVE-7435:
-----------------------------
Hive does not support type literals(l, f, d, etc.) in hive-site.xml. It's right
to use 5000, instead of 5000l.
For "The query did not generate a result set!" exception, it's possible a query
not to have a result set. Prefer execute() rather than executeQuery(). If it's
not the case, could you post your query string in here?
> java.sql.SQLException: For input string: "5000L"
> ------------------------------------------------
>
> Key: HIVE-7435
> URL: https://issues.apache.org/jira/browse/HIVE-7435
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.13.1
> Environment: ubuntu 12.04 , java 1.8.0_05 , hiveserver2, mysql
> Reporter: Elan Hershcovitz
> Priority: Blocker
> Attachments: hive-site.xml
>
>
> btw - using hiveserve1 it all works fine...
> running java app and from beeline, jdk version "1.8.0_05" , hive 0.13.1
> hiveserver2, I could pass connection successfully but could not run any sql
> queries (show tables , drop and so).
> msg I' ve got :
> java.sql.SQLException: For input string: "5000L"
> at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:121)
> at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:109)
> at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:263)
> at
> org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:355)
> ** same msg for java jdbc app and beeline
> ** bin/hive works fine
> **So :
>
> I ve changed hive-core.xml hive.server2.long.polling.timeout from default
> <value>5000L</value> to 5000 and now
> ** beeline works fine now
> ** Java jdbc :
> im getting new ?? issue :
> java.sql.SQLException: The query did not generate a result set!
> at
> org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:356)
> at HiveDataFetcher.LoadTable(HiveDataFetcher.java:64)
> at HiveDataFetcher.runQueryAndGetResult(HiveDataFetcher.java:45)
> at HiveDataFetcher.getDataFromHive(HiveDataFetcher.java:19)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
