[ https://issues.apache.org/jira/browse/HIVE-28108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17832268#comment-17832268 ]
Denys Kuzmenko commented on HIVE-28108: --------------------------------------- [~Jinxin], please raise a pull request instead of a patch in attachment. > After setting UpdateInputAccessTimeHook query fail Table Not Found. when use > 'with xxx as ...' > ---------------------------------------------------------------------------------------------- > > Key: HIVE-28108 > URL: https://issues.apache.org/jira/browse/HIVE-28108 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 4.0.0-beta-1 > Reporter: Liu > Assignee: Liu > Priority: Major > Fix For: 4.1.0 > > Attachments: HIVE-28108.01.path > > > {code:java} > SET > hive.exec.pre.hooks=org.apache.hadoop.hive.ql.hooks.UpdateInputAccessTimeHook$PreExec; > WITH tmp_data as (SELECT device_id, ip, request_id FROM dwd.impression WHERE > d = '20240305') > INSERT OVERWRITE TABLE dms.aaa PARTITION ( d = '20240305', part) > SELECT a.column_value AS column_value, a.part AS part > FROM (SELECT device_id AS column_value, 'device' as part > FROM (SELECT device_id, COUNT(DISTINCT request_id) AS req_count FROM > tmp_data GROUP BY device_id) AS a > WHERE req_count > 50 > UNION ALL > SELECT device_id AS column_value, 'device' as part > FROM (SELECT device_id, COUNT(DISTINCT ip) AS ip_count FROM tmp_data > GROUP BY device_id) AS a > WHERE ip_count > 3 > ) AS a > LEFT JOIN dms.ivt ivt ON a.column_value = ivt.column_value > WHERE ivt.column_value IS NULL; > {code} > the second select failĀ whith following exception > {code:java} > Error while processing statement: > FAILED: Hive Internal Error: > org.apache.hadoop.hive.ql.metadata.InvalidTableException(Table not found > tmp_data) {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)