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 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 begi
hive> select * from table;
FAILED: SemanticException org.jets3t.service.ServiceException: Request
Error: java.lang.StackOverflowError
hive>
got this exception when fetching from s3
Then i distcp to another s3 path, it works.
It's weird.
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
