title: How to load XML data file into Hive table?
body: <p>While loading XML data file into HIVE table i got following error message:  </p>
  
  <pre><code>FAILED: SemanticException 7:9 Input format must implement InputFormat. Error   encountered near token 'StoresXml'.  
  </code></pre>
  
  <p>The way i am loading the XML file is as follows  :</p>
  
  <p>**Create a table StoresXml  </p>
  
  <pre><code>   'CREATE EXTERNAL TABLE StoresXml (storexml string)
     STORED AS INPUTFORMAT 'org.apache.mahout.classifier.bayes.XmlInputFormat'
     OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
     LOCATION '/user/hive/warehouse/stores';'
  </code></pre>
  
  <p>** Location /user/hive/warehouse/stores is in HDFS.</p>
  
  <p><code>load data inpath &lt;local path where the xml file is stored&gt; into table StoresXml;</code></p>
  
  <p>Now,problem is when i select any column from table StoresXml ,the above mentioned error comes up.</p>
  
  <p>Please help me with it.Where i am going wrong?</p>