hive导入nginx日志
将nginx日志导入到hive中的方法 1 在hive中建表 CREATETABLEapachelog(ipaddressSTRING,identdSTRING,userSTRING,finishtimeSTRING,requestlinestring,returncodeINT,sizeINT,refererstring,agentstring)ROWFORMATSERDE'org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe'WITHSERDEPROPERTIES('serialization.format'='org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol','quote.delim'='("|\\[|\\])','field.delim'='','serialization.null.format'='-')STOREDASTEXTFILE; 导入后日志格式为 203.208.60.91--05/May/2011:01:18:47+0800GET...