Hi Sylvester,
Probably the deprecated configurations are not handled here. Could you please
try metastore.disallow.incompatible.col.type.changes?
Thanks,
Peter
> On Jul 11, 2018, at 15:20, Sylvester Steele <sylvesterstee...@gmail.com>
> wrote:
>
> Hi Peter,
>
> I upgraded the metastore jar to 3.0.0 and when I do:
>
> ThriftHiveMetastore.Client client = new ThriftHiveMetastore.Client(protocol);
> client.setMetaConf("hive.metastore.disallow.incompatible.col.type.changes",
> "false");
>
> I get:
>
> MetaException(message:Invalid configuration key
> hive.metastore.disallow.incompatible.col.type.changes)
>
> Am I not setting the property correctly, or will I have to upgrade the hive
> server to version 2.4/3.0 as well?
>
> Thanks!
>
> On Wed, Jul 11, 2018 at 4:56 AM, Peter Vary <pv...@cloudera.com
> <mailto:pv...@cloudera.com>> wrote:
> Hi Sylvester,
>
> You can set this specific configuration value per session since HIVE-17832 -
> Fixed in: Hive 3.0.0, Hive 2.4.0
>
> So you can do this change this value through thrift if your metastore version
> is higher or equal than 2.4.0, or 3.0.0, but not with 1.2.1
>
> If you want to use 1.2.1 version you can change the configuration in the
> hive-site.xml which is used by the metastore service.
>
> Hope this helps,
> Peter
>
>> On Jul 10, 2018, at 22:09, Sylvester Steele <sylvesterstee...@gmail.com
>> <mailto:sylvesterstee...@gmail.com>> wrote:
>>
>> Hello,
>>
>> I am using hive-metastore jar version 1.2.1 and Hive version 2.3.2. I'd like
>> to make incompatible schema changes to my Hive tables.
>>
>> The change I'm trying to make is to drop a column, which I am doing like so:
>> table.getSd().setCols(remaining_cols). I'm dropping an int column. The
>> column following it is a struct column, so my understanding is that it
>> assumes I'm trying to convert an int column to a struct column.
>>
>> The error I get is:
>>
>> InvalidOperationException(message:The following columns have types
>> incompatible with the existing columns in their respective positions...
>>
>> Doing
>>
>> ThriftHiveMetastore.Client client = new ThriftHiveMetastore.Client(protocol);
>> client.get_config_value("hive.metastore.disallow.incompatible.col.type.changes",
>> "default_value");
>>
>> gives me a true, which explains the failure earlier. How do I override this
>> value to false? Also, AFAICT the default value is supposed to be false, so
>> I'm not sure why this is returning true. I checked the hive-site.xml file
>> and it doesn't have this set.
>>
>> Thanks for your help!
>>
>
>
