Datagrip配置

1. 配置自定义补全提示

参考 : 参考

2.常用提示

提示	语句	备注
gg	GROUP BY GROUPING SETS	hive
sel	SELECT * FROM
selcw	SELECT COUNT(1) FROM WHERE
sct	SHOW CREATE TABLE
gc	SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR ‘,’) FROM information_schema.COLUMNS WHERE TABLE_NAME = ‘表名’ AND TABLE_SCHEMA = ‘库名’ GROUP BY TABLE_NAME	mysql获取列名
sb

spark2-submit
–class com.lvshou.cust_pic.customer_label_details
–master yarn
–deploy-mode client
–num-executors 10
–executor-memory 15G
–executor-cores 5
–driver-memory 3G
–queue root.query.root
/home/dmp/dengshuwen/data_warehouse/jar/customer_portrait-1.0-SNAPSHOT-jar-with-dependencies.jar >> ./customer_label_details.log 2>&1