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

Nitiraj Singh Rathore updated AMBARI-20234:
-------------------------------------------
    Attachment: AMBARI-20234_branch-2.5.patch

> 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)

Reply via email to