title: How to set user classpath precedence when not a mapreduce job?
body: <p>My class looks like this</p>
  
  <pre><code>public class generateAll extends Configured implements Tool
  {
  public static void main(String[] args) throws Exception 
  {
      ToolRunner.run(new generateAll(), args);
  }
  .
  .
  .
  </code></pre>
  
  <p>What i want is, to execute the program using hadoop jar command, because i am using getConf() statement inside program.</p>
  
  <p>There is no mapper reducer involved.</p>
  
  <p>There is already a hsqldb 1.8 in hadoop libs
  My program is using hsqlsb 2.2.9 ( as a maven dependency)</p>
  
  <p>There is a method in jobConf to override hadoop classpath with user classpath, But since my program doesnt involve map/reduce , How to override hadoop classpath ?</p>
  
  <p>The program is running fine when run as a test file. 
  hadoop version  - cdh3u3</p>
  
  <p>The error thrown while using hadoop jar command is:</p>
  
  <p>Exception in thread "main" java.sql.SQLException: Unexpected token AS, requires ( in statement [create table click as]
      at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
      at com.inmobi.qa.SQLUtil.SQLScriptExecuter.executeScript(SQLScriptExecuter.java:62)
      at com.inmobi.qa.logboxtools.generateAll.test_table_creation(generateAll.java:186)
      at com.inmobi.qa.logboxtools.generateAll.run(generateAll.java:104)
      at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
      at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:84)
      at com.inmobi.qa.logboxtools.generateAll.main(generateAll.java:55)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.hadoop.util.RunJar.main(RunJar.java:208)</p>