Krisztian Kasa created HIVE-24925:
-------------------------------------
Summary: Query materialized view invalidation info can cause
ORA-01795
Key: HIVE-24925
URL: https://issues.apache.org/jira/browse/HIVE-24925
Project: Hive
Issue Type: Bug
Components: Metastore
Reporter: Krisztian Kasa
Fix For: 4.0.0
Query materialized view invalidation info assemble direct sql query to pull
update/delete completed transactions on source tables since the last rebuild of
the materialized view.
Invalid writeIds are also used to filter the result. These writeIds are passed
using an *in* operator.
Depend on the size of invalid writeId list the operands of the *in* operator or
the overall query text can exceed limitations. Example: in case of Oracle
backend db maximum number of expressions in a list is 1000.
{code}
SELECT "CTC_UPDATE_DELETE"
FROM "COMPLETED_TXN_COMPONENTS"
WHERE "CTC_UPDATE_DELETE" ='Y'
AND ( ("CTC_DATABASE"=? AND "CTC_TABLE"=? AND ("CTC_WRITEID" > 1 OR
"CTC_WRITEID" IN (<invalid writeId1>, <invalid writeId2> ... <invalid
writeIdn>)) ) OR
("CTC_DATABASE"=? AND "CTC_TABLE"=? AND ("CTC_WRITEID" > 1) )
)
AND "CTC_TXNID" <= 16
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
