László Végh created HIVE-26493:
----------------------------------
Summary: Hive throws error when querying a view that was created
successfully
Key: HIVE-26493
URL: https://issues.apache.org/jira/browse/HIVE-26493
Project: Hive
Issue Type: Bug
Reporter: László Végh
Steps to reproduce:
# Create table tbl_x
{code:java}
create table tbl_x (a int, b string); {code}
# Insert data in the table
{code:java}
insert into tbl_x values (1, 'Prince'); insert into tbl_x values (2, 'John');
{code}
# view data in table :
{code:java}
select * from tbl_x {code}
{noformat}
+----------+----------+
|tbl_x.a |tbl_x.b |
+----------+----------+
|1 |Prince |
|2 | John |{noformat}
# Create view:
{code:java}
create view vw_x (b) as (select a from tbl_x);{code}
# Triy to read data from view but:
{noformat}
Error while compiling statement: FAILED: SemanticException line 1:67 cannot
recognize input near ')' 'vw_x' '<EOF>' in subquery source in definition of V
IEW vw_x [ SELECT `a` AS `b` FROM ((select `tbl_x`.`a` from `default`.`tbl_x`))
`vw_x` ] used as vw_x at Line 1:14 (state=42000,code=40000) {noformat}
# Drop the view
{code:java}
drop view vw_x; {code}
# Created the view again with the below definition:
{code:java}
create view vw_x (b) as select a from tbl_x; {code}
# Tried to read the data from view:
select * from vw_x;
{noformat}
+---------+
| vw_x.b |
+---------+
| 1 |
| 2 |
+---------+ {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
