You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ambari.apache.org by "Nitiraj Singh Rathore (JIRA)" <ji...@apache.org> on 2017/02/28 12:58:45 UTC

[jira] [Created] (AMBARI-20234) HiveView2.0 - settings not taking effect

Nitiraj Singh Rathore created AMBARI-20234:
----------------------------------------------

             Summary: HiveView2.0 - settings not taking effect
                 Key: AMBARI-20234
                 URL: https://issues.apache.org/jira/browse/AMBARI-20234
             Project: Ambari
          Issue Type: Bug
          Components: ambari-views
    Affects Versions: 2.5.0
            Reporter: Nitiraj Singh Rathore
            Assignee: Nitiraj Singh Rathore
             Fix For: 2.5.0


Tried adding hive.exec.dynamic.partition.mode=nonstrict in hive view setting.
But that is not working.
I verified the setting by running query "set hive.exec.dynamic.partition.mode" and it doesn't show updated value.
Details of what I was trying to do -
I ran following query -
insert into store_sales2 PARTITION (sale_date) select dob, 1, 1, 1 from student_table
It failed with - 
Caused by: java.lang.RuntimeException: org.apache.hadoop.hive.ql.parse.SemanticException:Dynamic partition strict mode requires at least one static partition column. To turn this off set hive.exec.dynamic.partition.mode=nonstrict
Then I added above settings and tried running query, it still fails with same error. So I tried running "set hive.exec.dynamic.partition.mode" to verify the setting, and it wasn't updated.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)