You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@oozie.apache.org by pb...@apache.org on 2017/03/22 11:23:49 UTC

[44/50] [abbrv] oozie git commit: OOZIE-1887 Remove the utils dir (kvntrieu via rkanter)

http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/updatescripts-3.x-to-3.1.0.sql
----------------------------------------------------------------------
diff --git a/utils/dbutils/updatescripts/updatescripts-3.x-to-3.1.0.sql b/utils/dbutils/updatescripts/updatescripts-3.x-to-3.1.0.sql
deleted file mode 100644
index 9b7a1db..0000000
--- a/utils/dbutils/updatescripts/updatescripts-3.x-to-3.1.0.sql
+++ /dev/null
@@ -1,20 +0,0 @@
--- 
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements.  See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership.  The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License.  You may obtain a copy of the License at
---   
---     http://www.apache.org/licenses/LICENSE-2.0
---   
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
--- 
-ALTER TABLE WF_ACTIONS ADD USER_RETRY_COUNT NUMBER DEFAULT 0;
-ALTER TABLE WF_ACTIONS ADD USER_RETRY_MAX NUMBER DEFAULT 0;
-ALTER TABLE WF_ACTIONS ADD USER_RETRY_INTERVAL NUMBER DEFAULT 0;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/upgradescript-2.x-to-3.0.0.sql
----------------------------------------------------------------------
diff --git a/utils/dbutils/updatescripts/upgradescript-2.x-to-3.0.0.sql b/utils/dbutils/updatescripts/upgradescript-2.x-to-3.0.0.sql
deleted file mode 100644
index 7ad0546..0000000
--- a/utils/dbutils/updatescripts/upgradescript-2.x-to-3.0.0.sql
+++ /dev/null
@@ -1,37 +0,0 @@
--- 
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements.  See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership.  The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License.  You may obtain a copy of the License at
---   
---     http://www.apache.org/licenses/LICENSE-2.0
---   
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
--- 
-
-# please replace "OOZIEDB" to your schema name
-
-UPDATE OOZIEDB.COORD_JOBS
-SET STATUS = 'RUNNING',PENDING = 1
-WHERE ID IN 
-(
-SELECT JOB_ID FROM COORD_ACTIONS WHERE JOB_ID IN (
-SELECT ID FROM COORD_JOBS WHERE STATUS = 'SUCCEEDED') AND  (STATUS != 'FAILED' AND
-STATUS != 'SUCCEEDED' AND STATUS != 'KILLED' AND STATUS != 'TIMEDOUT') 
-);
-
-UPDATE OOZIEDB.COORD_JOBS SET STATUS = 'RUNNING' WHERE STATUS = 'PREMATER';
-
-UPDATE OOZIEDB.COORD_ACTIONS 
-SET STATUS = 'SUSPENDED'
-WHERE ID IN(
-SELECT A.ID FROM COORD_ACTIONS A, WF_JOBS B WHERE A.EXTERNAL_ID = B.ID
-AND B.STATUS = 'SUSPENDED' AND A.STATUS = 'RUNNING'
-);