[
https://issues.apache.org/jira/browse/HIVE-7351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14059655#comment-14059655
]
Navis commented on HIVE-7351:
-----------------------------
It's the problem of JDBC implementaion. By spec, SQLException should not be
thrown in this case. We can catch SQLFeatureNotSupportedException and ignored
it, which is introduced in JDK6, but PSQLException is not a
SQLFeatureNotSupportedException, so it will not fix this problem.
> ANALYZE TABLE statement fails on postgres metastore
> ---------------------------------------------------
>
> Key: HIVE-7351
> URL: https://issues.apache.org/jira/browse/HIVE-7351
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.13.0, 0.13.1
> Environment: postgresSQL
> Reporter: Damien Carol
> Priority: Minor
> Labels: metastore, postgres
>
> Metastore code use method {{PreparedStatement.setQueryTimeout(int)}} of JDBC
> Driver :
> Current JDBC driver doesn't implements this method.
> {noformat}
> 2014-07-07 17:52:38,239 ERROR
> org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher: Error during JDBC
> connection to
> jdbc:postgresql://nc-h04:5432/metastore?user=hiveuser&password=mvsmt4521.
> org.postgresql.util.PSQLException: Method
> org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is not yet
> implemented.
> at org.postgresql.Driver.notImplemented(Driver.java:753)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.setQueryTimeout(AbstractJdbc2Statement.java:666)
> at
> org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher$1.run(JDBCStatsPublisher.java:80)
> at
> org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher$1.run(JDBCStatsPublisher.java:77)
> at
> org.apache.hadoop.hive.ql.exec.Utilities.executeWithRetry(Utilities.java:2637)
> at
> org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher.connect(JDBCStatsPublisher.java:96)
> at
> org.apache.hadoop.hive.ql.exec.TableScanOperator.publishStats(TableScanOperator.java:280)
> at
> org.apache.hadoop.hive.ql.exec.TableScanOperator.closeOp(TableScanOperator.java:226)
> at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:583)
> at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:595)
> at
> org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:227)
> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:57)
> at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:430)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:366)
> at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:415)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1190)
> at org.apache.hadoop.mapred.Child.main(Child.java:249)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
