You probably need to make your own serde/input format that trims the line. On Fri, Jul 3, 2015 at 8:15 AM, ram kumar <[email protected]> wrote:
> 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 >
