hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "caofangkun (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-4135) When using PostgreSQL as stats database ,there's a type cast bug
Date Thu, 07 Mar 2013 08:24:12 GMT

     [ https://issues.apache.org/jira/browse/HIVE-4135?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

caofangkun updated HIVE-4135:
-----------------------------

    Attachment: HIVE-4135-1.patch

A quick fix
                
> 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.9.0, 0.10.0
>            Reporter: caofangkun
>            Priority: Minor
>         Attachments: HIVE-4135-1.patch
>
>
> 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

Mime
View raw message