title: Loading Hive table from Windows machine (Load data local inpath)
body: <p>I am trying to load a Hive table using a file from Windows. But I am getting the following error:</p>
  
  <pre><code>java.sql.SQLException: Error while compiling statement: FAILED: IllegalArgumentException
  java.net.URISyntaxException: Expected scheme-specific part at index 2: C:
  </code></pre>
  
  <p>I am using Talend ETL tool to process the file. Below is the code generated by Talend:</p>
  
  <pre><code>String path_tHiveLoad_1 = "file:///C:/employee.txt";
  String tablename_tHiveLoad_1 = "test.employee";
  java.sql.Statement stmt_tHiveLoad_1 = conn_tHiveLoad_1
                          .createStatement();
  String querySQL_tHiveLoad_1 = "LOAD DATA LOCAL INPATH '"
                          + path_tHiveLoad_1 + "' OVERWRITE  INTO TABLE "
                          + tablename_tHiveLoad_1 + "";
  </code></pre>