Hadoop Hive

Posts: 2
Joined: Mon Mar 02, 2015 8:34 pm

Hadoop Hive

Postby raj.michaels » Mon Mar 02, 2015 8:35 pm

I am not able to load data into the partitioned table as it is showing "Dynamic partition strict mode requires at least one static partition column. To turn this off set hive.exec.dynamic.partition.mode=nonstrict " the above error even on setting set hive.exec.dynamite.partition.mode=nonstrict;
hive> set hive.exec.dynamite.partition=true;
these parameter i am getting the same error.

Kindly suggest me the better solution.

Thanks in advance.

Finance Junkie
Posts: 944
Joined: Wed Apr 09, 2014 6:28 am

Hadoop Hive

Postby edupristine » Mon Mar 30, 2015 7:05 am

Hi, it should be dynamic partition. Spelling mistake of dynamite.Two properties to be set.

Return to “Big Data & Hadoop”


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to abuse@edupristine.com and we will rectify it.