ITPub博客

参考如下网址：http://bbs.csdn.net/topics/390941085$ ./spark-shell --master spark://qxy1:7077报如下错误：17/02/08 06:14:52 ERROR util.SparkUncaughtExceptionHandler: Uncaught exception in thread Thread[appclient-registration-retry-thread,5,main]java.util.concurrent.RejectedExecutionException: Ta...

转载：http://dongxicheng.org/mapreduce/run-hadoop-job-problems/1. 问题描述当用户编写完Hadoop程序时，准备运行时，经常会抛出以下异常：[15:10:41,949][ INFO][main][org.apache.hadoop.mapred.JobClient:1330] – Task Id : attempt_201202281244_0003_m_000000_1, Status : FAILEDError: ...

参考了：http://www.tuicool.com/articles/qY7F3q插件名称：hadoop2x-eclipse-plugin插件地址： https://github.com/winghc/hadoop2x-eclipse-plugin1.下载并解压hadoop2.x，下载地址 http://hadoop.apache.org/releases.html#Download （我下载的是编译好的包）2.下载并解压e...

hadoop异常：An internal error occurred during: “Map/Reduce location status updater”. java.lang.NullPointerException； 原因：在new Hadoop location时配置不正确，本人正确配置： DFS  master : 的端口为：/opt/hadoop-2.6.2/etc/hadoop/core-site.xml<property>  <name>fs.defa...

[hadoop@qxy1 logs]$ hadoop fs -ls /16/09/01 15:58:32 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicablels: Call From qxy1/192.168.233.159 to qxy1:8020 failed on connection exception: java.net.ConnectException: Connectio...

查找目录下的所有文件中是否含有某个字符串find . | xargs grep -ri "set"

 sqlldr   userid=/   control=result1.ctl   direct=true   parallel=true     sqlldr   userid=/   control=result2.ctl   direct=true   parallel=true     sqlldr   useri...

select tablespace_name, round(used_space*(select value from v$parameter where name='db_block_size')/power(2,30),2) USED_GB, round(tablespace_size*(select value from v$parameter where name='db_block_size')/power(2,30)) MAXSIZE_GB, round(used_percent,2) as "PCT%" from dba_tablespa...

时间戳是秒只有10位,后三位是毫秒,cast(substr(event_tm,10) as int) ,event_tm有13位，此处只取到秒，所以只取前10位

ORACLE中的支持正则表达式的函数主要有下面四个：1，REGEXP_LIKE ：与LIKE的功能相似2，REGEXP_INSTR ：与INSTR的功能相似3，REGEXP_SUBSTR ：与SUBSTR的功能相似4，REGEXP_REPLACE ：与REPLACE的功能相似它们在用法上与Oracle SQL 函数LIKE、INSTR、SUBSTR 和REPLACE 用法...

--取上个月的第一天select data_dt ,ADD_MONTHS(TRUNC( to_date(data_dt, 'YYYY-MM-DD'),'MM' ),-1)  from a_web_visit_origin;--取上个月的第一天，同上面的SQL一样，只不过为了，符合当地的日期格式select data_dt ,TO_CHAR (ADD_MONTHS(TRUNC( to_date(data_dt, 'YYYY-MM-DD'),'MM' ),-1),'YYYY-MM-DD')  ...

[root@qxy2 mysql]# service mysqld startRedirecting to /bin/systemctl start  mysqld.service[root@qxy2 mysql]# grep 'temporary password' /var/log/mysqld.log2016-05-04T13:46:01.727652Z 1 [Note] A temporary password is generated for root@localhost: _?Xwo>%do7S8[root@qxy2 mysql]# mysql -u root -...

select to_char(t, 'yyyymm') a, to_char(t, 'yyyy-mm') b, to_char(t, 'dd') c  from (    select decode(level,                  1,                  trunc(sysdate, 'dd'),      &nbs...

rpm -ivh cloudera-manager-agent-5.7.0-1.cm570.p0.76.el7.x86_64.rpm cloudera-manager-daemons-5.7.0-1.cm570.p0.76.el7.x86_64.rpm error: Failed dependencies:/lib/lsb/init-functions is needed by cloudera-manager-agent-5.7.0-1.cm570.p0.76.el7.x86_64  解决办法：yum install lsb...

systemctl stop firewalld.service

--有效的锁表语句select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;

不在同一用户的表，另一用户要访问，必须赋予权限：GRANT insert，select,delete ON sda_user.a_result_base TO swda_dev;create or replace TRIGGER a_result_base_trigerAFTER INSERT OR UPDATE OR DELETEON swda_dev.a_result_baseREFERENCING NEW AS New OLD AS OldFOR EACH ROWDECLAREBEGINIF INSERTING ...

    Vim可以用字符编码（Character Code）插入任意字符。使用此功能可以方便地输入键盘上找不到的字符。    只要知道某个字符的编码，就可以让Vim插入该字符，我们可以用这种方式插入任何字符。方法是：在插入模式下，Ctrl+v+{code}即可，其中{code}是要插字符的编码。只要按顺序按就是了，不是同...

/opt/smc/etlsmc/tomcat/webapps/smc/WEB-INF/classes/config/application.properties#schedule settingslogin.log.outday=7password.expired.day=90hibernate.dialect=org.hibernate.dialect.Oracle10gDialect~                         &n...