title: load pipe separated csv to hive
body: <p>I am trying to load pipe separated csv file in hive table using python without success. Please assist. </p>
  
  <p>Full code:</p>
  
  <pre><code>from pyhive import hive 
  host_name = "192.168.220.135" 
  port = 10000 
  user = "cloudera" 
  password = "cloudera" 
  database = "default" 
  conn = hive.Connection(host=host_name, port=port, username=user, database=database) 
  print('Connected to DB: {}'.format(host_name)) 
  cursor = conn.cursor() 
  Query = """LOAD DATA LOCAL inpath '/home/cloudera/Desktop/ccna_test/RERATING_EMMCCNA.csv' INTO TABLE python_testing fields terminated by '|' lines terminated by '\n' """ 
  cursor.execute(Query)
  </code></pre>