hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arun Khetarpal <>
Subject Problem with Alias
Date Fri, 21 Oct 2016 18:20:23 GMT
Hi Devs,

We are running a batch pipeline and i am trying to debug an issue. Can
someone confirm if this is an expected behaviour from Hive (1.2.1)

On the CLI..

Assume in the default database no table like X exists. A query like "*With
X as (SELECT 1) SELECT * FROM X;*" prints 1. But if another table like X
exists then it ends up picking X and completely ignores the alias. Any


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message