Problems
hegang1314
天生我材必有用!
展开
-
Install Hive on Ubuntu
This post is about the installation of Hive on Ubuntu. The environment of my system is ubuntu12.04, hadoop1.0.3, hive 0.9.0. Supposing the hadoop is installed.The details of installation for hive de原创 2013-05-17 19:37:58 · 1536 阅读 · 0 评论 -
sql server中秒数转时间差
sql server中把秒数转化为时间差:declare @seconds int=120;select case when @seconds/86400<>0 then convert(nvarchar,@seconds/86400)+'天' else '' end +convert(nvarchar,dateadd(s,@seconds%86400,0),108)原创 2013-11-19 15:06:55 · 2634 阅读 · 0 评论 -
struts和Extjs问题集锦
1、传递JSON二维数组的实现方法为了使struts与Extjs之间传递JSON二维数组,本文将探讨其实现方法。假设有一对象Person和Organ,其中Person的属性:organlist, age,name,Organ的属性:name,现取出所有person即变量personlist,而且JSON必须为key-value对,则在struts.xml中配置如下:personli原创 2013-08-18 18:53:47 · 859 阅读 · 0 评论 -
The detail deployment of website in tomcat
This post is about the deployment of website in tomcat. The detail step describes as follows.Step 1: Install mysql database.Unzip the file MYSQL55·0·67.zip and install mysql. Configure the databas原创 2013-06-26 10:16:01 · 869 阅读 · 0 评论 -
Some problems of mysql
This post is about some problems of mysql.1.access denied for user root@localhost(using password no)Reason: all kinds of problems.Solution: modify the password according to the following steps.原创 2013-06-26 10:36:33 · 818 阅读 · 0 评论 -
Create Parent-Child Dimension with SSAS
This post is about parent-child dimension in ssas.In order to create parent-child dimension successfully, the parent's key and child's key must be save data type and the parent key should be relativ原创 2013-06-22 15:13:54 · 788 阅读 · 0 评论 -
用分析服务SSAS解决占比、同比和环比问题
本文将介绍用分析服务SSAS如何解决占比、同比和环比三个指标。首先理解一下这三个指标的基本概念:占比是指当前成员的值与该成员父级的值的比率,意思是在总数中所占的比重,比如某水果商店总销售额为14,其中苹果的销售额为2,占比就是14.3%。同比是指在一个期间内的值与以前某个期间的值进行比较,并用以前期间值的百分比来表示,比如将今年的数据与去年的数据比较或将今年八月的数据与去年八月的数据比原创 2013-06-10 21:59:47 · 6073 阅读 · 0 评论 -
Common errors in SQL server
This post is about serval common errors in sql server.1.login failed for user sa because the account is currently locked out.the system administrator can unlock it.(Microsoft sql server,error:18486)原创 2013-06-10 22:11:20 · 860 阅读 · 0 评论 -
The differences of Iterator and Iterable interface
This post will describe som differences of Iterator and Iterable interface. Introduction with three aspects is given out.Firstly, relative abstract method.Iterator interface:boolean hasNext(); /原创 2013-05-26 22:16:57 · 968 阅读 · 0 评论 -
Development hadoop program on Windows
This post is about the development of hadoop program on windows. The detail configuration describes as follows:Step 1: copy the hadoop plugin to the eclipse's plugin directory.Step 2:restart the e原创 2013-05-25 10:38:48 · 1306 阅读 · 0 评论 -
Install Hive using Mysql as metadata store On Ubuntu.
This post is about the installation of Hive and use mysql as the metadata store on ubuntu. The environment of my system is ubuntu 12.04, hadoop 1.0.3, hive 0.9.0 and mysql 5.5.The detail information原创 2013-05-17 21:35:57 · 1015 阅读 · 0 评论 -
JXL操作Excel内容自动换行
new WritableCellFormat().setWrap(true);//通过调整宽度和高度自动换行new WritableSheet().setColumnView(1,10)//设置第2列宽度为10new WritableSheet().setRowView(1,1000)//设置第2行高度为50,注意单位为像素,1厘米=240象素原创 2014-02-26 21:56:10 · 8799 阅读 · 1 评论