[jira] [Updated] (HIVE-28108) After setting UpdateInputAccessTimeHook query fail Table Not Found. when use 'with xxx as ...'

["Liu (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-28108?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Liu updated HIVE-28108:
-----------------------
    Attachment: HIVE-28108.01.path

> 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
>         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)