Mailing-List: contact core-commits-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: core-dev@hadoop.apache.org
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Apache Wiki <wikidiffs@apache.org>
To: core-commits@hadoop.apache.org
Date: Wed, 21 Jan 2009 22:37:22 -0000
Message-ID: <20090121223722.23382.96105@eos.apache.org>
Subject: [Hadoop Wiki] Update of "Hive/HiveQL/Types" by ZhengShao

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.

The following page has been changed by ZhengShao:
http://wiki.apache.org/hadoop/Hive/HiveQL/Types

------------------------------------------------------------------------------
- 
  == Types supported By Hive ==
  The following types are supported by Hive:
   * !TinyInt
@@ -8, +7 @@

   * Int
   * !BigInt
   * Double
+  * Boolean
+  * String
  
- The reason that we don't support !Float is that it's not supported by Thrift, and we use Thrift a lot inside Hive.
+ Float is not supported because it's not supported by Thrift, and Hive uses Thrift a lot for internal data serialization/deserialization.
  
+ Examples of creating a table with columns of various types:
+ 
+ (((
+ 
+ CREATE TABLE test_table (
+ a TINYINT,
+ b SMALLINT,
+ c INT,
+ d BIGINT,
+ e DOUBLE,
+ f BOOLEAN,
+ g STRING,
+ );
+ 
+ )))
  
  == Implicit and Explicit Type Conversions ==
+ In most cases, users don't need to care about the types,