You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Denys Kuzmenko (Jira)" <ji...@apache.org> on 2024/03/29 17:46:00 UTC
[jira] [Commented] (HIVE-28108) After setting UpdateInputAccessTimeHook query fail Table Not Found. when use 'with xxx as ...'
[ 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)