Re: Re: Question about INSERT OVERWRITE TABLE with dynamic partition

2018-10-25 Thread anci_...@yahoo.com
Thanks, I think it's the proper explanation. For the query result in the second query is null, there won't be a partition name generated in dynamic partition step, so the system doesn't know which partition to overwrite. Thanks very much! Regards, 孙志禹 From: Tanvi Thacker Date: 2018-10-25

WG: issue during install of INFORMATION_SCHEMA and SYS on hadoop 2.9.1 hive 3.1.0

2018-10-25 Thread Carsten Steckel
Dear all, it took quite some time to figure out how to install the "information_schema" and "sys" schemas (thanks to https://issues.apache.org/jira/browse/HIVE-16941) into a hive 3.1.0 on hdfs/hadoop 2.9.1 and I am still unsure if it is the proper way of doing it. when I execute: hive@hive-ser