Saving all output to "!!{outputDirectory}!!/input19.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/input19.q >>> >>> create table apachelog(ipaddress STRING,identd STRING,user_name 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; No rows affected >>> LOAD DATA LOCAL INPATH '../data/files/apache.access.log' INTO TABLE apachelog; No rows affected >>> SELECT a.* FROM apachelog a; 'ipaddress','identd','user_name','finishtime','requestline','returncode','size' '127.0.0.1','','frank','10/Oct/2000:13:55:36 -0700','GET /apache_pb.gif HTTP/1.0','200','2326' 1 row selected >>> >>> !record