hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: hive locate from s3 - query
Date Fri, 03 Jul 2015 14:28:10 GMT
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 <ramkumarrock3@gmail.com> 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
>

Mime
View raw message