hive locate from s3 - query

[ram kumar]

when i map the hive table to locate the s3 path,
it throws exception for the* new line at the beginning of line*.
Is there a solution to trim the new line at the beginning in hive?
Or any alternatives?


CREATE EXTERNAL TABLE work (
        time BIGINT,
        uid STRING,
        type STRING
)
ROW FORMAT SERDE 'com.proofpoint.hive.serde.JsonSerde'
LOCATION 's3n://work/';



*hive > select * from work;Failed with exception java.io
<http://java.io>.IOException:org.apache.hadoop.hive.serde2.SerDeException:
error parsing JSON*



Thanks