11 2022 档案

HIVE-CREATE TABLE
摘要：(1) create table 表A as select 字段 from 表B; (2) create table 表A stored as parquet as select 字段 from 表B; 阅读全文
posted @ 2022-11-04 17:56 冉溪 阅读(358) 评论(0) 推荐(0)
HIVE-文字提取
摘要：regexp_extract(filed,('aaa|bbb|ccc|ddd'),0) 从字段filed中提取含有aaa或bbb或ccc或ddd的string信息 阅读全文
posted @ 2022-11-03 18:01 冉溪 阅读(145) 评论(0) 推荐(0)
HIVE- set
摘要：SET hive.execution.engine = tez;SET hive.tez.auto.reducer.parallelism = true;SET hive.auto.convert.join = true;set hive.exec.compress.output = true;se 阅读全文
posted @ 2022-11-03 17:59 冉溪 阅读(114) 评论(0) 推荐(0)