dengzhhu653 commented on code in PR #3920:
URL: https://github.com/apache/hive/pull/3920#discussion_r1065464822
##########
ql/src/test/queries/clientpositive/rename_translated_external_table.q:
##########
@@ -0,0 +1,18 @@
+set
metastore.metadata.transformer.class=org.apache.hadoop.hive.metastore.MetastoreDefaultTransformer;
+set hive.fetch.task.conversion=none;
+set hive.compute.query.using.stats=false;
+
+create database if not exists tmp;
+
+use tmp;
+
+create table b(s string) stored as parquet location
'file:${system:test.tmp.dir}/tmp.db/some_location';
+
+desc formatted b;
Review Comment:
Output of the query does not show the details about the location, so I think
it better to do like this:
```sql
insert into table b values('a'),('b'),('c');
select * from b;
```
after renaming b to bb, then
```
select * from bb;
-- new table and location should be available after rename
create table b(s string) stored as parquet location
'file:${system:test.tmp.dir}/tmp.db/some_location';
select * from b; -- the result should be empty
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
