hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/HiveQL/Types" by ZhengShao
Date Wed, 21 Jan 2009 22:37:22 GMT
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, 
  

Mime
View raw message