Re: [BUG] Hive 3.1.2 ALTER TABLE statement

Hi Vinicius, This is an external Hive table so the table is just a placeholder for data locations. Try setting: set hive.msck.path.validation=ignore; Also worth checking this stackoverflow HIVE Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask - Stack Overflow

Re: [BUG] Hive 3.1.2 ALTER TABLE statement

Hi Mich! Nice to meet you and thanks for the answer! I don't know what you exactly mean with the size of the table and partition columns, but here are some relevant information about it: The table that we are trying to add the column to has 600,000 partitions and the total size of the partitions

Re: [BUG] Hive 3.1.2 ALTER TABLE statement

Hi, Could you please try the same statement with CASCADE clause. As a general rule, please avoid doing it in production directly unless that is the last option. Regards Dev On Mon, 19 Apr, 2021, 8:03 pm Vinícius Matheus Olivieri, < olivierivi...@gmail.com> wrote: > Hey guys! > > I am using HIVE

Re: [BUG] Hive 3.1.2 ALTER TABLE statement

Hi, Just a small point, what you are doing is DDL not a query. You are altering the table and adding a new column. First can you confirm that your table has 600,000 partitions!. If so, what is the size of the table and the partition column? The process seems to be timing out on alter. table. You