[HIVE-7435] java.sql.SQLException: For input string: "5000L"

• Type: Bug
• Status: Open
• Priority: Blocker
• Resolution: Unresolved
• Affects Version/s: 0.13.1
• Component/s: JDBC

Environment

ubuntu 12.04 , java 1.8.0_05 , hiveserver2, mysql

• Assignee: Unassigned
• Reporter: Elan Hershcovitz
• Created: 17/Jul/14 07:22
• Updated: 24/Jul/14 01:29

Description

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)