[
https://issues.apache.org/jira/browse/HIVE-2103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13018244#comment-13018244
]
Bennie Schut commented on HIVE-2103:
------------------------------------
Does queryForLong work for you? It's what I use. This should of course be fixed.
> this.getJdbcTemplate().queryForInt("select count(*) from user_info"); search
> ----------------------------------------------------------------------------
>
> Key: HIVE-2103
> URL: https://issues.apache.org/jira/browse/HIVE-2103
> Project: Hive
> Issue Type: Test
> Components: JDBC
> Affects Versions: 0.7.0
> Environment: Linux, jdk1.6.0_20, hive-0.7.0
> Reporter: Jerry Gates
> Priority: Minor
> Labels: hive
>
> use the following: this.getJdbcTemplate().queryForInt("select count(*) from
> user_info");
> the hive.log contents like that:
> 2011-04-11 15:38:44,270 WARN mapred.JobClient
> (JobClient.java:configureCommandLineOptions(539)) - Use GenericOptionsParser
> for parsing the arguments. Applications should implement Tool for the same.
> 2011-04-11 15:39:03,455 ERROR ql.Driver (SessionState.java:printError(343)) -
> FAILED: Parse Error: line 0:-1 mismatched input '<EOF>' expecting FROM in
> from clause
> org.apache.hadoop.hive.ql.parse.ParseException: line 0:-1 mismatched input
> '<EOF>' expecting FROM in from clause
> at
> org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:406)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:327)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:736)
> at
> org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:116)
> at
> org.apache.hadoop.hive.service.ThriftHive$Processor$execute.process(ThriftHive.java:699)
> at
> org.apache.hadoop.hive.service.ThriftHive$Processor.process(ThriftHive.java:677)
> at
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:253)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:619)
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira