You will need to either convert your file to change ~ to \n or will need to develop a custom SerDe. ...
You will need to either convert your file to change ~ to \n or will need to develop a custom SerDe.
I get this error on my create table statement
Error in semantic analysis: LINES TERMINATED BY only supports newline ‘\n’ right now
What is my way out?
create table TestTable (
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ‘*’
LINES TERMINATED BY ‘~’ ;
A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.
Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world