hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-7351) ANALYZE TABLE statement fails on postgres metastore
Date Sat, 12 Jul 2014 05:21:04 GMT

    [ 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)

Mime
View raw message