title: Load data Query hive using file path in windows
body: <p>I am trying to load data in hive through a java program. I am loading the file from my machine. </p>
  
  <pre><code>stmt.executeQuery("load data local inpath  'file:///C:/sample/Documents/sample1.txt'  into table " + tablename);
  </code></pre>
  
  <p>When I execute this program I am getting the following exception</p>
  
  <pre><code>Caused by: java.lang.RuntimeException: java.net.URISyntaxException:Expected scheme-specific part at index 2: C:
      at java.net.URI$Parser.fail(URI.java:2829)
      at java.net.URI$Parser.failExpecting(URI.java:2835)
      at java.net.URI$Parser.parse(URI.java:3038)
      at java.net.URI.&lt;init&gt;(URI.java:753)
  </code></pre>
  
  <p>However when I execute the program in a ubuntu machine</p>
  
  <pre><code>stmt.executeQuery("load data local inpath  '/home/sample/sample1.txt'  into table " + tablename);
  </code></pre>
  
  <p>The data is loaded correctly to the hive database.</p>
  
  <p>When I execute the program in windows I am getting the exception. How can I solve this?</p>