当前位置： 首页 > news >正文

Hive-vscode-snippets

news 2025/7/28 6:08:16

为了提高写HiveSQL的体验,这里通过Qwen3Coder生成了一个vscode的snippets.
欢迎体验:

关于如何创建,修改snippets,可以搜索下

{"Hive Create Table": {"prefix": "hive_create","body": ["CREATE TABLE IF NOT EXISTS ${1:table_name} (","\t${2:column1} ${3:string},","\t${4:column2} ${5:int}",")","COMMENT '${6:Table description}'","ROW FORMAT DELIMITED","FIELDS TERMINATED BY '${7:\\t}'","LINES TERMINATED BY '${8:\\n}'","STORED AS ${9:TEXTFILE};"],"description": "创建Hive表基础模板"},"Hive Create Table with Partition": {"prefix": "hive_create_partition","body": ["CREATE TABLE IF NOT EXISTS ${1:table_name} (","\t${2:column1} ${3:string},","\t${4:column2} ${5:int}",")","COMMENT '${6:Table description}'","PARTITIONED BY (${7:partition_col} ${8:string})","ROW FORMAT DELIMITED","FIELDS TERMINATED BY '${9:\\t}'","STORED AS ${10:TEXTFILE};"],"description": "创建带分区的Hive表"},"Hive Create External Table": {"prefix": "hive_create_external","body": ["CREATE EXTERNAL TABLE IF NOT EXISTS ${1:table_name} (","\t${2:column1} ${3:string},","\t${4:column2} ${5:int}",")","COMMENT '${6:Table description}'","LOCATION '${7:/path/to/data}';"],"description": "创建外部表"},"Hive Drop Table": {"prefix": "hive_drop","body": ["DROP TABLE IF EXISTS ${1:table_name};"],"description": "删除Hive表"},"Hive Drop Database": {"prefix": "hive_drop_db","body": ["DROP DATABASE IF EXISTS ${1:database_name} CASCADE;"],"description": "删除Hive数据库"},"Hive Select Basic": {"prefix": "hive_select","body": ["SELECT ${1:*} FROM ${2:table_name}${3: LIMIT 10};"],"description": "基本SELECT查询"},"Hive Select with Where": {"prefix": "hive_select_where","body": ["SELECT ${1:column1, column2}","FROM ${2:table_name}","WHERE ${3:condition};"],"description": "带WHERE条件的SELECT查询"},"Hive Select with Group By": {"prefix": "hive_select_group","body": ["SELECT ${1:group_column}, COUNT(*) as count","FROM ${2:table_name}","GROUP BY ${3:group_column}","ORDER BY ${4:count DESC};"],"description": "带GROUP BY的SELECT查询"},"Hive Insert Overwrite": {"prefix": "hive_insert_overwrite","body": ["INSERT OVERWRITE TABLE ${1:target_table}","SELECT ${2:*} FROM ${3:source_table}${4: WHERE condition};"],"description": "覆盖插入数据"},"Hive Insert Into": {"prefix": "hive_insert_into","body": ["INSERT INTO TABLE ${1:target_table}","SELECT ${2:*} FROM ${3:source_table}${4: WHERE condition};"],"description": "追加插入数据"},"Hive Load Data": {"prefix": "hive_load","body": ["LOAD DATA ${1:LOCAL} INPATH '${2:/path/to/file}'","${3:OVERWRITE} INTO TABLE ${4:table_name}${5: PARTITION (partition_col='value')};"],"description": "加载数据到表中"},"Hive Alter Table Add Column": {"prefix": "hive_alter_add","body": ["ALTER TABLE ${1:table_name} ADD COLUMNS (${2:column_name} ${3:string} COMMENT '${4:comment}');"],"description": "添加列到表中"},"Hive Alter Table Rename": {"prefix": "hive_alter_rename","body": ["ALTER TABLE ${1:old_table_name} RENAME TO ${2:new_table_name};"],"description": "重命名表"},"Hive Show Tables": {"prefix": "hive_show_tables","body": ["SHOW TABLES${1: LIKE '${2:pattern}'};"],"description": "显示表列表"},"Hive Describe Table": {"prefix": "hive_desc","body": ["DESCRIBE ${1:table_name};"],"description": "描述表结构"},"Hive Describe Extended": {"prefix": "hive_desc_ext","body": ["DESCRIBE EXTENDED ${1:table_name};"],"description": "详细描述表信息"},"Hive String Functions": {"prefix": "hive_string_funcs","body": ["-- 字符串函数示例","SELECT ","\tconcat(${1:col1}, ${2:col2}) as concatenated,","\tupper(${3:col}) as upper_case,","\tlower(${4:col}) as lower_case,","\tlength(${5:col}) as str_length,","\tsubstring(${6:col}, ${7:start_pos}, ${8:length}) as substr,","\tsplit(${9:col}, '${10:delimiter}') as split_array","FROM ${11:table_name};"],"description": "常用字符串函数"},"Hive Date Functions": {"prefix": "hive_date_funcs","body": ["-- 日期函数示例","SELECT ","\tcurrent_date() as today,","\tcurrent_timestamp() as now,","\tdate_add(${1:date_col}, ${2:days}) as date_plus,","\tdate_sub(${3:date_col}, ${4:days}) as date_minus,","\tdatediff(${5:date1}, ${6:date2}) as date_diff,","\tyear(${7:date_col}) as year_part,","\tmonth(${8:date_col}) as month_part,","\tday(${9:date_col}) as day_part","FROM ${10:table_name};"],"description": "常用日期函数"},"Hive Math Functions": {"prefix": "hive_math_funcs","body": ["-- 数学函数示例","SELECT ","\tround(${1:col}, ${2:decimal_places}) as rounded,","\tceil(${3:col}) as ceiling,","\tfloor(${4:col}) as floor_value,","\tabs(${5:col}) as absolute,","\tsqrt(${6:col}) as square_root,","\tpower(${7:col}, ${8:exponent}) as power_value","FROM ${9:table_name};"],"description": "常用数学函数"},"Hive Aggregate Functions": {"prefix": "hive_agg_funcs","body": ["-- 聚合函数示例","SELECT ","\tcount(${1:*}) as total_count,","\tcount(distinct ${2:col}) as distinct_count,","\tsum(${3:col}) as sum_value,","\tavg(${4:col}) as average_value,","\tmin(${5:col}) as min_value,","\tmax(${6:col}) as max_value","FROM ${7:table_name}","GROUP BY ${8:group_column};"],"description": "常用聚合函数"},"Hive Window Functions": {"prefix": "hive_window_funcs","body": ["-- 窗口函数示例","SELECT ","\t${1:col},","\trow_number() OVER (PARTITION BY ${2:partition_col} ORDER BY ${3:order_col}) as row_num,","\trank() OVER (PARTITION BY ${4:partition_col} ORDER BY ${5:order_col}) as rank_val,","\tdense_rank() OVER (PARTITION BY ${6:partition_col} ORDER BY ${7:order_col}) as dense_rank_val,","\tlead(${8:col}, 1) OVER (PARTITION BY ${9:partition_col} ORDER BY ${10:order_col}) as next_val,","\tlag(${11:col}, 1) OVER (PARTITION BY ${12:partition_col} ORDER BY ${13:order_col}) as prev_val","FROM ${14:table_name};"],"description": "常用窗口函数"},"Hive Join Operations": {"prefix": "hive_join","body": ["SELECT ${1:t1.col1, t2.col2}","FROM ${2:table1} t1","${3:INNER JOIN} ${4:table2} t2 ON t1.${5:join_key} = t2.${6:join_key}","${7:WHERE condition};"],"description": "JOIN操作"},"Hive Left Join": {"prefix": "hive_left_join","body": ["SELECT ${1:t1.col1, t2.col2}","FROM ${2:table1} t1","LEFT JOIN ${3:table2} t2 ON t1.${4:join_key} = t2.${5:join_key}","${6:WHERE condition};"],"description": "LEFT JOIN操作"},"Hive Case When": {"prefix": "hive_case","body": ["CASE ","\tWHEN ${1:condition1} THEN '${2:value1}'","\tWHEN ${3:condition2} THEN '${4:value2}'","\tELSE '${5:default_value}'","END AS ${6:new_column}"],"description": "CASE WHEN条件语句"},"Hive Multi-line Comment": {"prefix": "hive_comment_multi","body": ["/*"," * ${1:Multi-line comment}"," * ${2:Add more comments here}"," */"],"description": "多行注释"},"Hive Single-line Comment": {"prefix": "hive_comment_single","body": ["-- ${1:Single line comment}"],"description": "单行注释"},"Hive CTE (Common Table Expression)": {"prefix": "hive_cte","body": ["WITH ${1:cte_name} AS (","\tSELECT ${2:*}","\tFROM ${3:table_name}","\tWHERE ${4:condition}",")","SELECT ${5:*} FROM ${6:cte_name}${7: WHERE condition};"],"description": "公用表表达式(CTE)"},"Hive Create Database": {"prefix": "hive_create_db","body": ["CREATE DATABASE IF NOT EXISTS ${1:database_name}","COMMENT '${2:Database description}'","LOCATION '${3:/path/to/database}';"],"description": "创建数据库"},"Hive Use Database": {"prefix": "hive_use_db","body": ["USE ${1:database_name};"],"description": "切换数据库"},"Hive Show Databases": {"prefix": "hive_show_dbs","body": ["SHOW DATABASES;"],"description": "显示数据库列表"},"Hive Set Properties": {"prefix": "hive_set","body": ["SET ${1:property_name}=${2:property_value};"],"description": "设置Hive属性"},"Hive Set MapReduce Properties": {"prefix": "hive_set_mr","body": ["-- MapReduce相关设置","SET mapreduce.job.queuename=${1:queue_name};","SET mapreduce.job.reduces=${2:reducer_count};","SET hive.exec.reducers.bytes.per.reducer=${3:256000000};"],"description": "MapReduce属性设置"}
}
http://www.lryc.cn/news/599175.html

相关文章：

  • Hive【Hive架构及工作原理】
  • Oracle MCP本地部署测试
  • js实现宫格布局图片放大交互动画
  • [python][flask]flask接受get或者post参数
  • 【调试Bug】网络在训练中输出NaN
  • 关于网络模型
  • 基于深度学习的图像分类：使用DenseNet实现高效分类
  • Lua（数据库访问）
  • 全新轻量化PHP网盘搜索引擎系统源码
  • SAP在未启用负库存的情况下，库存却出现了负数-补充S4 1709 BUG
  • NVM踩坑实录：配置了npm的阿里云cdn之后，下载nodejs老版本（如：12.18.4）时，报404异常，下载失败的问题解决
  • Day31| 56. 合并区间、738.单调递增的数字、968.监控二叉树
  • Chromadb 1.0.15 索引全解析：从原理到实战的向量检索优化指南
  • 规则分配脚本
  • Django集成Swagger全指南：两种实现方案详解
  • k8s的存储之secerts
  • 从零开始：在 PyCharm 中搭建 Django 商城的用户注册与登录功能（轮播图+商品页-小白入门版）
  • Qt 与 SQLite 嵌入式数据库开发
  • mid360连接机载电脑，远程桌面连接不上的情况
  • FunASR实时多人对话语音识别、分析、端点检测
  • 当人机交互迈向新纪元：脑机接口与AR/VR/MR的狂飙之路
  • c++注意点（10）----设计模式（原型）
  • 安装pyarrow包
  • SAP-PP-MRPLIST
  • MyBatis高级应用实战指南
  • Movavi Video Editor v25.9.0 视频编辑软件中文特别版
  • 星图云开发者平台新功能速递 | 页面编辑器：全场景编辑器，提供系统全面的解决方案
  • 纳米编辑器之Nano 编辑器退出**的详细操作指南
  • IAR编辑器如何让左侧的工具栏显示出来？
  • Hive【安装 01】hive-3.1.2版本安装配置（含 mysql-connector-java-5.1.47.jar 网盘资源）