Hi, I'm trying to implement a simple data analytic use case. I put in the cluster files with random number of rows similar to the following (fields could be populated randomly):       --;1374487936469;'';;;;;;;;;;;0.24516626;-0.85808194;7.4775715;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;   Then I create a Hive external table w/ the following command:   CREATE EXTERNAL TABLE myTable (f1 STRING, f2 STRING, f3 STRING, f4 STRING, <otherFields> )  ROW FORMAT DELIMITED  FIELDS TERMINATED BY '\U003B' LINES TERMINATED BY '\n' STORED AS TEXTFILE LOCATION '/user/test/2013-07_08';   In '/user/test/2013-07_08' there is at least a file w/ rows similar to the one described above. Trying to select a bunch of rows w/:  select * from myTable limit 10; I obtain a resultset of 10 rows where each row contains a complete line of the file addressed in column f1. " FIELDS TERMINATED BY '\U003B' " doesn't work, but even w/ '\u037E, ';' (this raises a stringLiteral error), '\059'. Seems a simple problem but I can't realize which, and... I can't change the separator. Have you any advice? Thanks Rob ... View more