title: hive load data:how to specify file column separator and dynamic partition columns?
body: <p>well I had some question on loading mysql data into hive2, and don't know how to specify the separator, I tried for serval times but got nothing.</p>
  
  <p>Here below is the hive table,<code>id</code> is the partition column,</p>
  
  <pre><code>0: jdbc:hive2://localhost/&gt; desc test;  
  +-----------+------------+----------+  
  | col_name  | data_type  | comment  |  
  +-----------+------------+----------+  
  | a         | string     |          |  
  | id        | int        |          |  
  +-----------+------------+----------+
  </code></pre>
  
  <p>When i execute </p>
  
  <pre><code>load data local inpath 'file:///root/test' into table test partition (id=1);
  </code></pre>
  
  <p>it says:</p>
  
  <pre><code>Invalid path ''file:///root/test'': No files matching path file
  </code></pre>
  
  <p>but it do exists.</p>
  
  <p>I wish to dynamic partitioned by the specified file,so i add the very column into the file like this:</p>
  
  <pre><code>root@&lt;namenode|~&gt;:#cat /root/test  
  a,1  
  b,2
  </code></pre>
  
  <p>but it also failed,the docs say nothing about this,i guess it doesn't support right now.
  dose anyone got some idea in it? any help will be appreciated!</p>