ClassNotFoundException: Class org.apache.hadoop.hive.contrib.serde2.RegexSerDe n

今天使用flume采集apache access log到hive表中，然後使用hiveQL進行日志分析，出現錯誤：

需要修改

1,HIVE_HOME/conf/hive-env.sh

加上HADOOP_HOME=you home

2,HIVE_HOME/conf/hive-site.xml

加上

<property>
          <name>hive.aux.jars.path</name>
          <value>file:///usr/local/hive-0.13.0/lib/hive-contrib-0.13.0.jar</value>
          <description>Added by tiger.zeng on 20120202.These JAR file are available to all users for all jobs</description>
        </property>      

然後從新執行hive 即可