[HIVE-4135] When using PostgreSQL as stats database ,there's a type cast bug

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.9.0, 0.10.0
• Component/s: Statistics
• Assignee: Unassigned
• Reporter: caofangkun
• Created: 07/Mar/13 08:21
• Updated: 07/Mar/13 08:23

Description

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}