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,
