[jira] [Commented] (HIVE-7689) Fix wrong lower case table names in Postgres Metastore back end

["Fanhong Li (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-7689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14356825#comment-14356825 ] 

Fanhong Li commented on HIVE-7689:
----------------------------------

run in postgresql : 
CREATE TABLE "PARTITION_STATS_V2"
(
  "ts" timestamp without time zone DEFAULT now(),
  "id" character varying(4000) NOT NULL,
  "row_count" bigint,
  "raw_data_size" bigint,
  CONSTRAINT "PARTITION_STATS_V2_PKEY" PRIMARY KEY ("id")
) ;
ALTER TABLE "PARTITION_STATS_V2"
  OWNER TO hive;


> 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)