[
https://issues.apache.org/jira/browse/HADOOP-2329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12547597
]
udanax edited comment on HADOOP-2329 at 12/2/07 4:49 PM:
--------------------------------------------------------------
- { Create, Insert, Select } Syntax and Codes will be changed.
Built-In Data Types
||Data Type||Explanation||
|BOOLEAN|Stores the Boolean values for true and false|
|BYTE|Stores binary data that are not random access|
|CHAR(*n*)|Stores single-byte or multibyte sequences of characters, including
letters, numbers, and symbols of fixed length Collation is code-set dependent|
|VARCHAR(*m*,*r*)|Stores single-byte or multibyte strings of letters, numbers,
and symbols of varying length to a maximum of 255 bytes Collation is code-set
dependent|
|DECIMAL|Stores numbers with definable scale and precision|
|INTEGER or INT|Stores whole numbers from -(2^31^-1) to 2^31^-1|
|SMALLINT|Stores whole numbers from -(2^15^-1) to 2^15^-1|
|INT8|Stores an 8-byte integer value These whole numbers can be in the range
-(2^63^-1) to 2^63^-1|
|SERIAL|Stores sequential integers; has the same range of values as INTEGER|
|SERIAL8|Stores large sequential integers; has the same range of values as INT8|
|TEXT|Stores text data in chunks that are not random access|
was (Author: udanax):
- { Create, Insert, Update } Syntax will be changed.
Built-In Data Types
||Data Type||Explanation||
|BOOLEAN|Stores the Boolean values for true and false|
|BYTE|Stores binary data that are not random access|
|CHAR(*n*)|Stores single-byte or multibyte sequences of characters, including
letters, numbers, and symbols of fixed length Collation is code-set dependent|
|VARCHAR(*m*,*r*)|Stores single-byte or multibyte strings of letters, numbers,
and symbols of varying length to a maximum of 255 bytes Collation is code-set
dependent|
|DECIMAL|Stores numbers with definable scale and precision|
|INTEGER or INT|Stores whole numbers from -(231-1) to 231-1|
|SMALLINT|Stores whole numbers from -(215-1) to 215-1|
|INT8|Stores an 8-byte integer value These whole numbers can be in the range
-(263-1) to 263-1|
|SERIAL|Stores sequential integers; has the same range of values as INTEGER|
|SERIAL8|Stores large sequential integers; has the same range of values as INT8|
|TEXT|Stores text data in chunks that are not random access|
> [Hbase Shell] Addition of Built-In Value Data Types for efficient accessing
> and stroing data
> --------------------------------------------------------------------------------------------
>
> Key: HADOOP-2329
> URL: https://issues.apache.org/jira/browse/HADOOP-2329
> Project: Hadoop
> Issue Type: New Feature
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
>
> A built-in data type is a fundamental data type that the hbase shell defines.
> (character strings, scalars, ranges, arrays, ... , etc)
> If you need a specialized data type that is not currently provided as a
> built-in type,
> you are encouraged to write your own user-defined data type using UDC(not yet
> implemented).
> (or contribute it for distribution in a future release of hbase shell)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
