Taraka Rama Rao Lethavadla created HIVE-26700: -------------------------------------------------
Summary: alter view set owner is throwing exception
Key: HIVE-26700
URL: https://issues.apache.org/jira/browse/HIVE-26700
Project: Hive
Issue Type: Bug
Components: HiveServer2
Reporter: Taraka Rama Rao Lethavadla
Tested in 3.1, we can alter the view with alter table command itself
desc formatted test_view_owner;
{noformat}
+-------------------------------+----------------------------------------------------+-----------------------+
| col_name | data_type
| comment |
+-------------------------------+----------------------------------------------------+-----------------------+
| # col_name | data_type
| comment |
| id | int
| |
| name | string
| |
| | NULL
| NULL |
| # Detailed Table Information | NULL
| NULL |
| Database: | default
| NULL |
| OwnerType: | USER
| NULL |
| Owner: | hive
| NULL |
| CreateTime: | Tue Oct 25 20:40:47 GMT+08:00 2022
| NULL |
| LastAccessTime: | UNKNOWN
| NULL |
| Retention: | 0
| NULL |
| Table Type: | VIRTUAL_VIEW
| NULL |
| Table Parameters: | NULL
| NULL |
| | bucketing_version
| 2 |
| | transient_lastDdlTime
| 1666701647 |
| | NULL
| NULL |
| # Storage Information | NULL
| NULL |
| SerDe Library: | null
| NULL |
| InputFormat: |
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat | NULL |
| OutputFormat: |
org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat | NULL |
| Compressed: | No
| NULL |
| Num Buckets: | -1
| NULL |
| Bucket Columns: | []
| NULL |
| Sort Columns: | []
| NULL |
| | NULL
| NULL |
| # View Information | NULL
| NULL |
| Original Query: | select * from test_owner_hive
| NULL |
| Expanded Query: | select `test_owner_hive`.`id`,
`test_owner_hive`.`name` from `default`.`test_owner_hive` | NULL
|
+-------------------------------+----------------------------------------------------+-----------------------+{noformat}
alter table test_view_owner set owner user tarak;
desc formatted test_view_owner;
{noformat}
+-------------------------------+----------------------------------------------------+-----------------------+
| col_name | data_type
| comment |
+-------------------------------+----------------------------------------------------+-----------------------+
| # col_name | data_type
| comment |
| id | int
| |
| name | string
| |
| | NULL
| NULL |
| # Detailed Table Information | NULL
| NULL |
| Database: | default
| NULL |
| OwnerType: | USER
| NULL |
| Owner: | tarak
| NULL |
| CreateTime: | Tue Oct 25 20:40:47 GMT+08:00 2022
| NULL |
| LastAccessTime: | UNKNOWN
| NULL |
| Retention: | 0
| NULL |
| Table Type: | VIRTUAL_VIEW
| NULL |
| Table Parameters: | NULL
| NULL |
| | bucketing_version
| 2 |
| | last_modified_by
| hive |
| | last_modified_time
| 1666701765 |
| | transient_lastDdlTime
| 1666701765 |
| | NULL
| NULL |
| # Storage Information | NULL
| NULL |
| SerDe Library: | null
| NULL |
| InputFormat: |
org.apache.hadoop.hive.ql.io.orc.OrcInputFormat | NULL |
| OutputFormat: |
org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat | NULL |
| Compressed: | No
| NULL |
| Num Buckets: | -1
| NULL |
| Bucket Columns: | []
| NULL |
| Sort Columns: | []
| NULL |
| | NULL
| NULL |
| # View Information | NULL
| NULL |
| Original Query: | select * from test_owner_hive
| NULL |
| Expanded Query: | select `test_owner_hive`.`id`,
`test_owner_hive`.`name` from `default`.`test_owner_hive` | NULL
|
+-------------------------------+----------------------------------------------------+-----------------------+
30 rows selected (0.093 seconds){noformat}
But the same is not working in newer version
{noformat}
alter table test_view_owner set owner user tarak;{noformat}
{noformat}
Error: Error while compiling statement: FAILED: SemanticException [Error
10131]: To alter a view you need to use the ALTER VIEW command.
(state=42000,code=10131){noformat}
{noformat}
alter view test_view_owner set owner user tarak;{noformat}
{noformat}
Error: Error while compiling statement: FAILED: ParseException line 1:31
mismatched input 'owner' expecting TBLPROPERTIES near 'set' in alter view
properties statement (state=42000,code=40000){noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
