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