You can use lazy simple serde with ROW FORMAT DELIMITED FIELDS TERMINATED
BY ',' ESCAPED BY '\'. Check the DDL for details
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL
On Thu, Feb 12, 2015 at 8:19 PM, Sreeman wrote:
> Hi All,
>
> How all of you are creating hive/Impala
Hi All,
How all of you are creating hive/Impala table when the CSV file has some
values with COMMA in between. it is like
sree,12345,"payment made,but it is not successful"
I know opencsv serde is there but it is not available in lower versions of
Hive 14.0
Thank you Matthew!
In Solution 2, is the highlighted portion your typo - so 'hip music' would
remain 'hip music'. Did you hipmusic (as unigram?)
However your second comment is correct - "however it presumes that for each
ngram you don't want to keep any spaces", but I don't want that to happen.
