About xinghx

xinghx · ‎08-08-2022

I didn't notice that the property "external" is case sensitive,the step 2 should be ALTER TABLE alter_test SET TBLPROPERTIES('EXTERNAL'='false'); ,then the location would be changed in CDP7.1.1. And In CDP 7.1.7, It does not work even if I set property "TRANSLATED_TO_EXTERNAL" to true after creating table ,could you try the steps and give an attachment? thanks.

xinghx · ‎08-03-2022

It's unreasonable for me because the table is created without a LOCATION clause and is under its database directory indeed.Besides,the release note topic is after upgrade to cdp,but it's normal in hive version 3.1.3000.7.1.1.0-565 which is also cdp.

xinghx · ‎08-02-2022

当前Hive版本：3.1.3000.7.1.7.0-551 创建hive外部表： CREATE TABLE IF NOT EXISTS `alter_test` (a string,b string) STORED AS ORC TBLPROPERTIES("transactional"="false"); 转hive内部表：ALTER TABLE alter_test SET TBLPROPERTIES('external'='false'); 重命名：ALTER TABLE alter_test RENAME TO alter_test_bak; 注：external.table.purge 这个配置是一直为true的此时，表alter_test_bak的location目录名称依然是alter_test。同样的操作步骤，我在Hive版本 3.1.3000.7.1.1.0-565是可以同步更改location目录名的，请问这是怎么回事呢

Online	Offline
Last Visited	‎07-17-2024 10:05 PM

Member Since	‎07-25-2021 06:48 AM
Last Visited	‎07-17-2024 10:05 PM
Posts	3

Cloudera Community

Re: hive 执行rename后，表的location没有相应发生改变

Re: hive 执行rename后，表的location没有相应发生改变

hive 执行rename后，表的location没有相应发生改变