Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6CB19118FF for ; Tue, 15 Jul 2014 08:26:05 +0000 (UTC) Received: (qmail 24226 invoked by uid 500); 15 Jul 2014 08:26:04 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 24134 invoked by uid 500); 15 Jul 2014 08:26:04 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 24120 invoked by uid 500); 15 Jul 2014 08:26:04 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 24117 invoked by uid 99); 15 Jul 2014 08:26:04 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Jul 2014 08:26:04 +0000 Date: Tue, 15 Jul 2014 08:26:04 +0000 (UTC) From: "Damien Carol (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-7351) ANALYZE TABLE statement fails on postgres metastore MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-7351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14061830#comment-14061830 ] Damien Carol commented on HIVE-7351: ------------------------------------ I agree > 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 > Assignee: Navis > Priority: Minor > Labels: metastore, postgres > Attachments: HIVE-7351.1.patch.txt > > > 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)