<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[wenlong237的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/wenlong237</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; wenlong237]]></copyright><item><title><![CDATA[csv文件导入mysql乱码解决]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/25241875</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/25241875</guid><author>wenlong237</author><pubDate>Wed, 07 May 2014 20:01:42 +0800</pubDate><description><![CDATA[1. 用记事本打开csv，另存为utf8]]></description><category></category></item><item><title><![CDATA[Hue 安装]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/19735603</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/19735603</guid><author>wenlong237</author><pubDate>Tue, 18 Mar 2014 17:24:42 +0800</pubDate><description><![CDATA[CDH 
Cloudera’s
 Distribution including Apache Hadoop (CDH4)



安装hue之前，centos系统需要安装以下组件：


CentOS:

antasciidoccyrus-sasl-develcyrus-sasl-gssapigccgcc-c++krb5-devellibtidy (for unit tests]]></description><category></category></item><item><title><![CDATA[oozie启动问题：Could not initialize service [org.apache.oozie.service.HadoopAccessorService]]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/21466267</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/21466267</guid><author>wenlong237</author><pubDate>Tue, 18 Mar 2014 16:33:18 +0800</pubDate><description><![CDATA[FATAL Services:533 - USER[-] GROUP[-] E0100: Could not initialize service [org.apache.oozie.service.HadoopAccessorService], org.xml.sax.SAXParseException; Premature end of file.


oozie-site.xml文件如]]></description><category></category></item><item><title><![CDATA[如何在 Win7 下一键清空剪贴板]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/19927001</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/19927001</guid><author>wenlong237</author><pubDate>Tue, 25 Feb 2014 18:33:31 +0800</pubDate><description><![CDATA[解决方案：
1. 建议一个清除剪贴板快捷方式
右键桌面，选择 新建 > 
快捷方式，在请键入对象的位置中输入：

cmd /c “echo off | clip”

打开该快捷方式属性

运行方式更改为 最小化，还可以更改图标，文件 %SystemRoot%\system32\shell32.dll 中最后几排有剪贴板图标。
2. 右键菜单添加清空剪贴板

需要修改注册表（]]></description><category></category></item><item><title><![CDATA[: syntax error near unexpected token `done']]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/17663499</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/17663499</guid><author>wenlong237</author><pubDate>Sun, 29 Dec 2013 23:43:20 +0800</pubDate><description><![CDATA[今天在cygwin中shell奇怪的错误: syntax error near unexpected token `done'
脚本如下：
#!/bin/bash
#riqizizeng
datebeg=$1
dateend=$2
#read datebeg
#read dateend
beg_s=`date -d "$datebeg" +%s`
echo "$beg_s"
end_s=`da]]></description><category></category></item><item><title><![CDATA[在cygwin上用ant编译hadoop的eclipse插件]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/17531041</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/17531041</guid><author>wenlong237</author><pubDate>Tue, 24 Dec 2013 16:17:39 +0800</pubDate><description><![CDATA[1.参考了http://bigboy.iteye.com/blog/1766382，和其不同的地方为：

 <!--
	
	
    -->
	
	
	
	 
	 
	 
	 

2.最后在%hdoop_root%src\contrib\eclipse-plugin下ant jar报错：软件包org.apache.hadoop.fs
 不存在
参考http://blog.csdn.ne]]></description><category></category></item><item><title><![CDATA[ssh：connect to localhost port 22: Operation timed out]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/17485073</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/17485073</guid><author>wenlong237</author><pubDate>Sun, 22 Dec 2013 15:32:57 +0800</pubDate><description><![CDATA[现象描述：


1. 在cygwin中 ssh localhost 结果超时；ssh 127.0.0.1 正常
2. start-all.sh 端口22连接超时
3. netstat -an 显示端口22被sshd占用未被其他程序占用
4.ping 127.0.0.1 正常
5.ping localhost 超时


解决办法
怀疑是localhost出了问题，后来想到以前集]]></description><category></category></item><item><title><![CDATA[syntax error near unexpected token `(']]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/17440889</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/17440889</guid><author>wenlong237</author><pubDate>Fri, 20 Dec 2013 14:31:19 +0800</pubDate><description><![CDATA[syntax error near unexpected token `('


i-zhangwenlong@ZhangWenL-E5430 ~
$ echo foo=(bar,baz)
-bash: syntax error near unexpected token `('

i-zhangwenlong@ZhangWenL-E5430 ~
$ echo "foo=(bar,baz)"]]></description><category></category></item><item><title><![CDATA[【转】数学公式编辑器Mathtype快捷键的使用]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/17323627</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/17323627</guid><author>wenlong237</author><pubDate>Sat, 14 Dec 2013 20:29:07 +0800</pubDate><description><![CDATA[Mathtype的快捷键的使用

　　为了加快数学符号的录入速度和效率，应该尽量使用Mathtype的快捷键。

　　如何了解和掌握Mathtype的快捷键？
 在Mathtype界面，将鼠标对准符号栏中的某个符号时，屏幕左下方就会显示该符号的快捷键。你随时都可以学习和掌握这些快捷键。用得多，自然就记得住了。

　　最有用的是分式、根式、上下标的快捷键。

　　这些快捷键的名称与]]></description><category></category></item><item><title><![CDATA[cygwin 安装配置ssh 问题]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/17278835</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/17278835</guid><author>wenlong237</author><pubDate>Thu, 12 Dec 2013 10:39:31 +0800</pubDate><description><![CDATA[参考了一篇 CYGWIN SSH Server 配置 http://nails.blog.51cto.com/640492/144025
但是我的出现了不同的问题 在创建账户输入密码时,总提示密码不符系统密码规则；
但是不创建账户的话会出现：



 Warning: Defaulting to 'SYSTEM'

/usr/bin/cygrunsrv: Error install]]></description><category></category></item><item><title><![CDATA[一道sql笔试题]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/17200531</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/17200531</guid><author>wenlong237</author><pubDate>Sun, 08 Dec 2013 14:40:47 +0800</pubDate><description><![CDATA[现有表T1,(字段1   char(20),字段2   varchar(100).
      ----------------------
      字段1             字段2
      ----------------------
        1                   '内容1 '
        1                   '内容2 ']]></description><category></category></item><item><title><![CDATA[sql 中 and  or]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/13772469</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/13772469</guid><author>wenlong237</author><pubDate>Thu, 31 Oct 2013 14:46:42 +0800</pubDate><description><![CDATA[select count(distinct(uid)) from pwd_act_user where year=2013 and month=09 and day=29 and vid=1154 or vid=1162;
134145
查的是  year=2013 and month=09 and day=29 and vid=1154   或者 vid=1162 的用户数
select]]></description><category></category></item><item><title><![CDATA[hive 报错 Caused by: java.lang.reflect.InvocationTargetException]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/13770851</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/13770851</guid><author>wenlong237</author><pubDate>Thu, 31 Oct 2013 13:23:56 +0800</pubDate><description><![CDATA[向一个表的分区中插入数据时
报错

java.lang.RuntimeException: Error in configuring object at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:106) at org.apache.hadoop.util.ReflectionUtils.se]]></description><category></category></item><item><title><![CDATA[hive查询异常：Cannot create directory /tmp/hive-root/。。。Name node is in safe mode.]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/11612847</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/11612847</guid><author>wenlong237</author><pubDate>Thu, 12 Sep 2013 17:38:04 +0800</pubDate><description><![CDATA[hive> select * from c; 
FAILED: RuntimeException org.apache.hadoop.ipc.RemoteException: org.apache.hadoop.hdfs.server.namenode.SafeModeException: Cannot create directory /tmp/hive-root/hive_2013-09-12]]></description><category></category></item><item><title><![CDATA[hive：Group by 问题：Expression Not In Group By Key]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/10227419</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/10227419</guid><author>wenlong237</author><pubDate>Fri, 23 Aug 2013 16:54:41 +0800</pubDate><description><![CDATA[hive又遇到了问题：
原来的mysql中sql语句为
SELECT 	DATEBUF, CITYID, CHANNELID FROM STAT_CVCHNEW WHERE DATEBUF>=20110517 AND DATEBUF
得到的结果应该是是按DATEBUF和CITYID分组，然后每组对应CHANNELID的第一个值
但在hive中报错
FAILED: SemanticExce]]></description><category></category></item><item><title><![CDATA[linux下hadoop与hive的单机开发配置]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/10180091</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/10180091</guid><author>wenlong237</author><pubDate>Thu, 22 Aug 2013 16:48:29 +0800</pubDate><description><![CDATA[今天尝试在虚拟机上配置hadoop与hive环境


linux系统为：  CentOS-6.3 64位


jdk版本：jdk-7u25-linux-x64.rpm


hadoop版本： hadoop-1.0.4.tar.gz


hive版本：


一  配置相关环境变量
[root@localhost ~]# vi /etc/profile
进入profi]]></description><category></category></item><item><title><![CDATA[java 利用jdbc连接hive查询示例]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/10173579</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/10173579</guid><author>wenlong237</author><pubDate>Thu, 22 Aug 2013 10:52:16 +0800</pubDate><description><![CDATA[转自http://ganliang13.iteye.com/blog/1736296




1.千万记得执行这个命令bin/hive --service hiveserver >/dev/null 2>/dev/null &，

否则就会出现hive ,Connection refuse 的异常。

 

2.加入包，我这里的环境是hadoop1.01,hive0.8.1]]></description><category></category></item><item><title><![CDATA[hive 静音模式 -S]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/10172585</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/10172585</guid><author>wenlong237</author><pubDate>Thu, 22 Aug 2013 10:29:20 +0800</pubDate><description><![CDATA[加入-S，终端上的输出不会有mapreduce的进度，执行完毕，只会把查询结果输出到终端上。这个静音模式很实用，,通过第三方程序调用，第三方程序通过hive的标准输出获取结果集。]]></description><category></category></item><item><title><![CDATA[jsp页面之间URL传值，中文乱码，测试demo]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/9876007</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/9876007</guid><author>wenlong237</author><pubDate>Sat, 10 Aug 2013 13:57:04 +0800</pubDate><description><![CDATA[测试url传参中文乱码

这个参数是
解决办法在tomcat中config中的server.xml中,port="8080"添加URLEncoding="gb2312",重启服务]]></description><category></category></item><item><title><![CDATA[tomcat问题，jsp页面无法编译，web页面一片空白，log显示空指针，在tomacat的work文件夹下没有生成相应的Java文件]]></title><link>https://blog.youkuaiyun.com/wenlong237/article/details/9873511</link><guid>https://blog.youkuaiyun.com/wenlong237/article/details/9873511</guid><author>wenlong237</author><pubDate>Sat, 10 Aug 2013 11:06:02 +0800</pubDate><description><![CDATA[相应的.log日志为：
!SESSION 2013-08-06 19:47:31.562 -----------------------------------------------
eclipse.buildId=I20070625-1500
java.version=1.7.0_25
java.vendor=Oracle Corporation
BootLoader constan]]></description><category></category></item></channel></rss>