- 博客(7)
- 收藏
- 关注
RSS订阅原创 sqlserver按字符分隔，取最后一部分
数据：/aa/bb/ccc/gddrselect reverse(substring(reverse(字段),1,charindex('/',reverse(字段))-1)) ;
2020-09-17 16:17:48
1207
原创 sqoop导入错误：Hive does not support the SQL type for column col_name
从RDBMS导入hive时报错加参数–map-column-hive 列名=string例sqoop import --connect jdbc:mysql://10.1.32.34:3306/dicts \--username sqoop --password sqoop \-m 1 --table ua \--hive-import --hive-overwrite \--hive-table ua --map-column-hive userid=string参考：https:
2020-08-17 10:42:56
448
原创 java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@44f16719 is still active.
sqoop 导入mysql 表时,出现以下异常:19/07/28 07:44:44 ERROR manager.SqlManager: Error reading from database: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@1ea9f6af is still active. No statements may be issued when any streaming result sets
2020-07-30 11:47:53
808
原创 sqoop导入报错
sqoop version 1.4.7-cdh6.3.2ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Generating splits for a textual index column allowed only in case of “-Dorg.apache.sqoop.splitter.allow_text_splitter=true” property passed
2020-05-20 15:42:04
461
原创 logstash 嵌套解析kv数据
input{ ...}filter{ kv{ source=>"message" field_split => " " value_split => ":" }}filter{ kv{ source=>"header" //header字段是message里面包含的字段，此字段内容可以继续切分 field_s...
2020-05-06 17:08:52
1657
原创 hive 四舍五入取整
round()函数round(23.5,0)第二个参数是至少保留几位小数，这个函数最少有一位小数，而向上取整 向下取整则没有，所以只要整数时需要cast(round(23.5,0) as int)结果是：24...
2020-04-24 10:52:16
2015
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人