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

["Nitiraj Singh Rathore (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/AMBARI-20234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nitiraj Singh Rathore updated AMBARI-20234:
-------------------------------------------
    Resolution: Fixed
        Status: Resolved  (was: Patch Available)

committed to branch-2.5 and trunk

> 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
>
>         Attachments: AMBARI-20234_branch-2.5.patch
>
>
> 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)