hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From na...@apache.org
Subject svn commit: r1005214 - in /hadoop/hive/branches/branch-0.6: CHANGES.txt metastore/src/model/package.jdo
Date Wed, 06 Oct 2010 19:36:48 GMT
Author: namit
Date: Wed Oct  6 19:36:48 2010
New Revision: 1005214

URL: http://svn.apache.org/viewvc?rev=1005214&view=rev
Log:
HIVE-1364 Increase the maximum length of various metastore fields,
and remove TYPE_NAME from COLUMNS primary key (Carl Steinbach via namit)

M    metastore/src/model/package.jdo
M    CHANGES.txt

Modified:
    hadoop/hive/branches/branch-0.6/CHANGES.txt
    hadoop/hive/branches/branch-0.6/metastore/src/model/package.jdo

Modified: hadoop/hive/branches/branch-0.6/CHANGES.txt
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.6/CHANGES.txt?rev=1005214&r1=1005213&r2=1005214&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.6/CHANGES.txt (original)
+++ hadoop/hive/branches/branch-0.6/CHANGES.txt Wed Oct  6 19:36:48 2010
@@ -248,6 +248,9 @@ Release 0.6.0 -  Unreleased
     HIVE-1531. Make Hive build work with Ivy versions < 2.1.0
     (Carl Steinbach via jvs)
 
+    HIVE-1364 Increase the maximum length of various metastore fields,
+    and remove TYPE_NAME from COLUMNS primary key (Carl Steinbach via namit)
+
   OPTIMIZATIONS
 
     HIVE-1348. Move inputFileChanged() from ExecMapper to where it is needed

Modified: hadoop/hive/branches/branch-0.6/metastore/src/model/package.jdo
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.6/metastore/src/model/package.jdo?rev=1005214&r1=1005213&r2=1005214&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.6/metastore/src/model/package.jdo (original)
+++ hadoop/hive/branches/branch-0.6/metastore/src/model/package.jdo Wed Oct  6 19:36:48 2010
@@ -1,6 +1,13 @@
 <?xml version="1.0"?> 
 <!DOCTYPE jdo PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Metadata 2.0//EN"

-  "http://java.sun.com/dtd/jdo_2_0.dtd">  
+  "http://java.sun.com/dtd/jdo_2_0.dtd">
+<!--
+  Size Limitations:
+
+  Indexed VARCHAR: 767 bytes (MySQL running on InnoDB Engine http://bugs.mysql.com/bug.php?id=13315)
+  Non-indexed VARCHAR: 4000 bytes (max length on Oracle 9i/10g/11g)
+
+-->
 <jdo>  
   <package name="org.apache.hadoop.hive.metastore.model">  
     <class name="MDatabase" identity-type="datastore" table="DBS" detachable="true">
 
@@ -18,16 +25,16 @@
         <column name="DB_LOCATION_URI" length="4000" jdbc-type="VARCHAR" allows-null="false"/>
       </field>
     </class>
-    
+
     <class name="MFieldSchema" embedded-only="true" table="TYPE_FIELDS" detachable="true">
       <field name="name">
         <column name="FNAME" length="128" jdbc-type="VARCHAR"/>
       </field>
       <field name="type" >
-        <column name="FTYPE" length="767" jdbc-type="VARCHAR" allows-null="false"/>
+        <column name="FTYPE" length="4000" jdbc-type="VARCHAR" allows-null="false"/>
       </field>
       <field name="comment" >
-        <column name="FCOMMENT" length="767" jdbc-type="VARCHAR" allows-null="true"/>
+        <column name="FCOMMENT" length="4000" jdbc-type="VARCHAR" allows-null="true"/>
       </field>
     </class>
 
@@ -37,10 +44,10 @@
         <index name="UniqueType" unique="true"/>
       </field>
       <field name="type1">  
-        <column name="TYPE1" length="128" jdbc-type="VARCHAR"/>
+        <column name="TYPE1" length="767" jdbc-type="VARCHAR"/>
       </field>
       <field name="type2">  
-        <column name="TYPE2" length="128" jdbc-type="VARCHAR"/>
+        <column name="TYPE2" length="767" jdbc-type="VARCHAR"/>
       </field>
       <field name="fields" table="TYPE_FIELDS" >
         <collection element-type="MFieldSchema"/>
@@ -57,7 +64,7 @@
               <column name="FIELD_NAME" length="128" jdbc-type="VARCHAR"/>
               </field>
             <field name="type">
-              <column name="FIELD_TYPE" length="128" jdbc-type="VARCHAR"  allows-null="false"/>
+              <column name="FIELD_TYPE" length="767" jdbc-type="VARCHAR"  allows-null="false"/>
             </field>
           </embedded>
         </element>
@@ -96,7 +103,7 @@
               <column name="PKEY_TYPE" length="767" jdbc-type="VARCHAR" allows-null="false"/>
             </field>
             <field name="comment" >
-              <column name="PKEY_COMMENT" length="767" jdbc-type="VARCHAR" allows-null="true"/>
+              <column name="PKEY_COMMENT" length="4000" jdbc-type="VARCHAR" allows-null="true"/>
             </field>
           </embedded>
         </element>
@@ -105,7 +112,7 @@
         <column name="SD_ID"/>
       </field>
       <field name="owner">
-        <column name="OWNER" length="128" jdbc-type="VARCHAR"/>
+        <column name="OWNER" length="767" jdbc-type="VARCHAR"/>
       </field>
       <field name="createTime">
         <column name="CREATE_TIME" jdbc-type="integer"/>
@@ -125,7 +132,7 @@
            <column name="PARAM_KEY" length="256" jdbc-type="VARCHAR"/>
         </key>
         <value>
-           <column name="PARAM_VALUE" length="767" jdbc-type="VARCHAR"/>
+           <column name="PARAM_VALUE" length="4000" jdbc-type="VARCHAR"/>
         </value>
       </field>
       <field name="viewOriginalText">
@@ -147,7 +154,7 @@
         <column name="NAME" length="128" jdbc-type="VARCHAR"/>
       </field>
       <field name="serializationLib">
-        <column name="SLIB" length="767" jdbc-type="VARCHAR" allows-null="true"/>
+        <column name="SLIB" length="4000" jdbc-type="VARCHAR" allows-null="true"/>
       </field>
       <field name="parameters" table="SERDE_PARAMS">
         <map key-type="java.lang.String" value-type="java.lang.String"/>
@@ -158,7 +165,7 @@
            <column name="PARAM_KEY" length="256" jdbc-type="VARCHAR"/>
         </key>
         <value>
-           <column name="PARAM_VALUE" length="767" jdbc-type="VARCHAR"/>
+           <column name="PARAM_VALUE" length="4000" jdbc-type="VARCHAR"/>
         </value>
       </field>
     </class>
@@ -181,7 +188,6 @@
         <join>
           <primary-key name="COLUMNS_PK">
             <column name="COLUMN_NAME"/>
-            <column name="TYPE_NAME"/>
           </primary-key>
           <column name="SD_ID"/>
         </join>
@@ -191,19 +197,19 @@
               <column name="COLUMN_NAME" length="128" jdbc-type="VARCHAR"/>
               </field>
             <field name="type">
-              <column name="TYPE_NAME" length="128" jdbc-type="VARCHAR"  allows-null="false"/>
+              <column name="TYPE_NAME" length="4000" jdbc-type="VARCHAR"  allows-null="false"/>
             </field>
           </embedded>
         </element>
       </field>
       <field name="location">
-        <column name="LOCATION" length="767" jdbc-type="VARCHAR"/>
+        <column name="LOCATION" length="4000" jdbc-type="VARCHAR"/>
       </field>
       <field name="inputFormat">
-        <column name="INPUT_FORMAT" length="256" jdbc-type="VARCHAR"/>
+        <column name="INPUT_FORMAT" length="4000" jdbc-type="VARCHAR"/>
       </field>
       <field name="outputFormat">
-        <column name="OUTPUT_FORMAT" length="256" jdbc-type="VARCHAR"/>
+        <column name="OUTPUT_FORMAT" length="4000" jdbc-type="VARCHAR"/>
       </field>
       <field name="isCompressed"/>
       <field name="numBuckets">
@@ -244,7 +250,7 @@
            <column name="PARAM_KEY" length="256" jdbc-type="VARCHAR"/>
         </key>
         <value>
-           <column name="PARAM_VALUE" length="767" jdbc-type="VARCHAR"/>
+           <column name="PARAM_VALUE" length="4000" jdbc-type="VARCHAR"/>
         </value>
       </field>
     </class>
@@ -288,10 +294,9 @@
            <column name="PARAM_KEY" length="256" jdbc-type="VARCHAR"/>
         </key>
         <value>
-           <column name="PARAM_VALUE" length="767" jdbc-type="VARCHAR"/>
+           <column name="PARAM_VALUE" length="4000" jdbc-type="VARCHAR"/>
         </value>
       </field>
     </class>
-
   </package>
 </jdo>



Mime
View raw message