[
https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14170715#comment-14170715
]
Damien Carol commented on HIVE-7689:
------------------------------------
[~brocknoland] [~alangates] I discovered a new problem with lower/upper case
mixing.
{{org.apache.hadoop.hive.metastore.txn.CompactionTxnHandler}} try to access to
relation {{TAB_COL_STATS}}.
Without identifier quote, the method {{findColumnsWithStats}} throws errors :
{noformat}
2014-10-14 10:50:02,313 DEBUG [nc-h04-22]: txn.CompactionTxnHandler
(CompactionTxnHandler.java:findColumnsWithStats(554)) - Going to execute
<SELECT COLUMN_NAME FROM TAB_COL_STATS WHERE DB_NAME='casino' AND
TABLE_NAME='foo7'>
2014-10-14 10:50:02,314 ERROR [nc-h04-22]: txn.CompactionTxnHandler
(CompactionTxnHandler.java:findColumnsWithStats(566)) - Failed to find columns
to analyze stats on for foo7
org.postgresql.util.PSQLException: ERROR: relation "tab_col_stats" does not
exist
Position: 25
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2096)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1829)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
at
com.jolbox.bonecp.StatementHandle.executeQuery(StatementHandle.java:464)
at
org.apache.hadoop.hive.metastore.txn.CompactionTxnHandler.findColumnsWithStats(CompactionTxnHandler.java:555)
at org.apache.hadoop.hive.ql.txn.compactor.Worker.run(Worker.java:140)
{noformat}
> Fix wrong lower case table names in Postgres Metastore back end
> ---------------------------------------------------------------
>
> Key: HIVE-7689
> URL: https://issues.apache.org/jira/browse/HIVE-7689
> Project: Hive
> Issue Type: Improvement
> Components: Metastore
> Affects Versions: 0.14.0
> Reporter: Damien Carol
> Assignee: Damien Carol
> Priority: Blocker
> Labels: metastore, postgres
> Fix For: 0.14.0
>
> Attachments: HIVE-7689.5.patch, HIVE-7689.6.patch, HIVE-7689.7.patch,
> HIVE-7689.8.patch, HIVE-7689.9.patch, HIVE-7889.1.patch, HIVE-7889.2.patch,
> HIVE-7889.3.patch, HIVE-7889.4.patch
>
>
> Current 0.14 patch create table with lower case names.
> This patch fix wrong lower case tables names in Postgres Metastore back end.
> Mixing lower case and upper case throws bugs in {{JDBCStatsPublisher}}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
