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 DavidPhillips
Date Fri, 28 Nov 2008 15:39:26 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 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 ===

Mime
View raw message