You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ambari.apache.org by jl...@apache.org on 2015/06/04 20:35:33 UTC

ambari git commit: AMBARI-11698: SQL Server DB create script should use VARBINARY(max) as the bytea replacement (jluniya)

Repository: ambari
Updated Branches:
  refs/heads/trunk c01865ade -> a4f9081c7


AMBARI-11698: SQL Server DB create script should use VARBINARY(max) as the bytea replacement (jluniya)


Project: http://git-wip-us.apache.org/repos/asf/ambari/repo
Commit: http://git-wip-us.apache.org/repos/asf/ambari/commit/a4f9081c
Tree: http://git-wip-us.apache.org/repos/asf/ambari/tree/a4f9081c
Diff: http://git-wip-us.apache.org/repos/asf/ambari/diff/a4f9081c

Branch: refs/heads/trunk
Commit: a4f9081c7af18a5f08b4aec800e3f4f9b624d2fa
Parents: c01865a
Author: Jayush Luniya <jl...@hortonworks.com>
Authored: Thu Jun 4 11:35:29 2015 -0700
Committer: Jayush Luniya <jl...@hortonworks.com>
Committed: Thu Jun 4 11:35:29 2015 -0700

----------------------------------------------------------------------
 .../main/resources/Ambari-DDL-SQLServer-CREATE.sql    | 14 +++++++-------
 1 file changed, 7 insertions(+), 7 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/ambari/blob/a4f9081c/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql
----------------------------------------------------------------------
diff --git a/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql
index 07fe02e..20c75b3 100644
--- a/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql
+++ b/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql
@@ -238,7 +238,7 @@ CREATE TABLE members (
   );
 
 CREATE TABLE execution_command (
-  command VARBINARY(8000),
+  command VARBINARY(MAX),
   task_id BIGINT NOT NULL,
   PRIMARY KEY CLUSTERED (task_id)
   );
@@ -287,9 +287,9 @@ CREATE TABLE stage (
   skippable SMALLINT DEFAULT 0 NOT NULL,
   log_info VARCHAR(255) NOT NULL,
   request_context VARCHAR(255),
-  cluster_host_info VARBINARY(8000) NOT NULL,
-  command_params VARBINARY(8000),
-  host_params VARBINARY(8000),
+  cluster_host_info VARBINARY(MAX) NOT NULL,
+  command_params VARBINARY(MAX),
+  host_params VARBINARY(MAX),
   PRIMARY KEY CLUSTERED (
     stage_id,
     request_id
@@ -303,7 +303,7 @@ CREATE TABLE request (
   create_time BIGINT NOT NULL,
   end_time BIGINT NOT NULL,
   exclusive_execution BIT NOT NULL DEFAULT 0,
-  inputs VARBINARY(8000),
+  inputs VARBINARY(MAX),
   request_context VARCHAR(255),
   request_type VARCHAR(255),
   request_schedule_id BIGINT,
@@ -317,7 +317,7 @@ CREATE TABLE requestresourcefilter (
   request_id BIGINT NOT NULL,
   service_name VARCHAR(255),
   component_name VARCHAR(255),
-  hosts VARBINARY(8000),
+  hosts VARBINARY(MAX),
   PRIMARY KEY CLUSTERED (filter_id)
   );
 
@@ -434,7 +434,7 @@ CREATE TABLE requestschedulebatchrequest (
   request_id BIGINT,
   request_type VARCHAR(255),
   request_uri VARCHAR(1024),
-  request_body VARBINARY(8000),
+  request_body VARBINARY(MAX),
   request_status VARCHAR(255),
   return_code SMALLINT,
   return_message TEXT,