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