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/UserGuide" by petewyckoff
Date Wed, 05 Nov 2008 21:15:14 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 petewyckoff:
http://wiki.apache.org/hadoop/Hive/UserGuide

The comment on the change is:
added example control separated and apache log format table creates

------------------------------------------------------------------------------
  == Supported Features ==
  == Usage Examples ==
  === Creating tables ===
+ 
+ ==== 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;
+ }}}
+ ==== 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;
+ }}}
+ 
  === Loading tables ===
  === Running queries ===
  === Running custom map/reduce jobs ===

Mime
View raw message