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)