caofangkun created HIVE-4135:
--------------------------------
Summary: When using PostgreSQL as stats database ,there's a type
cast bug
Key: HIVE-4135
URL: https://issues.apache.org/jira/browse/HIVE-4135
Project: Hive
Issue Type: Bug
Components: Statistics
Affects Versions: 0.10.0, 0.9.0
Reporter: caofangkun
Priority: Minor
When using PostgreSQL as stats database ,there's a type cast bug.
tasktrack log :
2013-03-01 16:03:08,973 INFO org.apache.hadoop.hive.ql.exec.TableScanOperator:
0 forwarded 17598 rows
2013-03-01 16:03:09,040 INFO
org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher: Stats publishing for
key dim_pub_date/000000
2013-03-01 16:03:09,045 ERROR
org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher: Error during
publishing statistics.
org.postgresql.util.PSQLException: ERROR: column "row_count" is of type bigint
but expression is of type character varying
Hint: You will need to rewrite or cast the expression.
Position: 126
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:332)
at
org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher$2.run(JDBCStatsPublisher.java:136)
at
org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher$2.run(JDBCStatsPublisher.java:133)
at
org.apache.hadoop.hive.ql.exec.Utilities.executeWithRetry(Utilities.java:2093)
at
org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher.publishStat(JDBCStatsPublisher.java:149)
at
org.apache.hadoop.hive.ql.exec.TableScanOperator.publishStats(TableScanOperator.java:260)
at
org.apache.hadoop.hive.ql.exec.TableScanOperator.closeOp(TableScanOperator.java:198)
at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:557)
at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:566)
at org.apache.hadoop.hive.ql.exec.ExecMapper.close(ExecMapper.java:193)
at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:57)
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:373)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)
at org.apache.hadoop.mapred.Child.main(Child.java:167)
2013-03-01 16:03:09,046 INFO org.apache.hadoop.hive.ql.exec.TableScanOperator:
publishing : dim_pub_date/000000 : {numRows=17598, rawDataSize=2626518}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
