摘要:
spark-submit 任务提交 spark-submit \--class sparksql.Oracle_Sqs_Hive \--master yarn \--deploy-mode cluster \/home/spark/333.jar 几个重要的参数说明: (1)executor_cor 阅读全文
摘要:
官网(最好谷歌打开):https://cwiki.apache.org/confluence/display/Hive/HiveWebInterface 注意官网内容:HWI is only available in Hive releases prior to 2.2.0. It was remo 阅读全文
摘要:
修改日期格式为年月日时分秒: alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') as nowTime from dual; //日期转化为 阅读全文
摘要:
set @rn=0; SELECT @rn:=@rn+1 序号, ryxm `人员姓名`, cylb `成员类别`, gzdw `工作单位`, zc `职称`, GROUP_CONCAT(zzqmc) AS `著作权名称`--多字段合并到一起 FROM (SELECT VCA.ryxm ryxm, 阅读全文