I have fixed this - I was using the wrong character to replace line breaks.
I was replacing \r when it needed to be \n.
Regards,
Charles
On 18 August 2014 08:44, Charles Robertson
wrote:
> Hi Andre,
>
> Table and view definitions:
>
> CREATE EXTERNAL TABLE tweets_raw (
>id BIGINT,
>cre
Hi Andre,
Table and view definitions:
CREATE EXTERNAL TABLE tweets_raw (
id BIGINT,
created_at STRING,
text STRING,
screen_name STRING,
name STRING
)
ROW FORMAT SERDE 'com.amazon.elasticmapreduce.JsonSerde'
WITH SERDEPROPERTIES (
'paths'='id, created_at, text, user.screen_nam
Hi, Charles,
What's the storage format for the raw data source?
What's the definition of your view?
On 18 August 2014 04:20, Charles Robertson
wrote:
> HI all,
>
> I am loading some data into a Hive table, and one of the fields contains
> text which I believe contains new line characters. I ha
