2014-06-20 17:30:10,044 ERROR parse.SemanticAnalyzer (SemanticAnalyzer.java:getMetaData(1323)) - 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

        at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer$tableSpec.(BaseSemanticAnalyzer.java:773)

        at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer$tableSpec.(BaseSemanticAnalyzer.java:707)

        at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1196)

        at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1053)

        at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:8342)

        at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:284)

        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:441)

        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:342)

        at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:977)

        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)

        at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:102)

        at org.apache.hive.service.cli.operation.SQLOperation.access$000(SQLOperation.java:62)

        at org.apache.hive.service.cli.operation.SQLOperation$1.run(SQLOperation.java:153)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

        at java.util.concurrent.FutureTask.run(FutureTask.java:262)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

        at java.lang.Thread.run(Thread.java:744)

2014-06-20 17:30:10,045 ERROR ql.Driver (SessionState.java:printError(419)) - FAILED: SemanticException [Error 10096]: Dynamic partition strict mode requires at least one static partition column. To turn this off set hive.exec.dynamic.partition.mode=nonstrict

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

        at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1324)

        at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1053)

        at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:8342)

        at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:284)

        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:441)

        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:342)

        at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:977)

        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:888)