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

Weizisheng commented on IMPALA-11939:
-------------------------------------

[~stigahuang]  I'm facing anothing issue with eventProcesser...

Add a already exists parttion from Hive using 'alter table xxx add if not 
exists partition (ds="***")', Impala will received 2 events, the first one 
contains no partition and the 2nd one contains the existing partition but wiht 
null parameters which will cause NPE, then eventProcessStatus turns to ERROR...
{code:java}
I0526 17:14:57.637362  2146 MetastoreEventsProcessor.java:482] Received 2 
events. Start event id : 12
I0526 17:14:57.652266  2146 MetastoreEvents.java:233] Total number of events 
received: 2 Total number of events filtered out: 0
I0526 17:14:57.652372  2146 MetastoreEvents.java:366] EventId: 13 EventType: 
ADD_PARTITION Partition list is empty. Ignoring this event.
E0526 17:14:57.654448  2146 MetastoreEventsProcessor.java:527] Unexpected 
exception received while processing event
Java exception follows:
java.lang.NullPointerException
    at java.util.HashMap.putMapEntries(HashMap.java:501)
    at java.util.HashMap.putAll(HashMap.java:785)
    at 
org.apache.impala.catalog.events.MetastoreEvents$AddPartitionEvent.getSelfEventContext(MetastoreEvents.java:1320)
    at 
org.apache.impala.catalog.events.MetastoreEvents$MetastoreEvent.isSelfEvent(MetastoreEvents.java:425)
    at 
org.apache.impala.catalog.events.MetastoreEvents$AddPartitionEvent.process(MetastoreEvents.java:1333)
    at 
org.apache.impala.catalog.events.MetastoreEvents$MetastoreEvent.processIfEnabled(MetastoreEvents.java:311)
    at 
org.apache.impala.catalog.events.MetastoreEventsProcessor.processEvents(MetastoreEventsProcessor.java:615)
    at 
org.apache.impala.catalog.events.MetastoreEventsProcessor.processEvents(MetastoreEventsProcessor.java:513)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
    at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
    at 
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
    at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
E0526 17:14:57.654541  2146 MetastoreEventsProcessor.java:637] Notification 
event is null
W0526 17:14:58.654865  2146 MetastoreEventsProcessor.java:506] Event processing 
is skipped since status is ERROR. Last synced event id is 13 {code}
Do youo have any clue about this?

Or should raise a new issue following this?

Thanks...

> Catalogd can't process hms event once creating table contains extra whitespace
> ------------------------------------------------------------------------------
>
>                 Key: IMPALA-11939
>                 URL: https://issues.apache.org/jira/browse/IMPALA-11939
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Catalog
>    Affects Versions: Impala 3.4.0
>            Reporter: Weizisheng
>            Assignee: Sai Hemanth Gantasala
>            Priority: Major
>
> Enable Automatic Invalidation/Refresh of Metadata by configuring 
> hms_event_polling_interval_s.
> After creating the table from beeline like: create table *` 
> bi_xxxxxx`.`table_xxxxxx`* (...)    ---real database is 
> *bi_xxxxxx.table_xxxxxx*
> Catalogd can never process any hms event.
> {code:java}
> I0222 11:10:19.478662  7554 MetastoreEventsProcessor.java:482] Received 1 
> events. Start event id : 1524439
> I0222 11:10:19.478921  7554 MetastoreEvents.java:233] Total number of events 
> received: 1 Total number of events filtered out: 0
> E0222 11:10:19.479373  7554 MetastoreEventsProcessor.java:527] Unexpected 
> exception received while processing event
> Java exception follows:
> org.apache.impala.catalog.events.MetastoreNotificationException: EventId: 
> 1524440 EventType: CREATE_TABLE Unable to add table while processing for 
> table  bi_xxxxxx.table_xxxxxx because the database doesn't exist. This could 
> be due to a previous error while processing CREATE_DATABASE event for the 
> database  bi_xxxxxx
>     at 
> org.apache.impala.catalog.events.MetastoreEvents$CreateTableEvent.process(MetastoreEvents.java:691)
>     at 
> org.apache.impala.catalog.events.MetastoreEvents$MetastoreEvent.processIfEnabled(MetastoreEvents.java:311)
>     at 
> org.apache.impala.catalog.events.MetastoreEventsProcessor.processEvents(MetastoreEventsProcessor.java:615)
>     at 
> org.apache.impala.catalog.events.MetastoreEventsProcessor.processEvents(MetastoreEventsProcessor.java:513)
>     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>     at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
>     at 
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
>     at 
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
>     at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>     at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>     at java.lang.Thread.run(Thread.java:748)
> Caused by: org.apache.impala.catalog.CatalogException: Db  bi_xxxxxx does not 
> exist
>     at 
> org.apache.impala.catalog.CatalogServiceCatalog.addTableIfNotExists(CatalogServiceCatalog.java:1741)
>     at 
> org.apache.impala.catalog.events.MetastoreEvents$CreateTableEvent.process(MetastoreEvents.java:682)
>     ... 10 more
> E0222 11:10:19.479483  7554 MetastoreEventsProcessor.java:637] Notification 
> event is  null
> W0222 11:10:22.479734  7554 MetastoreEventsProcessor.java:506] Event 
> processing is skipped since status is ERROR. Last synced event id is 1524439 
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to