You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by Apache Wiki <wi...@apache.org> on 2008/11/28 16:39:26 UTC
[Hadoop Wiki] Update of "Hive/UserGuide" by DavidPhillips
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 DavidPhillips:
http://wiki.apache.org/hadoop/Hive/UserGuide
The comment on the change is:
format for readability
------------------------------------------------------------------------------
==== Apache Access Log Tables ====
{{{
- create table apachelog(ipaddress STRING,identd STRING,user STRING,finishtime STRING,requestline string,returncode INT,size INT) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe' WITH SERDEPROPERTIES ( 'serialization.format'= 'org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol', 'quote.delim'= '("|\\[|\\])', 'field.delim'=' ', 'serialization.null.format'='-' ) STORED AS TEXTFILE;
+ CREATE TABLE apachelog (
+ ipaddress STRING, identd STRING, user STRING,finishtime STRING,
+ requestline string, returncode INT, size INT)
+ ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe'
+ WITH SERDEPROPERTIES (
+ 'serialization.format'='org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol',
+ 'quote.delim'='("|\\[|\\])',
+ 'field.delim'=' ',
+ 'serialization.null.format'='-')
+ STORED AS TEXTFILE;
}}}
==== Control Separated Tables ====
{{{
- create table mylog(name STRING,language STRING,groups ARRAY<STRING>, entities MAP<INT, STRING>) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe' WITH SERDEPROPERTIES ( 'serialization.format'= 'org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol', 'field.delim'='\001','collection.delim'='\004', mapkey.delim='\002',linedelim='\n') STORED AS TEXTFILE;
+ CREATE TABLE mylog (
+ name STRING, language STRING, groups ARRAY<STRING>, entities MAP<INT, STRING>)
+ ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe'
+ WITH SERDEPROPERTIES (
+ 'serialization.format'='org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol',
+ 'field.delim'='\001', 'collection.delim'='\004',
+ mapkey.delim='\002', linedelim='\n')
+ STORED AS TEXTFILE;
}}}
=== Loading tables ===