Re: 【Hive Alter Table Add column at specified position】
Yeah, according to our DDL doc, we don't support this use case at the moment. Perhaps you can use REPLACE COLUMNS as a workaround. On Sat, Jun 27, 2020 at 5:32 PM 忝忝向仧 <153488...@qq.com> wrote: > Hi,all: > > > It seems that Hive can not alter table to add column at specified > position. > For instance,the Table A has c1,c2,c3 columns,and i want to add column c4 > after c1,therefore,the table would be like c1,c4,c2,c3 instead of > c1,c2,c3,c4. > > > Thanks. -- Best regards! Rui Li
[jira] [Created] (HIVE-23878) Aggregate after join throws off MV rewrite
Rajesh Balamohan created HIVE-23878:
---
Summary: Aggregate after join throws off MV rewrite
Key: HIVE-23878
URL: https://issues.apache.org/jira/browse/HIVE-23878
Project: Hive
Issue Type: Sub-task
Components: Materialized views
Reporter: Rajesh Balamohan
E.g Q81, Q30, Q45, Q68: In all these queries, MV rewrites are disabled for
{{customer, customer-address}} MV.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
