[
https://issues.apache.org/jira/browse/HIVE-8329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14187454#comment-14187454
]
Gunther Hagleitner commented on HIVE-8329:
------------------------------------------
Definitely fails for me. I ran with:
{noformat}
mvn test -Dtest=TestCliDriver -Phadoop-2 -Dqfile=acid_vectorization.q
-Dtest.output.overwrite=true
{noformat}
in the itest folder. And got the following diffs in the golden file:
{noformat}
+++ ql/src/test/results/clientpositive/acid_vectorization.q.out (working copy)
@@ -10,6 +10,7 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
PREHOOK: Output: default@acid_vectorized
+[Error 30017]: Skipping stats aggregation by error
org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30001]: StatsPublisher
cannot be initialized. There was a error in the initialization of
StatsPublisher, and retrying might help. If you dont want the query to fail
because accurate statistics could not be collected, set
hive.stats.reliable=false
POSTHOOK: query: insert into table acid_vectorized select cint, cstring1 from
alltypesorc where cint is not null order by cint limit 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
@@ -20,6 +21,7 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@values__tmp__table__1
PREHOOK: Output: default@acid_vectorized
+[Error 30017]: Skipping stats aggregation by error
org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30001]: StatsPublisher
cannot be initialized. There was a error in the initialization of
StatsPublisher, and retrying might help. If you dont want the query to fail
because accurate statistics could not be collected, set
hive.stats.reliable=false
POSTHOOK: query: insert into table acid_vectorized values (1, 'bar')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@values__tmp__table__1
@@ -30,6 +32,7 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@acid_vectorized
PREHOOK: Output: default@acid_vectorized
+[Error 30017]: Skipping stats aggregation by error
org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30001]: StatsPublisher
cannot be initialized. There was a error in the initialization of
StatsPublisher, and retrying might help. If you dont want the query to fail
because accurate statistics could not be collected, set
hive.stats.reliable=false
POSTHOOK: query: update acid_vectorized set b = 'foo' where b = 'bar'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acid_vectorized
@@ -38,6 +41,7 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@acid_vectorized
PREHOOK: Output: default@acid_vectorized
+[Error 30017]: Skipping stats aggregation by error
org.apache.hadoop.hive.ql.metadata.HiveException: [Error 30001]: StatsPublisher
cannot be initialized. There was a error in the initialization of
StatsPublisher, and retrying might help. If you dont want the query to fail
because accurate statistics could not be collected, set
hive.stats.reliable=false
POSTHOOK: query: delete from acid_vectorized where b = 'foo'
POSTHOOK: type: QUERY
{noformat}
> Enable postgres for storing stats
> ---------------------------------
>
> Key: HIVE-8329
> URL: https://issues.apache.org/jira/browse/HIVE-8329
> Project: Hive
> Issue Type: Bug
> Components: Statistics
> Affects Versions: 0.14.0
> Reporter: Damien Carol
> Assignee: Damien Carol
> Priority: Blocker
> Fix For: 0.14.0
>
> Attachments: HIVE-8329.1.patch, HIVE-8329.1.patch, HIVE-8329.1.patch
>
>
> Simple patch to enable postgresql as JDBC publisher for statistics.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
