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 ===
