Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Wed, 25 Oct 2017 12:34:00 +0000 (UTC)
From: "Sankar Hariappan (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.13111773.1508870963000.55321.1508934840323@Atlassian.JIRA>
In-Reply-To: <JIRA.13111773.1508870963000@Atlassian.JIRA>
References: <JIRA.13111773.1508870963000@Atlassian.JIRA> <JIRA.13111773.1508870963825@jira-lw-us.apache.org>
Subject: [jira] [Updated] (HIVE-17887) Incremental REPL LOAD with Drop
 partition event on timestamp type partition column fails.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Wed, 25 Oct 2017 12:34:10 -0000


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

Sankar Hariappan updated HIVE-17887:
------------------------------------
    Status: Open  (was: Patch Available)

> Incremental REPL LOAD with Drop partition event on timestamp type partition column fails.
> -----------------------------------------------------------------------------------------
>
>                 Key: HIVE-17887
>                 URL: https://issues.apache.org/jira/browse/HIVE-17887
>             Project: Hive
>          Issue Type: Sub-task
>          Components: HiveServer2, repl
>    Affects Versions: 3.0.0
>            Reporter: Santhosh B Gowda
>            Assignee: Sankar Hariappan
>              Labels: DR, pull-request-available, replication
>             Fix For: 3.0.0
>
>
> When try to replicate the drop partition event on a table with partition on timestamp type column fails in REPL LOAD.
> *Scenario:*
> 1. create table with partition on timestamp column.
> 2.bootstrap dump/load.
> 3. insert a record to create partition(p="2001-11-09 00:00:00.0").
> 4. drop the same partition(p="2001-11-09 00:00:00.0").
> 5. incremental dump/load
> -- REPL LOAD throws below exception
> {quote}2017-10-23 12:26:14,050 ERROR [HiveServer2-Background-Pool: Thread-36769]: metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(203)) - MetaException(message:Error parsing partition filter; lexer error: line 1:18 no viable alternative at character ':'; exception MismatchedTokenException(12!=23))
>         at org.apache.hadoop.hive.metastore.ObjectStore.getFilterParser(ObjectStore.java:2759)
>         at org.apache.hadoop.hive.metastore.ObjectStore.getPartitionsByFilterInternal(ObjectStore.java:2708)
>         at org.apache.hadoop.hive.metastore.ObjectStore.getPartitionsByFilter(ObjectStore.java:2517)
>         at sun.reflect.GeneratedMethodAccessor362.invoke(Unknown Source)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:498)
>         at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:103)
>         at com.sun.proxy.$Proxy18.getPartitionsByFilter(Unknown Source)
>         at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_partitions_by_filter(HiveMetaStore.java:4957)
>         at sun.reflect.GeneratedMethodAccessor361.invoke(Unknown Source)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:498)
>         at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147)
>         at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
>         at com.sun.proxy.$Proxy21.get_partitions_by_filter(Unknown Source)
>         at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.listPartitionsByFilter(HiveMetaStoreClient.java:1200)
>         at sun.reflect.GeneratedMethodAccessor360.invoke(Unknown Source)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:498)
>         at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:178)
>         at com.sun.proxy.$Proxy22.listPartitionsByFilter(Unknown Source)
>         at org.apache.hadoop.hive.ql.metadata.Hive.getPartitionsByFilter(Hive.java:2562)
>         at org.apache.hadoop.hive.ql.exec.DDLTask.dropPartitions(DDLTask.java:4018)
>         at org.apache.hadoop.hive.ql.exec.DDLTask.dropTableOrPartitions(DDLTask.java:3993)
>         at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:343)
>         at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:162)
>         at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:89)
>         at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1751)
>         at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1497)
>         at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1294)
>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1161)
>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1156)
>         at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:197)
>         at org.apache.hive.service.cli.operation.SQLOperation.access$300(SQLOperation.java:76)
>         at org.apache.hive.service.cli.operation.SQLOperation$2$1.run(SQLOperation.java:255)
> {quote}


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)