Liu created HIVE-28108:
--------------------------
Summary: 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
{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)
