You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Mich Talebzadeh <mi...@gmail.com> on 2016/04/29 11:51:56 UTC
Hive configuration parameter hive.enforce.bucketing does not exist in
Hive 2
Is the parameter
--set hive.enforce.bucketing = true;
depreciated in Hive 2 as it causes hql code not to work?
hive> set hive.enforce.bucketing = true;
Query returned non-zero code: 1, cause: hive configuration
hive.enforce.bucketing does not exists.
Dr Mich Talebzadeh
LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
Re: Hive configuration parameter hive.enforce.bucketing does not
exist in Hive 2
Posted by Mich Talebzadeh <mi...@gmail.com>.
Ok thanks Lefty
Dr Mich Talebzadeh
LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
On 30 April 2016 at 02:23, Lefty Leverenz <le...@gmail.com> wrote:
> FYI, the removal of hive.enforce.bucketing is documented in the wiki (
> hive.enforce.bucketing
> <https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.enforce.bucketing>)
> and the JIRA issue that removed it is HIVE-12331
> <https://issues.apache.org/jira/browse/HIVE-12331>.
>
> -- Lefty
>
> On Fri, Apr 29, 2016 at 12:07 PM, Mich Talebzadeh <
> mich.talebzadeh@gmail.com> wrote:
>
>> Unfortunately that needs to be done or better the whole line removed in
>> every hql code where it is set as true .
>>
>> Thanks
>>
>> Dr Mich Talebzadeh
>>
>>
>>
>> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>
>>
>>
>> http://talebzadehmich.wordpress.com
>>
>>
>>
>> On 29 April 2016 at 19:35, Sergey Shelukhin <se...@hortonworks.com>
>> wrote:
>>
>>> You can set hive.conf.validation to false to disable this :)
>>>
>>> From: Mich Talebzadeh <mi...@gmail.com>
>>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>>> Date: Friday, April 29, 2016 at 11:16
>>> To: user <us...@hive.apache.org>
>>> Subject: Re: Hive configuration parameter hive.enforce.bucketing does
>>> not exist in Hive 2
>>>
>>> Well having it in the old code causes the query to crash as well!
>>>
>>> Dr Mich Talebzadeh
>>>
>>>
>>>
>>> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>>
>>>
>>>
>>> http://talebzadehmich.wordpress.com
>>>
>>>
>>>
>>> On 29 April 2016 at 18:33, Sergey Shelukhin <se...@hortonworks.com>
>>> wrote:
>>>
>>>> This parameter has indeed been removed; it is treated as always true
>>>> now, because setting it to false just produced incorrect tables.
>>>>
>>>> From: Mich Talebzadeh <mi...@gmail.com>
>>>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>>>> Date: Friday, April 29, 2016 at 02:51
>>>> To: user <us...@hive.apache.org>
>>>> Subject: Hive configuration parameter hive.enforce.bucketing does not
>>>> exist in Hive 2
>>>>
>>>> Is the parameter
>>>>
>>>> --set hive.enforce.bucketing = true;
>>>>
>>>> depreciated in Hive 2 as it causes hql code not to work?
>>>>
>>>> hive> set hive.enforce.bucketing = true;
>>>> Query returned non-zero code: 1, cause: hive configuration
>>>> hive.enforce.bucketing does not exists.
>>>>
>>>>
>>>> Dr Mich Talebzadeh
>>>>
>>>>
>>>>
>>>> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>>>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>>>
>>>>
>>>>
>>>> http://talebzadehmich.wordpress.com
>>>>
>>>>
>>>>
>>>
>>>
>>
>
Re: Hive configuration parameter hive.enforce.bucketing does not
exist in Hive 2
Posted by Lefty Leverenz <le...@gmail.com>.
FYI, the removal of hive.enforce.bucketing is documented in the wiki (
hive.enforce.bucketing
<https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.enforce.bucketing>)
and the JIRA issue that removed it is HIVE-12331
<https://issues.apache.org/jira/browse/HIVE-12331>.
-- Lefty
On Fri, Apr 29, 2016 at 12:07 PM, Mich Talebzadeh <mich.talebzadeh@gmail.com
> wrote:
> Unfortunately that needs to be done or better the whole line removed in
> every hql code where it is set as true .
>
> Thanks
>
> Dr Mich Talebzadeh
>
>
>
> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
>
> On 29 April 2016 at 19:35, Sergey Shelukhin <se...@hortonworks.com>
> wrote:
>
>> You can set hive.conf.validation to false to disable this :)
>>
>> From: Mich Talebzadeh <mi...@gmail.com>
>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>> Date: Friday, April 29, 2016 at 11:16
>> To: user <us...@hive.apache.org>
>> Subject: Re: Hive configuration parameter hive.enforce.bucketing does
>> not exist in Hive 2
>>
>> Well having it in the old code causes the query to crash as well!
>>
>> Dr Mich Talebzadeh
>>
>>
>>
>> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>
>>
>>
>> http://talebzadehmich.wordpress.com
>>
>>
>>
>> On 29 April 2016 at 18:33, Sergey Shelukhin <se...@hortonworks.com>
>> wrote:
>>
>>> This parameter has indeed been removed; it is treated as always true
>>> now, because setting it to false just produced incorrect tables.
>>>
>>> From: Mich Talebzadeh <mi...@gmail.com>
>>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>>> Date: Friday, April 29, 2016 at 02:51
>>> To: user <us...@hive.apache.org>
>>> Subject: Hive configuration parameter hive.enforce.bucketing does not
>>> exist in Hive 2
>>>
>>> Is the parameter
>>>
>>> --set hive.enforce.bucketing = true;
>>>
>>> depreciated in Hive 2 as it causes hql code not to work?
>>>
>>> hive> set hive.enforce.bucketing = true;
>>> Query returned non-zero code: 1, cause: hive configuration
>>> hive.enforce.bucketing does not exists.
>>>
>>>
>>> Dr Mich Talebzadeh
>>>
>>>
>>>
>>> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>>
>>>
>>>
>>> http://talebzadehmich.wordpress.com
>>>
>>>
>>>
>>
>>
>
Re: Hive configuration parameter hive.enforce.bucketing does not
exist in Hive 2
Posted by Mich Talebzadeh <mi...@gmail.com>.
Unfortunately that needs to be done or better the whole line removed in
every hql code where it is set as true .
Thanks
Dr Mich Talebzadeh
LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
On 29 April 2016 at 19:35, Sergey Shelukhin <se...@hortonworks.com> wrote:
> You can set hive.conf.validation to false to disable this :)
>
> From: Mich Talebzadeh <mi...@gmail.com>
> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
> Date: Friday, April 29, 2016 at 11:16
> To: user <us...@hive.apache.org>
> Subject: Re: Hive configuration parameter hive.enforce.bucketing does not
> exist in Hive 2
>
> Well having it in the old code causes the query to crash as well!
>
> Dr Mich Talebzadeh
>
>
>
> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
>
> On 29 April 2016 at 18:33, Sergey Shelukhin <se...@hortonworks.com>
> wrote:
>
>> This parameter has indeed been removed; it is treated as always true now,
>> because setting it to false just produced incorrect tables.
>>
>> From: Mich Talebzadeh <mi...@gmail.com>
>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>> Date: Friday, April 29, 2016 at 02:51
>> To: user <us...@hive.apache.org>
>> Subject: Hive configuration parameter hive.enforce.bucketing does not
>> exist in Hive 2
>>
>> Is the parameter
>>
>> --set hive.enforce.bucketing = true;
>>
>> depreciated in Hive 2 as it causes hql code not to work?
>>
>> hive> set hive.enforce.bucketing = true;
>> Query returned non-zero code: 1, cause: hive configuration
>> hive.enforce.bucketing does not exists.
>>
>>
>> Dr Mich Talebzadeh
>>
>>
>>
>> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>>
>>
>>
>> http://talebzadehmich.wordpress.com
>>
>>
>>
>
>
Re: Hive configuration parameter hive.enforce.bucketing does not
exist in Hive 2
Posted by Sergey Shelukhin <se...@hortonworks.com>.
You can set hive.conf.validation to false to disable this :)
From: Mich Talebzadeh <mi...@gmail.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Friday, April 29, 2016 at 11:16
To: user <us...@hive.apache.org>>
Subject: Re: Hive configuration parameter hive.enforce.bucketing does not exist in Hive 2
Well having it in the old code causes the query to crash as well!
Dr Mich Talebzadeh
LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
http://talebzadehmich.wordpress.com<http://talebzadehmich.wordpress.com/>
On 29 April 2016 at 18:33, Sergey Shelukhin <se...@hortonworks.com>> wrote:
This parameter has indeed been removed; it is treated as always true now, because setting it to false just produced incorrect tables.
From: Mich Talebzadeh <mi...@gmail.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Friday, April 29, 2016 at 02:51
To: user <us...@hive.apache.org>>
Subject: Hive configuration parameter hive.enforce.bucketing does not exist in Hive 2
Is the parameter
--set hive.enforce.bucketing = true;
depreciated in Hive 2 as it causes hql code not to work?
hive> set hive.enforce.bucketing = true;
Query returned non-zero code: 1, cause: hive configuration hive.enforce.bucketing does not exists.
Dr Mich Talebzadeh
LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
http://talebzadehmich.wordpress.com<http://talebzadehmich.wordpress.com/>
Re: Hive configuration parameter hive.enforce.bucketing does not
exist in Hive 2
Posted by Mich Talebzadeh <mi...@gmail.com>.
Well having it in the old code causes the query to crash as well!
Dr Mich Talebzadeh
LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
On 29 April 2016 at 18:33, Sergey Shelukhin <se...@hortonworks.com> wrote:
> This parameter has indeed been removed; it is treated as always true now,
> because setting it to false just produced incorrect tables.
>
> From: Mich Talebzadeh <mi...@gmail.com>
> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
> Date: Friday, April 29, 2016 at 02:51
> To: user <us...@hive.apache.org>
> Subject: Hive configuration parameter hive.enforce.bucketing does not
> exist in Hive 2
>
> Is the parameter
>
> --set hive.enforce.bucketing = true;
>
> depreciated in Hive 2 as it causes hql code not to work?
>
> hive> set hive.enforce.bucketing = true;
> Query returned non-zero code: 1, cause: hive configuration
> hive.enforce.bucketing does not exists.
>
>
> Dr Mich Talebzadeh
>
>
>
> LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
>
Re: Hive configuration parameter hive.enforce.bucketing does not
exist in Hive 2
Posted by Sergey Shelukhin <se...@hortonworks.com>.
This parameter has indeed been removed; it is treated as always true now, because setting it to false just produced incorrect tables.
From: Mich Talebzadeh <mi...@gmail.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Date: Friday, April 29, 2016 at 02:51
To: user <us...@hive.apache.org>>
Subject: Hive configuration parameter hive.enforce.bucketing does not exist in Hive 2
Is the parameter
--set hive.enforce.bucketing = true;
depreciated in Hive 2 as it causes hql code not to work?
hive> set hive.enforce.bucketing = true;
Query returned non-zero code: 1, cause: hive configuration hive.enforce.bucketing does not exists.
Dr Mich Talebzadeh
LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
http://talebzadehmich.wordpress.com<http://talebzadehmich.wordpress.com/>