title: How to specify a STRING as a delimiter in HIVE table creation
body: <p>My data looks like:</p>
  
  <p><strong>a||b||c</strong></p>
  
  <p>To fetch the data my create table statement is:</p>
  
  <p>CREATE TABLE</p>
  
  <p>( col1 STRING,</p>
  
  <p>col2 STRING,</p>
  
  <p>col3 STRING)</p>
  
  <p>ROW FORMAT DELIMITED FIELDS TERMINATED BY "||";</p>
  
  <p>But here it is taking '|' as the delimiter not "||".</p>
  
  <p>Can anyone help me on this?</p>