我该如何在Hive中进行子查询?我认为我可能会犯一个对我来说不太明显的错误...
我收到的错误是:
非常感谢你:)
我收到的错误是:
FAILED: Parse Error: line 4:8 cannot recognize input 'SELECT' in expression specification
以下是我的三个源表:aaa_hit -> [SESSION_KEY, HIT_KEY, URL]
aaa_event-> [SESSION_KEY,HIT_KEY,EVENT_ID]
aaa_session->[SESSION_KEY,REMOTE_ADDRESS]
我想要做的是将结果插入到这样的结果表中:
result -> [url, num_url, event_id, num_event_id, remote_address, num_remote_address]
这里需要翻译的内容是:“...其中列1是URL,列3是每个URL的前1个“事件”,列5是访问该URL的前1个REMOTE_ADDRESS。(偶数列是前一列的“计数”)。”
那么...我在这里做错了什么?
INSERT OVERWRITE TABLE result2
SELECT url,
COUNT(url) AS access_url,
(SELECT events.event_id as evt,
COUNT(events.event_id) as access_evt
FROM aaa_event events
LEFT OUTER JOIN aaa_hit hits
ON ( events.hit_key = hit_key )
ORDER BY access_evt DESC LIMIT 1),
(SELECT sessions.remote_address as remote_address,
COUNT(sessions.remote_address) as access_addr
FROM aaa_session sessions
RIGHT OUTER JOIN aaa_hit hits
ON ( sessions.session_key = session_key )
ORDER BY access_addr DESC LIMIT 1)
FROM aaa_hit
ORDER BY access_url DESC;
非常感谢你:)
FAILED: Parse Error: line 4:8 cannot recognize input 'SELECT' in expression specification
。 - batman