java
- 读文件
try {
// 打包后路径就变了,路径直接这写(前提是这个文件放到resources路径中,并且打到jar包里了)
BufferedReader bf = new BufferedReader(new FileReader("UserBehavior.csv"));
String line = "";
while ((line = bf.readLine()) != null) {
String[] lin = line.split(",");
map.put(lin[0], line);
}
} catch (IOException e) {
e.printStackTrace();
}
Maven
- 打包时跳过@Test运行:
mvn install -Dmaven.test.skip=true
shell脚本
- 读取某个目录下所有文件
- 字符串截取
#!/bin/sh
#read fileName create external table
Folder_A="/home/if_test/tpc/tpcds-kit-master/data"
for file_a in ${Folder_A}/*
do
temp_file=`basename $file_a`
# #是截取右边 %是左边
fn=${temp_file%.*}
hdfs dfs -mkdir /sqtest/rpctest/$fn
hdfs dfs -put $Folder_A/$temp_file /sqtest/rpctest/$fn
done
linux命令
zip
zip -d <file_name>.jar META-INF/.RSA META-INF/.DSA META-INF/*.SF
sql service
遍历所有数据库(查询符合命名规则的sp)
此处有借鉴别人,是谁忘记了,sorry
。
--声明一个变量
declare @db_name as [nvarchar](255);
declare @sql as [nvarchar](1000);
declare @num int;
-- 定义一个临时表
declare @v_temp table (dbname varchar(255),num int)
--声明一个游标用来遍历查询到的结果
declare C_name CURSOR for select name from sysdatabases;
--打开游标
open C_name;
--获取游标指向的数据
fetch next from C_name into @db_name;
--使用游标遍历集合
while @@FETCH_STATUS = 0
BEGIN
--执行具体的操作
print @db_name;
set @sql = 'select '''+@db_name+ ''',count(name) from '+@db_name+ '.sys.objects where name like ''BCC_%''';
--exec sp_executesql @num=@sql;
insert into @v_temp exec sp_executesql @sql;
--游标指向下一条数据
FETCH next from C_name into @db_name;
END
--关闭游标
CLose C_name;
--释放游标
DEALLOCATE C_name;
truncate table DWCommon.dbo.BCC_SPS;
insert into DWCommon.dbo.BCC_SPS select dbname from @v_temp where num >0