You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2010/10/06 22:43:23 UTC
svn commit: r1005242 - in /hadoop/hive/trunk: CHANGES.txt
metastore/src/model/package.jdo
Author: namit
Date: Wed Oct 6 20:43:23 2010
New Revision: 1005242
URL: http://svn.apache.org/viewvc?rev=1005242&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)
Modified:
hadoop/hive/trunk/CHANGES.txt
hadoop/hive/trunk/metastore/src/model/package.jdo
Modified: hadoop/hive/trunk/CHANGES.txt
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/CHANGES.txt?rev=1005242&r1=1005241&r2=1005242&view=diff
==============================================================================
--- hadoop/hive/trunk/CHANGES.txt (original)
+++ hadoop/hive/trunk/CHANGES.txt Wed Oct 6 20:43:23 2010
@@ -163,6 +163,9 @@ Trunk - Unreleased
HIVE-1378. Return value for map, array, and struct needs to return a string
(Steven Wong via Ning Zhang)
+ HIVE-1364 Increase the maximum length of various metastore fields, and
+ remove TYPE_NAME from COLUMNS primary key (Carl Steinbach via namit)
+
OPTIMIZATIONS
BUG FIXES
Modified: hadoop/hive/trunk/metastore/src/model/package.jdo
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/metastore/src/model/package.jdo?rev=1005242&r1=1005241&r2=1005242&view=diff
==============================================================================
--- hadoop/hive/trunk/metastore/src/model/package.jdo (original)
+++ hadoop/hive/trunk/metastore/src/model/package.jdo Wed Oct 6 20:43:23 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">
@@ -24,10 +31,10 @@
<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" default-fetch-group="false">
@@ -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,7 +294,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>
@@ -312,7 +318,7 @@
<column name="INDEX_TBL_ID"/>
</field>
<field name="indexHandlerClass">
- <column name="INDEX_HANDLER_CLASS"/>
+ <column name="INDEX_HANDLER_CLASS" length="4000" jdbc-type="VARCHAR"/>
</field>
<field name="deferredRebuild">
<column name="DEFERRED_REBUILD"/>
@@ -335,7 +341,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>