PREHOOK: query: DROP TABLE IF EXISTS UserVisits_web_text_none
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE IF EXISTS UserVisits_web_text_none
POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE UserVisits_web_text_none (
  sourceIP string,
  destURL string,
  visitDate string,
  adRevenue float,
  userAgent string,
  cCode string,
  lCode string,
  sKeyword string,
  avgTimeOnSite int)
row format delimited fields terminated by '|'  stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@UserVisits_web_text_none
POSTHOOK: query: CREATE TABLE UserVisits_web_text_none (
  sourceIP string,
  destURL string,
  visitDate string,
  adRevenue float,
  userAgent string,
  cCode string,
  lCode string,
  sKeyword string,
  avgTimeOnSite int)
row format delimited fields terminated by '|'  stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@UserVisits_web_text_none
PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/UserVisits.dat" INTO TABLE UserVisits_web_text_none
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@uservisits_web_text_none
POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/UserVisits.dat" INTO TABLE UserVisits_web_text_none
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@uservisits_web_text_none
FAILED: SemanticException [Error 10002]: Invalid column reference 'destIP' (possible columns are [sourceip, desturl, visitdate, adrevenue, useragent, ccode, lcode, skeyword, avgtimeonsite])