title: R - Read foreign language data from HIVE and Write to MySQL
body: <p>I have some English as well as some Hindi data in my HIVE tables. I use R to connect to HIVE and read this data and then do some processing using dataframes and then I want to write this data to a table in MySQL database.</p>
  
  <p>I am able to connect to HIVE from R and then I run a <code>df &lt;- dbGetQuery(conn, &lt;Select Query&gt;)</code> command to extract data from HIVE table. I see that the resulting dataframe has only the Unicode values of the Hindi characters and not the actual Hindi characters. How do I preserve the original data?</p>
  
  <p>Plus, I have a lot of processing steps of this data before I write the output to MySQL. How do I ensure that Hindi characters are preserved all throughout?</p>