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)