[jira] [Created] (HIVE-28743) Insert NULL in absence of partition into TXN_WRITE_NOTIFICATION_LOG table

[Harshal Patel (Jira)]

Harshal Patel created HIVE-28743:
------------------------------------

             Summary: Insert NULL in absence of partition into 
TXN_WRITE_NOTIFICATION_LOG table
                 Key: HIVE-28743
                 URL: https://issues.apache.org/jira/browse/HIVE-28743
             Project: Hive
          Issue Type: Improvement
          Components: repl
            Reporter: Harshal Patel
            Assignee: Harshal Patel


Currently, in the TXN_WRITE_NOTIFICATION_LOG table, whenever partition is 
absent, we are inserting '' into the table, which is causing an issue in the 
case of Oracle as a backend as it converts '' into NULL.

So, instead of that, we should insert the NULL from the start and update the 
select queries wherever required



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